I need some help with this database design assignment. I understand
alot of it but would like to see the solution that a more experienced
designer would implement. The problem is as follows:
Quickie Lube is in the fast oil change business. A service visit
generates an invoice that identifies the customer, the car, the date,
a standard service charge, as well as a list of replaced parts.
Customer and car information are used to provide periodic updates to
customers based on the date of the car?s last service. Quickie Lube
will also replace other needed parts such as windshield wiper blades,
air filters, and fuel filters and hence keeps a parts inventory as
well as a list of active and potential parts vendors.
Design a data model for GU which will include a consideration of the
actions (tests) you will want to be able to make when your database is
created, ie., queries, inserts, deletes, updates and referential
integrity constraints to validate the completion of user requirements.
Construct an initial UML data model that is concerned only with
identifying entities and cardinalities. Then propose the user
requirements which will include a detailed consideration of all of the
possible queries used by the Quickie Lube personnel. Then construct a
more detailed UML data model that includes all the necessary tables,
appropriate keying and referential integrity constraints. This will
be followed by explicit tests that will be run to satisfy the user
requirements presented above. Then write the statements necessary to
implement your database. After creating the database prove it
satisfies the user requirements by running the appropriate tests and
reporting the results.
The work product from this exercise will be the UML diagrams (2)
mentioned above and a word document containing the user requirements
and initially proposed tests, the DDL's for the tables, results of the
tests submitted with an appropriate cover page. |
