ENC3032

Computer applications 6I

H Okyar

4 points
* 12 lecture hours and 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