Posts Tagged ‘databases’

Database assessments

The class have been finishing off their database work this week. On Tuesday they all sat a multiple choice NAB test which everyone passed.

They have started work on a short task which takes them through every stage of a database project, from design to implementation.

Advertisements

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

Database Report and Layouts

The class have been working on practical exercises, manipulating database layouts and reports.

We have been talking about how reports can be produced from one or more tables, and how different reports are used to show different views on the same data, depending on the user.