The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 1 Day Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
Assignment 9
Â
ABC Auto Care is a small service business with three service locations in a New England city. This business provides routine car maintenance at a fixed cost to its customers. ABC would like to computerize its services so that they can more efficiently keep records of their business. Each service visit includes the following data elements: Service ID number,  Date of service,  Service item description, Customer number, Customer phone number, Vehicle make, Vehicle model.
Â
Assignments
1. Â Create an ERD for this system
2. Create normalized 3NF table designs for the system. See page 297 in your textbook.
3. Provide reasonable sample data for three records in each 3NF record layout
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly