Answer Section 6 Quiz Database Design 2019 Learner - English

Section 6

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 


Delete the attribute STORE ID


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


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


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


Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
ENTITY: CLASS
ATTRIBUTES:
   #CLASS ID
   #TEACHER ID
   SUBJECT
   TEACHER NAME


TEACHER NAME(*)


SUBJECT


TEACHER ID


CLASS ID


What is the rule of Second Normal Form?


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

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

True(*)


False

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

True


False(*)

The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.


No, it is not possible to have more than one UID for an Entity.


No, each Entity can only have one UID, the secondary one.


Yes, this is the way UID's are named.(*)


No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.


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

True(*)


False


An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False?

True


False(*)


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

True


False(*)


Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?

True(*)


False

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

2nd Normal Form


1st Normal Form(*)


4th Normal Form


3rd Normal Form


When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:

Non-dependency


Transitive dependency(*)


Dependency


Functional dependency


Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT ORDER
ATTRIBUTES:
    # CLIENT ID
    # ORDER ID
    FIRST NAME
    LAST NAME
    ORDER DATE
    CITY
    ZIP CODE


1st Normal Form.


2nd Normal Form.(*)


3rd Normal Form.


None of the above, the entity is fully normalised.


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


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.(*)


2nd Normal Form.


3rd Normal Form.

None of the above, the entity is fully normalised.