Chapter 13 & 14.docx - CHAPTER 13 1. What are the...

CHAPTER 13
1. What are the advantages of organizing data storage as separate files?
2. What are the advantages of organizing data storage using database
approach?
3. What are the effectiveness measures of database design?
4. List some examples of entities and their attributes.
ENTITIES ATTRIBUTES
Student ID
Full_Name
DOB
Program_Of_Study
Class Class_ID
Class_Name
Program
Number_Of_Students

4. What is the difference between a primary key and an object
identifier?
6. Define the term metadata. What is the purpose of metadata?
7. List types of commonly used conventional files. Which of these are
temporary files?
7. Name the three main types of database organization. 8. Define the term normalization.
10.What is removed when a relation is converted to the first normal form?
11. What is removed when a relation is converted from 1NF to 2NF?
12. What is removed when a relation is converted from 2NF to 3NF?

13.List the three entity constraints. In a sentence, describe the
meaning of each entity constraint.
14.Describe the four anomalies that may occur when creating
database tables.