Produce an E-R diagram and a relational model of your design.

Harry Happy is a used car dealer and runs one of the most profitable car yards in Melbourne.

Harry has asked you to design a database for his office computer so he can record details of his sales.

Harry has given you a copy of his current paper invoice to use as a guide:

INVOICE

HARRY'S USED CARS

Invoice No: __________

Date: __________

SOLD TO:

Name:

____________________________________________

Street:

____________________________________________

Suburb:

____________________________________________

State:

______________________

PostCode:

___________

Telephone:

(____) _____ - ___________

SOLD BY:

_____________________________________________________

Year

Colour

Make

Model

Serial Number

TOTAL PRICE:

____________________