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: Create the following:

1. A group data dictionary.

2. A script that will create the tables and enter a minimum of 3 sets of data for each table.

3.create some sample queries.