This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Entity-Relationship Diagram Problems (r5/21/10ba)
NAME: _______________________ Sec: __
Print this page, then handwrite your notations and answers to turn in during class.
Based on the narratives, add the cardinality (one or many) symbols to each of the entity-relationship
diagrams. On questions 4 and 5, circle the appropriate choice for each multiple-choice question.
1. Sometimes people finance their cars through a bank. A car may only be financed by one bank. Bank Fi nance s Ca r 2. BYU often offers several sections for a particular course, but a section cannot exist without a
course. Course Has Se cti on 3. Each student is only allowed to register for one section of a course, but there are possibly many
students in the section. Stude nt Re gi ste rs
for Se cti on 4. A professor may teach several sections of a course, but excluding team-teaching classes, only
one professor teaches each section. P rofessor Tea ches Se cti on Based on the description above, what is the maximum cardinality between each instance of
“Professor” and “Section?”
a. Professor(1) – (1)Section
b. Professor(m) – (1)Section
c. Professor(1) – (m)Section
d. Professor(m) – (m)Section ERD and Table Mapping
Copyright Bonnie Anderson and BYU 1 5. An athlete may play on several teams, and each team needs at least one player. Athlet e P lays
for Te am Based on the description above, what is the maximum cardinality between each instance of
“Athlete” and “Team?”
a. Athlete(1) – (1)Team
b. Athlete(m) – (1)Team
c. Athlete(1) – (m)Team
d. Athlete(m) – (m)Team
ER Mapping Problems:
Map the following diagrams to tables:
6. Po sitio n
Salar y Ha s Em
Na me 7. Li neIte m
Ite mNo(P K)
De scriptio n ERD and Table Mapping
Copyright Bonnie Anderson and BYU Invoi ce
Co mpri se s 2 Invoi ce No(P K)
Custo merN ame ...
View Full Document
This document was uploaded on 11/22/2011.
- Spring '09