UAS Sistem Basis Data

To resolve a 2nd Normal Form violation, we:

• Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity.

• Move the attribute that violates 2nd Normal Form to a new ERD.

• Do nothing, an entity does not need to be in 2nd Normal Form.

• Delete the attribute that was causing the violation.

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT

ATTRIBUTES:

#CUSTOMER ID

#STORE ID

STORE LOCATION

DATE

• Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity.

• Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

• Do nothing, it is already in 2nd Normal Form.

• Delete the attribute STORE ID

Any Non-UID attribute must be dependent upon the entire UID. True or False?

• True

• False

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

(Choose all correct answers)

• Entities

• Relationships

• Attributes

• Synonyms

If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?

• True

• False

Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)

(Choose all correct answers)

• Address

• Employee ID

• Social Security Number

• Last Name

An entity could have more than one attribute that would be a suitable Primary UID. True or False?

• True

• False

Examine the following Entity and decide which rule of Normal Form is being violated:

ENTITY: CLIENT

ATTRIBUTES:

# CLIENT ID

FIRST NAME

LAST NAME

ORDER ID

STREET

ZIP CODE

• 1st Normal Form.

• None of the above, the entity is fully normalised.

• 2nd Normal Form.

• 3rd Normal Form.

As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?

• True

• False

The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False?

• True

• False