Practice Quiz 1
A relationship connects an entity type to itself is called A. a unary relationship B. a binary relationship C. a ternary (n-ary) relationship
A
Each employee is associated with one login and each login is associated with one employee is an example of A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship
A
In the Object-Oriented class diagram notation, the number after two dots is the relationship maxima (maximum cardinality). A. True B. False
A
In the crow-foot notation, the symbol closer to the entity type is the relationship maxima (maximum cardinality). A. True B. False
A
The cardinality of a relationship determines how many instances of one entity can or must be associated with each instance of another entity. A. True B. False
A
The relationship maxima (maximum cardinality) is either one or many. A. True B. False
A
The relationship minima (minimum cardinality) is either optional (zero) or mandatory (one). A. True B. False
A
Which of the following is NOT a valid relationship type determined by the relationship maxima (maximum cardinality) in the conceptual data model? A. zero-to-zero B. One-to-one C. one-to-many D. many-to-many
A
A relationship connects three entity types is called A. a unary relationship B. a binary relationship C. a ternary (N-ary) relationship
C
Each employee can process many customer orders and each customer order can be processed by many employees is an example of A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship
C
Each relationship can connect A. only two entity types in a conceptual data model. B. only three entity types in a conceptual data model. C. practically an unlimited number of entity types in a conceptual data model.
C
Quantity Ordered and Unit Price Charged are typical examples of attributes of ________________ in a conceptual data model that supports customer order processing. A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship
C
Which of the following can have attributes? A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship
C
Which of the following information requires a relationship between entity types? A. How many compact cars do we have ? B. What is last name and first name of Employee #1? C. Which customer orders requested which products?
C
A connection between entity types or a connection between entity instances are generally called A. an attribute B. a relationship
B
A relationship connects two entity types is called A. a unary relationship B. a binary relationship C. a ternary (n-ary) relationship
B
Each employee can add many customer records and each customer record is added by only one employee is an example of A. One-to-one relationship B. One-to-many relationship C. Many-to-many relationship
B
In the Object-Oriented class diagram notation, the number after two dots is the relationship minima (minimum cardinality). A. True B. False
B
In the crow-foot notation, the symbol closer to the entity type is the relationship minima (minimum cardinality). A. True B. False
B
The relationship maxima (maximum cardinality) can be zero. A. True B. False
B
Unit Price of Product #1 and Unit Price Charged of Product #1 on all customer orders are always the same so you need to have Unit Price in Product entity type only. A. True B. False
B
You should have the Quantity Ordered attribute in Customer Order entity type when a customer can request many products on one order. A. True B. False
B
You should have the Quantity Ordered attribute in Product entity type when each product can be requested by many customer orders. A. True B. False
B
