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
- Spring '11
- Foreign key, Automobile, Candidate key, Midwest, small auto service