Create a simple ERD for a car dealership. Convert the diagram to a PDF file. The dealership sells both new and used cars, and it
operates a service facility. Base your design on the followirg business rules: A salesperson may sell many cars, but each car is sold by only Acustomer may buy many cars, but each car is bought by only 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. Acustomer may come in just to have his or her car serviced; that is, a customer need not buy a car to one salesperson one customer. 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. Acar brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. Acar that is serviced may or may not need parts
1 answer:
You might be interested in
Answer:
see explaination and attachment
Explanation:
We can say that a Gantt chart is a visual view of tasks scheduled over time. Gantt charts are used for planning projects of all sizes and they are a useful way of showing what work is scheduled to be done on a specific day.
see attachment for the detailed step by step solution.
