Section 7
(Answer all questions in this section)

  1. 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?

True

  False 


2. This diagram could also be expressed as a supertype/subtype construction. True or False?
  
True

  False 



  3. Which of the following can be added to a relationship?

An attribute

  An arc can be assigned

A composite attribute

An optional attribute can be created



  4. Secondary UID's are

Not permitted in data modeling

Mandatory in data modeling

  Useful as an alternative means identifying instances of an entity 

Always comprised of numbers



  5. Which of the following would best be represented by an arc?

STUDENT (senior, junior)

STUDENT (graduating, non-graduating)

STUDENT (will-attend-university, will-not-attend-university)

  STUDENT ( University, Trade School) 



  6. Which of the following is the definition for Third Normal Form?

All attributes are single valued

An attribute must be dependent upon entity's entire unique identifier

  No non-UID attribute can be dependent on another non-UID attribute

All attributes are uniquely doubled and independent



  7. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.

  Arc 

UID

Subtype

Supertype



  8. All parts of a UID are mandatory. True or False?

  True 

False