 |
1 | |
Relationship cardinalities: |
| | A) | Constrain the number of objects that participate in a relationship |
| | B) | Are shown for both directions of a relationship |
| | C) | Indicate whether a relationship is mandatory or optional |
| | D) | All of the above |
|
|
2 | |
In comparing ERD's to relational database diagrams, which of the following statements is true: |
| | A) | Both notations give names to relationships |
| | B) | Both notations show foreign keys |
| | C) | Both notations show minimum and maximum cardinalities |
| | D) | None of the above |
|
|
3 | |
The Hollywood studio BestFlick wants to have a database designed to have access to the following information about all the movies it ever produced: title, yearreleased, director, actors, stuntmen, "Oscars" awarded. A movie has only one director. In this description, the gender is irrelevant. "Actor", "director", "stuntman" can be male or female. "Oscar for best acting" refers to an Oscar for best actor or best actress and also includes best supporting actor or actress.
You would show director OF movie by a: |
| | A) | 1-1 relationship |
| | B) | 1-M relationship |
| | C) | M-N relationship |
| | D) | Ternary relationship (Chen's notation) or associative entity type (Crow's Foot notation) |
|
|
4 | |
You would show actor starring IN movie as a: |
| | A) | 1-1 relationship |
| | B) | 1-M relationship |
| | C) | M-N relationship |
| | D) | Ternary relationship (Chen's notation) or associative entity type (Crow's Foot notation) |
|
|
5 | |
You would show stuntman doing stunts for actor in movie as a: |
| | A) | 1-1 relationship |
| | B) | 1-M relationship |
| | C) | M-N relationship |
| | D) | Ternary relationship (Chen's notation) or associative entity type (Crow's Foot notation) |
|
|
6 | |
Oscar for best director should be: |
| | A) | An attribute of movie |
| | B) | An attribute of director |
| | C) | A 1-1 relationship between movie and director |
| | D) | An M-N relationship between movie and director |
|
|
7 | |
Oscar for best acting would be an attribute of: |
| | A) | Movie |
| | B) | Director |
| | C) | Actor |
| | D) | A relationship "Starring-in" between Movie and Actor |
|
|
8 | |
In an ERD, generalization hierarchies always contain: |
| | A) | Supertypes and subtypes |
| | B) | Disjointness and completeness constraints |
| | C) | Cardinalities |
| | D) | All of the above |
|
|
9 | |
The primary key of an entity type can be: |
| | A) | Directly derived |
| | B) | Borrowed |
| | C) | Inherited |
| | D) | All of the above |
|
|
10 | |
Regarding connection rules for ERD's, which statement is not true: |
| | A) | All relationships connect two entities |
| | B) | Relationships can be connected to other relationships |
| | C) | All entity types participate in at least one relationship |
| | D) | B and C are not true |
|