Design a conceptual database on one of the three scenarios above..
ACME Motors recently opened a new dealership to sell locally here in San Diego in the Poway area. As part of their new setup they will not only sell, but also service and repair ACME vehicles. They are in need of a parts inventory, maintenance and sales system to support their service bay operations.
Unfortunately, they have looked at buying COTS existing packages from ImaginaSoft but found the cost and time to deploy un-acceptable given their impending new launch of the new much sought after ACME Electric Hybrid convertible sports car among other new model lines. They are looking for a crack team of software professionals to come in there and get a small but reliable system up and running to support operations immediately, and then evolve the system as time goes by.
- Design a conceptual database on one of the three scenarios above.
- ER Diagrams in Crow’s foot notation using Visio or graphic modeling software of your choice which include entities and their relationships.
- At least 5 business rules
- An introduction that outlines your proposal of at least 250 words
- A conclusion paragraph of at least 250 words
- Tables created with reasonable representative data values
- Example of five SQL scripts to illustrate your business rules.
Design a conceptual database on one of the three scenarios above.