You have been approached by the owner of Custom Auto Body to help set up an application that will automate the customer work order system. The database application must be accessible via a web browser and the owner of the company only has about $11,500 to spend on software and hardware. Your team's task is to develop the database portion of this new application based on user inputs using an Oracle solution.
1. User Inputs
The following information has been obtained from interviews with the owner of the business.
A customer brings his vehicle to the shop and requests we repair the damage that has been done. The estimator collects the following information:
1.Name
2.Address
3.Insurance Company and policy number
4.Vehicle information
?VIN
?Manufacturer
?Make
?Model
?Year
?Mileage
2. Process of making the repair
This information is placed on the work order along with a statement of the work to be performed.
The customer signs the work order and agrees to pay for the repairs to his/her vehicle. The work order is given to the mechanic who will do the repairs. The mechanic does the repairs and documents each work unit performed, the amount of time spent on each unit and a list of parts used for each unit.When the work is completed, the estimator totals the work hours, parts, and labor and calculates a total amount due for repairs. This amount is placed on an invoice and presented to the customer for payment or sent to the insurance company.
Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:
1.Week 3 - An individual E-R diagram.
2.Week 4 - A group E-R diagram.
3.Week 5 - A group data dictionary.
4.Week 6 - A script that will create the tables and enter a minimum of 3 sets of data for each table.
5.Week 7 - Some sample queries.
6.Week 8 - Slides.
Here is what you don't need to do: You don't need to computerize the entire business, just the processes that Custom Autobody finds most bothersome. You don't need to create forms for data entry. This is something you would do if hired as a consultant.
An outstanding project will have the following characteristics, with lower grades for projects that lack these things:
1.The E-R diagram clearly identifies the entities, relationships, and attributes.
2.The logical schema clearly identifies the attributes and required keys for each entity.
3.The tables are in third normal form, and you used good names for the tables and the fields.
4.The sample data is useful in creating sample reports.
5.The script works with Oracle using the the 10g XE interface.
6.The script has comments to make it easy to edit later. (dashdash space )
7.The sample queries that will show Custom Auto Body how the database will be useful in meeting his data needs.
8.The slide package summarizes your project and could be used for presentation