This problem should be completed with database software, such as Micro soft Access. As directed by your instructor, submit the completed data-base file and the printouts noted below.
1. Using the E-R diagram in Figure select any three or four related entities and implement them as tables using Microsoft Access (or any other database software acceptable to your instructor). Link the tables using the cardinalities shown in the figure. For the tables, you may use attributes shown in or create different attributes.
2. Using Microsoft Visio (or other software), draw an E-R diagram of the three or four tables chosen in part 1 above. Also, include linking lines and cardinalities.
3. Create forms for each table from part 1 of this problem and use the forms to populate the tables with representative data. Forms should be in good order, readable, and properly formatted. Create at least three records in each table. Print out the populated tables and one instance of each form.
4. Design three queries using the tables from part 1 of this problem. Print out the output of each query and attach an explanation as to why someone would be interested in the output of each query.
5. Using the report function in Access, design a report for each query from part 3 of this problem. Reports should be in good order, read-able, and properly formatted. Print out eachreport.

VALID INVOICES Invoice NInvoice_DatVend NoBmp No 524 572 539 AP) G232 G232 D923 4388 20071224 92360 20071223 535 20071224 PURCHASE RELATIONS PO No 4345 4345 4345 Oty Invoiced 200 50 25 Amt Invoiced 1200.00 212.50 418.75 PR No Item NoQty Requested 200 50 25 Ordered | Rec No | ty Received Inv No 53947 53947 53947 1005 1006 1015 200 50 25 42946 42946 42946 200 50 25 535 535 535 CASH DISBURSEMENTS CD No CD Date Bmp No Bmp No Amount Vend No Bank 9561 9562 9563 (AP) 20080102 H263 20080102 H263 20080102 H263 Treasury) MO513 M513 B219 1782. 10 432.50 1831.25 524 572 539 2239 2240 2239 BANKS Bank Name 2239 Acne 2240 Bentorn PAYMENT RELATIONS Invoice No CD No Amount 4388 92360 9561 1782.10 432.50 9562 535 95631831.25