Computer applications 6I
H Okyar
4 points * 12 lecture hours, 39 laboratory/project hours * Second semester * Caulfield
Objectives To equip students with the necessary tools and techniques to analyse and design engineering information systems, make intelligent decisions using database systems and advanced spreadsheet models.
Synopsis Information system management. Simple SQL queries, join SQL queries, using SQL to model information systems. Analysis and design of engineering information systems. Mapping the physical systems onto logical structures, normalisation process. Designing reports and user input forms. Character-based vs GUI design. Implementing a relational database system. Using spreadsheets to collect and analyse tabular data. Graphical presentation of information. Optimising engineering operations using spreadsheets. Using built-in engineering and financial functions to solve numerical problems. Using spreadsheet goal seekers to solve linear and non-linear industrial engineering optimisation problems.
Assessment Written tests: 40% * Case studies and assignments: 60%
Recommended texts
Date C J An introduction to database systems vol. 1, 5th edn, Addison-Wesley
McFadden F R and Hoffer J A Database management 2nd edn, Benjamin-Cummings
| Published by Monash University, Clayton, Victoria
3168 Copyright © Monash University 1996 - All Rights Reserved - Caution Authorised by the Academic Registrar December 1996 |