Chapter 07_Basics_Autocare_Solution

Chapter 07_Basics_Autocare_Solution - Basics AutoCare...

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

View Full Document Right Arrow Icon
Basics AutoCare Chapter 7 Solutions 1. Create an ERD for the auto service system . VEHICLE FOR 1 M SERVICE M CUSTOMER REQUEST S 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
2. Create 3NF table designs for the system. Sample 3NF table designs follow. SERVICE_VISIT (SERVICE_ID , VEHICLE-MAKE-AND-MODEL, VEHICLE-YEAR, CUSTOMER-ID, DATE-OF-SERVICE) SERVICE_DETAIL (SERVICE-ID , SERVICE-ITEM, CHARGE) CUSTOMER_ID (CUSTOMER-ID , CUSTOMER-NAME, CUSTOMER-PHONE-NUMBER) 3. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys. Note : See answer to Assignment 4. 4. Use sample data to populate the fields for three records. Note : The solutions for Assignments 3 and 4 have been combined. The first part of the solution shows the table design and keys that were created in Assignment 3. The second part of the solution shows the sample data. a. SERVICE_VISIT (SERVICE_ID , VEHICLE-MAKE-AND-MODEL, VEHICLE-YEAR, CUSTOMER-ID, DATE-OF-SERVICE) Candidate keys: SERVICE-ID is the only candidate key. No other field will identify
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Chapter 07_Basics_Autocare_Solution - Basics AutoCare...

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

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