Section 6 Oracel Quiz

Test: Quiz: Artificial, Composite and Secondary UIDs

1. A unique identifier can only be made up of one attribute. True or False?

• True
• False (*)

2. An entity can only have one UID. True or False?

• True
• False (*)

3. People are not born with “numbers”, but a lot of systems assign student numbers, customer IDs, etc.ﾠA shoe has a color, a size, a style, but may not have a descriptive “number”. So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created.

• artificial (*)
• unrealistic
• structured
• identification

4. A UID can be made up from the following: (Choose Two)

• Attributes (*)
• Entities
• Relationships (*)
• Synonyms

Test: Quiz: Normalization and First Normal Form

1. When data is stored in more than one place in a database, the database violates the rules of ___________.

• Normalization (*)
• Replication
• Normalcy
• Decency

2. An entity can have repeated values and still be in 1st Normal Form. True or False?

• True
• False (*)

3. The following entity is on 1st normal form: True or False?

ENTITY: VEHICLE

ATTRIBUTES:
REGISTRATION
MAKE
MODEL
COLOR
DRIVER
PASSENGER 1
PASSENGER 2
PASSENGER 3

• True
• False (*)

4. When all attributes are single-valued, the database model is said to conform to:

• 1st Normal Form (*)
• 2nd Normal Form
• 3rd Normal Form
• 4th Normal Form

Test: Quiz: Second Normal Form
1. What is the rule of Second Normal Form?

• All non-UID attributes must be dependent upon the entire UID (*)
• Some non-UID attributes can be dependent on the entire UID
• No non-UID attributes can be dependent on any part of the UID
• None of the Above

2. Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:

ENTITY: CLASS

ATTRIBUTES:
&nbspCLASS ID
&nbspDURATION
&nbspSUBJECT
&nbspTEACHER NAME AND ADDRESS

• CLASS ID
• DURATION
• SUBJECT
• TEACHER NAME AND ADDRESS (*)

3. All instances of the subtypes must be an instance of the supertype.

• True (*)
• False

4. Not all instances of the supertype are instances of one of the subtypes.

• True
• False (*)

5. A supertype should have at least two subtypes.

• True (*)
• False

6. An entity can be on 2nd Normal Form even if it has repeated values. True or False?

• True
• False (*)

Test: Quiz: Third Normal Form

1. Examine the following Entity and decide which sets of attributes breaks the 3rd Normal Form rule: (Choose Two)

ENTITY: TRAIN (SYNONYM: ROLLING STOCK)

ATTRIBUTES:
TRAIN ID
MAKE
MODEL
DRIVER NAME
DEPARTURE STATION
NUMBER OF CARRIAGES
NUMBER OF SEATS
DATE OF MANUFACTURE

• TRAIN ID, MAKE
• DEPARTURE STATION, DRIVER NAME (*)
• NUMBER OF CARRIAGES, NUMBER OF SEATS
• MODEL, DATE OF MANUFACTURE

2. As a database designer it is your job to store data in only one place and the best place. True or False?

• True (*)
• False

3. No databases in the world is ever truly on 3rd Normal Form. Everyone always stops after 2nd Normal Form. True or False?

• True
• False (*)