CSE1IS Information Systems
Tutorial - Week 6
System Dictionary

La Trobe University, Bendigo campus Department of Computer Science and Computer Engineering
 

System Dictionary

Question 1:

Below is the outline of an invoice sent by a supplier to the FastFood restaurant

Chocky Supply Company
INVOICE
 
Invoice# FS440 Customer ID: a2007
Date: 28/08/2007 Name: FastFood Restaurant
  Address: 2 News Rd
Rowville
3266
Item# Description Quantity Cost
GG678 Ten Litre Ice Cream 6 $240.00
HY900 Filo Pastry 10 $88.50
PB426 Chickens 2 $23.50
... ... ... ...
  Total: $670.00

Prepare a sample data dictionary entry for this form (a data flow template such as the one used on pp170 S.C.&R. could be used as a starting point). Decompose the form to the data element level.

Question 2:

(a) Decompose the following assessment report from lecturers subject administration system into its data elements:

INT12IS - INFORMATION SYSTEMS
Lecturer: BRIAN RETALLICK
Tutorial Group: B
Mon 1:00pm Room B153 Tutor: Peter
Thu 1:00pm Room B205 Tutor: Peter
Student ID Last Name First Name Ass1
/15 		Ass2
/25 		Exam
/100 		Final
/100 		Final Grade
12345671 Ablett Gary 14 18 85 83 A
12345810 Ablett Nathan 7.5 12.5 40 50 D
12345624 Bandy Daniel 1 11 58 46.8 F
12345625 Bassett Scott 2 22 63 61.8 C
12345626 Birss Shane 3 3 68 46.8 F
12345811 Blake Mark 14 16 43 55.8 D
12345688 Brown Nathan G 8 18 30 44 F
12345723 Byrnes Shannon 9 1 95 67 C
12345732 Byrnes Shannon 10 12 100 82 A
12345672 Chapman Paul 12 9 70 63 C
12345674 Corey Joel 3 10 75 58 D

(b) Draw up a Data Dictionary for the data elements directly associated with a tutorial - as a table one line per data element.

(c) The process "Calculate Final Mark" calculates the final mark from the assessments. Write, in Structured English, the process logic: