ERD_Quiz_and_Key

# ERD_Quiz_and_Key - ERD Quiz QE(r Section Name Bargain Bobs...

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

ERD Quiz: QE (r10/19/05) Section___ Name_________________________ Bargain Bob’s auto dealership sells vehicles. He sells Chrysler, Jeep, and Dodge brand vehicles. He tracks customer and manufacturer. Bob tracks only the main owner—all co-owners and co-signers are recorded elsewhere. 1. Based on the description above, what is the maximum cardinality between each instance of “Customer” and “Vehicle?” a. Customer (1) – (1) Vehicle b. Customer (m) – (1) Vehicle c. Customer (1) – (m) Vehicle d. Customer (m) – (m) Vehicle Customer buys Vehicle makes Manufacturer 2. Based on the description above, what is the maximum cardinality between each instance of “Vehicle” and “Manufacturer?” a. Vehicle (1) – (1) Manufacturer b. Vehicle (m) – (1) Manufacturer c. Vehicle (1) – (m) Manufacturer d. Vehicle (m) – (m) Manufacturer (over) TA grades Section taught by Professor 3. Based on the description above, what is the maximum cardinality between each instance of “TA” and “Section?” a. TA (1) – (1) Section b. TA (m) – (1) Section c. TA (1) – (m) Section

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 10/23/2011 for the course I SYS 201 taught by Professor Meservy during the Fall '11 term at BYU.

### Page1 / 4

ERD_Quiz_and_Key - ERD Quiz QE(r Section Name Bargain Bobs...

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

View Full Document
Ask a homework question - tutors are online