Question 1 Consider the following purchase order document. It shows who is giving the order, to...

 

  

Transcribed Image Text:

Question 1 Consider the following purchase order document. It shows who is giving the order, to whom it is sent, and where the goods are to be delivered. Also, it includes several products on the purchase order. (A).Write the data structure for this Purchase Order. (10) (B) Name the master files needed for the purchase order to be processed? (C) Write the data structures for the master files mentioned in the part (B). (5) (10) Note. You may wish to read the Chapter 8 for Data structures. There are examples of writing data structures. Sample Company Pty Ltd PO Box 1234, Narre Warren South Tel No : , Fax No:, Email: Tax Reg#: ABN sdfadifa Purchase From ABC Vendor Pty Ltd 204 Collins Street Melbourne 3000 Australia Attention : Mr John Doe We are pleased to confirm our purchase of the following items: SN Product ID Description 1 P1001 Pencils HB 2 P1002 Pencis 2B 3 P1235 Paper - A4, Photo copier, 70gram Paper - A4, Photo copier, 80gram 4 P1003 5 P2007 Pens-Ball Point, Blue 6 P20001 Highlighter - 3 colour Comments: Delivery of goods are required within 7 days from date of this PO Purchase Order Approved By for: Sample Company Pty Ltd EzySoft Developments Purchase Order P.O. No# P01011 Date 21/02/2012 Your Ref# QT1234 Our Ref# Credit Terms 30 Salesperson Job Code1 Qty UM 5 Dozen 4 Dozen 10 Ream. 15 Dozen 10 Boxes 8 Sets Unit Price $10.00 $10.00 $3.00 $3.20 $10.00 $6.00 Total Before Tax Tax Total After Tax Amount $50.00 $40.00 $30.00 $48.00 $100.00 $48.00 $316.00 $0.00 $316.00 Question 1 Consider the following purchase order document. It shows who is giving the order, to whom it is sent, and where the goods are to be delivered. Also, it includes several products on the purchase order. (A).Write the data structure for this Purchase Order. (10) (B) Name the master files needed for the purchase order to be processed? (C) Write the data structures for the master files mentioned in the part (B). (5) (10) Note. You may wish to read the Chapter 8 for Data structures. There are examples of writing data structures. Sample Company Pty Ltd PO Box 1234, Narre Warren South Tel No : , Fax No:, Email: Tax Reg#: ABN sdfadifa Purchase From ABC Vendor Pty Ltd 204 Collins Street Melbourne 3000 Australia Attention : Mr John Doe We are pleased to confirm our purchase of the following items: SN Product ID Description 1 P1001 Pencils HB 2 P1002 Pencis 2B 3 P1235 Paper - A4, Photo copier, 70gram Paper - A4, Photo copier, 80gram 4 P1003 5 P2007 Pens-Ball Point, Blue 6 P20001 Highlighter - 3 colour Comments: Delivery of goods are required within 7 days from date of this PO Purchase Order Approved By for: Sample Company Pty Ltd EzySoft Developments Purchase Order P.O. No# P01011 Date 21/02/2012 Your Ref# QT1234 Our Ref# Credit Terms 30 Salesperson Job Code1 Qty UM 5 Dozen 4 Dozen 10 Ream. 15 Dozen 10 Boxes 8 Sets Unit Price $10.00 $10.00 $3.00 $3.20 $10.00 $6.00 Total Before Tax Tax Total After Tax Amount $50.00 $40.00 $30.00 $48.00 $100.00 $48.00 $316.00 $0.00 $316.00

Answer rating: 100% (QA)

A The data structure for this purchase order would include the following fields Company name Contact ... View the full answer