Try Out Basis Data TI-A

an entity can only have one Primary UID. True or False?

• true

• false

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

• true

• false

There is no limit to how many columns can make up an entity's UID. True or False?Mark for Review

• true

• false

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

• true

• false

When is an entity in 2nd Normal Form? Mark for Review

• When all non-UID attributes are dependent upon the entire UID

• When attributes with repeating or multi-values are present.

• When no attritibutes are mutually independent and all are fully dependent on the primary key.

• None of the Above.

What is the rule of Second Normal Form?Mark for Review

• No non-UID attributes can be dependent on any part of the UID.

• Some non-UID attributes can be dependent on the entire UID.

• All non-UID attributes must be dependent upon the entire UID.

• None of the above

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

 Mark for Review

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

• Delete the attribute STORE ID

• 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.

When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as....Mark for Review

• Dependency.

• Functional dependency.

• Non-dependency.

• Transitive dependency.

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

 Mark for Review

• 1st Normal Form.

                 

• 2nd Normal Form.

                

•   3rd Normal Form.

                 

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

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