Chapter 3 Assignment Questions

1. States that you need to use system catalogs to store data.
2. Social Security Number – It is unique to each individual.
3. A retail store. The products would be placed in the rows, and prices and products specific information would be placed into the columns.
4. Information, Guaranteed access, Systematic treatment of null values, Dynamic online catalog based on the relational model, Comprehensive data sublanguage, View updating, High level INSERT, UPDATE, and DELETE, Physical data independence, Logical data independence, Integrity independence, Ditribution independence, Nonsubversion.
5. The need to know the types of data.
6. View updating.
7. Collects data in a tabular format and identifies the primary key of the newly formed table.
8. Reduce data redundancy, increase data manageability, removal of duplicate columns.
9. Oracle
10. Used to manipulate multiple rows of data instead of row by row operations.
11. The language used to manipulate data must not violate any integrity rule or constant defined in the database.
12. States that data must be logically accessible by specifying the table name, column name, and primary key of the row in which the data value is stored.
13. Version 2 is an update to Codd’s original rules.