Term
(1) How many tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?[image] |
|
Definition
|
|
Term
(2) How many bridge tables will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
[image] |
|
Definition
|
|
Term
| (3) How many columns will the relation DRIVER have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?[image] |
|
Definition
|
|
Term
(4) How many columns will the relation TRUCK have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
[image] |
|
Definition
|
|
Term
(5) How many columns will the relation REGION have in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram?
[image] |
|
Definition
|
|
Term
(6) How many foreign keys will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
[image] |
|
Definition
|
|
Term
(7) How many foreign keys in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram serve as a component of a primary key?
[image] |
|
Definition
|
|
Term
| (8) How many tables in the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram will have composite primary keys?[image] |
|
Definition
|
|
Term
(9) How many unique non-primary key columns will the relational schema mapped from the Eaglerun Trucking Dispatcher ER diagram have?
[image] |
|
Definition
|
|
Term
(10) What is the minimal number of records that can be entered in the database whose relational schema is mapped from the Eaglerun Trucking Dispatcher ER diagram?
[image] |
|
Definition
|
|
Term
Which attribute of an entity contains a collection of attributes:
A) Unique attribute
B) Composite attribute
C) Multivalued attribute
D) Derived attribute |
|
Definition
|
|
Term
Maximum cardinality can be:
A) One or many
B) Zero or many
C) Optional or mandatory
D) Optional or many |
|
Definition
|
|
Term
Minimum cardinality can be:
A) One or many
B) Zero or many
C) Optional or mandatory
D) Optional or many |
|
Definition
|
|
Term
Which of the following is a possible type of relationship (maximum cardinality-wise)?
A) One-to-one
B) Zero-to-zero
C) Zero-to-one
D) Zero-to-many |
|
Definition
|
|
Term
Relationship attributes may be necessary in a relationship of what type?
A) One-to-one
B) One-to-many
C) Zero-to-many
D) Many-to-many |
|
Definition
|
|
Term
Which of the following is a legitimate exact minimum and maximum cardinality?
A) (20, 10)
B) (5, 0)
C) (5, 10)
D) (5, 4) |
|
Definition
|
|
Term
How many entities are involved in a unary relationship?
A) 1
B) 2
C) More than 2
D) Between 1 and 2 |
|
Definition
|
|
Term
How many entities are depicted by the following requirements?
School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms.
A) 3
B) 4
C) 115
D) 116 |
|
Definition
|
|
Term
9) A multivalued composite attribute can be used to depict which of the following weak entity concepts?
A) Partially unique attribute
B) Identifying relationship
C) A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity
D) A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity |
|
Definition
|
|
