ERD, Queries, Assessment


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.


## Deliverables

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!!!

## Platform


WinSQL Lite

Compétences : Administration de Bases de données, Ingénierie, MySQL, PHP, Architecture Logicielle, Tests de Logiciels, SQL

en voir plus : engineering work in uk, illustrate concepts, erd, entity relationship, database queries, invoice form windows using, relationship database diagram, queries database, diagram relational model, php lite, draw data model, windows invoices, invoice source code windows, assessment form, windows invoice program, data entity, draw diagram database, invoice windows form using, draw entity relationship, draw diagram

Concernant l'employeur :
( 10 commentaires ) United States

Nº du projet : #2967215

4 freelance font une offre moyenne de $105 pour ce travail


See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)