Textbook Notes (362,879)
Canada (158,081)
BUS 237 (186)
Chapter 5

Chapter 5 Notes.docx

6 Pages
Unlock Document

Simon Fraser University
Business Administration
BUS 237
Maryam Ficociello

Bus 237- Chapter 5 Chapter 5: Database and Content Management Q1. What is Content? Intellectual property: A form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography - Content is property, closely related to intellectual property which in Canada is defined as a form of creative endeavour that can be protected through trademark, , patent, copyright, industrial design or integrated circuit topography - Content varies by industy, for example, for advertising their content is: pictures, commercials and text used to promote ideas about a product/company - Organizations have databases in which they store large amounts of data related to customers, employees and orders etc..  These include word docs, spreadsheets, presentations, text from blogs/ discussion boards, video files, audio files and so on.. - “the website” is said to be the critical part of customer support and is a way to help their brand Q2. How can content be organized? - Challenge of content management: indexing/cataloguing the right information and storing it and getting it to the right person on time - The DMBS are central to the management of content data Content Management System (CMS): An information system that tracks organizational documents, web pages, graphics and related materials  This is usually located on the company’s website server  The content and presentation are stored with the help of a DBMS  The CMS helps manage each step of this process and enables a company to standardize the look and feel of a website and control the information available to customers and employees - Media files, word-processing docs, html pages and other docs can be categorized and searched by CMS Bus 237- Chapter 5 Q3. What is the Purpose of a Database? - Database keeps track of things that involve more than one theme - Lists that involve multiple themes—it shows student grades, emails, and office visits— require a database - Lists that involve a single theme—just students grades—can be stored on a spreadsheet Q4. What does a Database contain? Database: A self-describing collection of integrated records Byte: (1) a Character of data (2) An-8 bit chunk  Bytes are grouped into columns Columns: Also called fields or groups of bytes. A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber, EmployeeName and SalesDate Fields: Also called columns, groups of bytes in a database table. A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber, EmployeeName and SalesDate Rows: Also called records, groups of columns in a database table Records: Also called rows, groups of columns in a database table Table or file: Also called a file, a group of similar rows or records in a database - A database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadata, that describe structure of the database - The cylindrical symbol of a database shown on page 116, represents a computer disk drive Relationships among Records - In the example shown on page 117, you see that in one table relates rows of that table to rows in a second table Key: (1) A column or group of columns that indentifies a unique row in a table (2) A number used to encrypt data. The encryption algorithm applies the key to the original message to produce the coded message. Decoding (decrypting) a message is similar; a key is applied to the coded message to recover the original text - A student number is the key of the student table - Every table must have a key. The key of the email table is email num Foreign keys: A column or group of columns used to represent relationships. Values of the foreign key match values of the primary key in a different (foreign) table - They are keys of a different (foreign) table from the one which they reside Bus 237- Chapter 5 Relational Databases: Database that carries its data in the form of tables and that represents relationships using foreign keys Relation: The more formal name for a database table Metadata Metadata: Data that describes data - In the definition of database, “self-describing” means that a database contains, within itself, a description of its contents  For example, a library is a self-describing collection of books and other materials – self-describing because the library contains a catalogue that describes its contents - Metadata are always part of the database and it records what is in the database. It is also easy to use—for both authorized or unauthorized purposes Q5. What is a DBMS, and what does it do? Database application System: Applications, having the standard 5 components, that make database data more accessible and useful. Users employ a database application that consists of forms, formatted reports, queries, and application programs, Each of these, in turn, calls on the database management system (DBMS) to process the database tables. Database Application: A collection of forms, reports, queries and application programs that process a database The Database Management System Database Management System (DBMS): A program used to create, process and administer database - Almost no organization develops its own DBMS. C
More Less

Related notes for BUS 237

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.