NEW
Font size
WorksheetsPop Quiz 3 (DFC20203)
Total questions: 10
Worksheet time: 5mins
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
