a. Draw an entity relationship diagram which illustrates the data model for this invoice. Be sure that you illustrate the entities involved, show whether weak or strong entities are involved, show any attributes and the relationship between the entities. Explain the relationship in plain English. (15 Points)
b. Explain how such invoices might be physically stored in relational database tables. You might draw some tables and label them as part of an answer. Assume that you are explaining this to an account’s person who has little prior knowledge of database concepts.
Be sure to label any tables, columns, data-types, keys and relationships you use.
Illustrate you answer by using the data in the above invoice and data from other invoices of your invention for at least one other customer.
NB you only need to consider storing the invoice information, there are no links to products or price tables as data is copied into the invoice tables to represent the price and description at some snapshot in time.
THE SELECTED CODER WILL RECEIVE MORE INFORMATION!!!!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
I need this by 11pm GMT (UK time) today 26 Aug 03!!!