Chapter5 review.docx

5 Pages
Unlock Document

Business Administration
BUS 237
Kamal Masri

Chapter5 Q1: What is content? Content is property. It is often closely related to intellectual property, which in Canada is defined as a form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography. ----- Content varies by industry. ----- The expanding volume of content and the growing number of formats in which it is provided can make it difficult for individuals and corporations to effectively utilize that content. Managing content is therefore am important challenge for business students to understand and appreciate. Content The data, graphics, sound, images, and video that areof importance to the organization Content Management Creating, storing, and editing the content anorganization has captured. Q2: How can content be organized? The challenge in content management is indexing or cataloguing the right information, processing, and storing it, and then getting it to the right person in the right format at the right time. ----- One way of thinking about content management is to separate the management of content data from the presentation of content.将要展现的信息分类,保存 The management of many types of data has traditionally been handled through organizational database management systems. These DBMS are central to the management of content data. Content management includes Database management systems (DBMS) • Enables integration with multiple applications Content management system (CMS) • Used to format the presentation of data to a uniformstandard Q3: What is the purpose of a database? A database keeps track of things. Different between using spreadsheet and database: Lists that involve a single theme can be stored in a spreadsheet; lists that involve multiple themes require a database. To summarize, the purpose of a database is to keep track of things that involve more than one theme. Q4: What does a database contain? A database is self-describing collection of integrated records. Bit: smallest unit is a bit which represents either 1 or 0. Byte: a byte = 8 bits the most common storage unit. A byte is a character of data. Bytes are grouped into columns, also called fields. -----A field is a representation of one fact that is an attribute of a thing or an event. For example: student number and student name. A record is a group of logically related field. For example: (student name, student number, HW1, HW2, and midterm) The collection of data for all columns (student name, student number, HW1, HW2, and midterm) is called a row or a record. Finally, a group of similar rows or records is called a table or a file. A database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadata, that describe the structure of the database. A database is a set of tables that are related logically. Databases are normally stored on magnetic disks.  Relationships among records A key is a column or group of columns that identifies a unique row in a table. ----- Every table must have a key. Columns that fulfill a role like that of student number in the email and Office Visit table are called foreign keys. This term is used because such columns are keys, but they are keys of a different (foreign) table from the one in which they reside. Databases that carry their data in the form of tables and that represent relationships using foreign keys are called relational databases.  Metadata Databases are self-describing: it means that a database contains, within itself, a description of its contents. Metadata are data that describe data ---- makes data
More Less

Related notes for BUS 237

Log In


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.