Chapter 07_Basics_Autocare

Chapter 07_Basics_Autocare - Assignments 1 Create an ERD...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Basics AutoCare Chapter 7 Basics AutoCare is a small auto service business with two locations in a Midwest (U.S.) city. The business is based on providing routine maintenance at fixed cost to car owners. The owners have decided to computerize their operations to allow them to better track their business. Data to be gathered for each service visit includes service ID, service item, service item cost, vehicle owner, owner telephone number, vehicle make and model, vehicle year, and date of service.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Assignments: 1. Create an ERD for the auto service system . 2. Create 3NF table designs for the system. 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. 4. Use sample data to populate the fields for three records....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online