Curriculum Page >> COMP224
Curriculum - COMP224 - Database Systems
| Handbook Entry | Unit Home Page |
Short Description
COMP224 imparts to students the basic knowledge of relational database systems and the ability to program relational database applications.
Assumed knowledge
- Ability to develop and write a small program in a procedural computer language. (COMP115)
- Understanding of program control structures (sequence, dowhile, ifthenelse), callable procedures and parameter lists, arrays. (COMP115)
- Basic understanding of the basic components of a computer, their purpose and function - disks, memory, processing unit, channels etc. (COMP115)
- Basic understanding of using Unix and/or PCs in a windows environment. (COMP115)
- Basic knowledge of relation (table) data structures and the query commands in SQL. (COMP114)
- Ability to understand and apply mathematics to problem solving. (HSC 3 unit Mathematics or MATH135 or STAT171)
- Fluency and comprehension of English sufficient to comprehend, discuss and interpret informal system specifications written in English.
Learning outcomes
- An ability to model simple business applications using the entity relationship approach.
- A basic knowledge of relational database systems.
- An understanding of the principles of relational database modelling and design, including the architecture and storage of database systems and the basic principles of client/server architecture.
- An ability to program relational database applications including programming with the SQL language and practical experience with a commercial database management system together with the tools to assist in programming client/server database applications (currently ORACLE8 on a Unix platform).
Comments to: Steve Cassidy