Posts Tagged ‘report’

Homework: Database Reports (Int 2 IS)

ToyStore-y supply toy shops with large orders of toys and games.  Every order is logged in their database.  Fields include:

  • Customer ID
  • Contact Name
  • Shop Name
  • Shop Address
  • Order ID
  • Product ID
  • Product Name
  • Product Description
  • Product Size
  • Product Weight
  • Product Price

(a) Design a report layout which could be used as an invoice for the customer

(b) Design a report layout which would be suitable for a manager who wants a summary of sales orders

Note that for (a) and (b) you do not need to include every field.

Homework is due for Tuesday 19th January
Image licensed under a Creative Commons Attribution 3.0 License