Assignment Task: Sun auto Sale is a car dealership. This business fixes cars and sells them for customer.
- A salesperson may sell many cars, but each car is sold by only one salesperson.
- A customer may buy many cars, but each car is bought by only one customer.
- A salesperson writes a single invoice for each car he or she sells.
- A customer gets an invoice for each car he or she buys.
- A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer.
- When a customer takes one or more cars in for repair or service, one service ticket is written for each car.
- The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the car's serial number.
- A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars.
1. Create a database base on the information above.
2. Design the basic database structure using Access and SQ
3. At least 2 Tables
4. At least one relationship
5. Form(s) to enter and edit records.
6. At least one Query to produce a result you listed as an outcome in your project plan.
7. At least one Report.