News‎ > ‎

10IPT: Diagram Revision

posted Jul 30, 2012, 2:33 PM by Eddie Woo
Diagrams are a big part of this course. That's because information is a big part of this course, and diagrams are a great way to convey information - particularly connections and relationships that take a long time to explain verbally, but are easy to show visually. So today, we're going to revise the construction of the most important diagrams. 
  1. Construct a context diagram for the school timetable system.

  2. Construct a dataflow diagram that describes the following processes:
    • A new year's timetable is created, including the collection of subjection selections from students and class preferences from teachers. 
    • Individual student timetables are generated, involving a query of the timetable database, formatting, and then printing of individual documents.
    • Teacher timetables are generated, involving similar steps to the above process.
    • Locating teachers or students includes the collection of relevant names and an appropriate timetable query to determine their position at a given time.
    • Executing SQL statements of various types on the database. The resulting data is returned to the querying process.

  3. A standard retail transaction system carries out three main clusters of processes: sales (outgoing, to customers), stocktake (internal, to maintain current records of held items) and purchasing (incoming, from wholesalers and suppliers) Construct a dataflow diagram that represents this system.

  4. Consider the school attendance system. Identify typical entities, data/information and processes that inhabit this system and then construct appropriate diagrams to represent its normal operation.