Section 7 Database Design

ARCS
Which of the following is the definition for Third Normal Form?
No non-UID attribute can be dependent on another non-UID attribute
          
If the entity CD has the attributes: #number, *title, *producer, *year, o store name, o store address, this entity is in 3rd Normal Form ("no non-UID attribute can be dependent on another non-UID attribute). True or False?
False
          
Which of the following can be added to a relationship?
An arc can be assigned
          
To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.
Arc
          
Which of the following would best be represented by an arc?
STUDENT ( University, Trade School)
          
Secondary UID's are
Useful as an alternative means identifying instances of an entity
          
All parts of a UID are mandatory. True or False?
True
          
This diagram could also be expressed as a supertype/subtype construction. True or False?
False
          

HIERARCHIES AND RECURSIVE RELATIONSHIPS
A recursive rationship should not be part of a UID. True or False?
True
          
Which of the following would be a good Unique Identifier for its Entity?
Identification Number for Person
Birthdate for Baby Which Includes Hour, Minute, and Seconds

A relationship can be both recursive and hierachal at the same time. True or False?
False
          
In this simple diagram, what comprises the unique identifier for the student class entity?
student id and course id
          

MODELING HISTORICAL DATA

Historical data should always be kept. True or False?
False
          
Which of the following scenarios should be modeled so that historical data is kept?
LIBRARY and BOOK
STUDENT and GRADE
          
Modeling historical data can produce a unique identifier that includes a date. True or False?
True
          
Audit trail attributes cannot be placed in the entities they are auditing, they must be placed in separate, new entities, created just for that purpose. True or False?
False