0

Hi all
It’s required from me to create a database for a company which have three branches; the company does repair and sale second hand cars. I have created the database with my tutor but I think there are things missing but I don’t know where they should go and I wander if anyone could help me.
In the tables we crated there is no mention of car sold or available for sale neither my tutor talked about labour cost in any tables.
I would be very grateful if someone could let me know what is wrong with my tables and what information is missing in each table.

Attached are the database I have created, below list of queries which I have been asked to create.

a) Formulate a query/report to prepare an invoice for a customer when they purchase cars, you should include customer details, car details and price before and after VAT. The Sales Assistant will wish to access this invoice by typing in the invoice/order number.

b) Formulate a query/report to prepare an invoice which shows a breakdown of any repairs/service carried out on a customers car, this should include breakdown of costs, labour costs, total cost before and after VAT. The Administrator should be able to access this invoice by typing in the booking number.

c) Formulate a query to show total sales of cars for the current year for each garage, sort the list so that the minimum sale appears first on the list.

d) Formulate a query to work out the total costs of repairs/services for each garage, sort the list so that the maximum costs appears first on the list.

e) Formulate a query to show the minimum and maximum price of cars for each garage, name the minimum column as ‘Minimum_Price’ and name the maximum column as ‘Maximum_Price’.


Kind Regards
HB25

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by HB25
0

Hi
Thank you for your comment I have managed with most of the Quires by deleting the table stock and adding labour filed to the jobcard table.
But i am still struggling with one query which is ( Formulate a query to work out the total costs of repairs/services for each garage, sort the list so that the maximum costs appears first on the list)
In you opinion what will be the query?
Kind Regards
HB25

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.