Pop Quiz 3 (DFC20203)

Choose the correct symbol for weak entity.

• 
• 
• 
• 

What is the condition for 2NF?

• no multi-value attributes

• no partial dependency

• no transitive dependency

• no functional dependency

What is the condition for 3NF?

• no multi-value attributes

• no partial dependency

• no transitive dependency

• no functional dependency

Identify the attribute type for student's address which may consists city, zip code and state.

• derived attribute

• composite attribute

• multi-value attribute

• simple attribute

How to represent an optional participation in ERD?

• use diamond shape

• use a circle shape

• use a rectangle shape

• use a dotted line

Based on the statement below, determine the relationship cardinality.

"An author may write several books and a book may be written by more than one author"

• one to one

• one to many

• many to many

• many to one

Determine the ERD element shown below:

• weak attribute

• multi-value attribute

• derived attribute

• composite attribute

Three types of anomaly such as update, delete and insertion may occur in un-normalized table. Identify the problem caused by update anomaly.

• repeating columns

• unintended data loss

• data inconsistency

• excessive data storage

What is ternary relationship?

• a relationship between two entities

• a relationship between three entities

• a relationship between two entities and on attribute

• a relationship between three entities and three attributes

A sales representative may act as an agent for multiple clients, while each customer is overseen by a single sales representative.

• one to one

• one to many

• many to many

• many to one