ERD_Problems

ERD_Problems - Entity-Relationship Diagram Problems...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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 Title(P K) Salar y Ha s Em plo yee SSN(P K) 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.

Page1 / 2

ERD_Problems - Entity-Relationship Diagram Problems...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online