BUS5071

Database systems and data management

(IT)

R C Redpath

6 points + 2-hour lecture and 1-hour laboratory session per week + First semester + Clayton

Synopsis: Introduction to the concepts necessary for planning, designing, using and implementing database systems. Database design. Structures and techniques underlying databases: file organisations, data structures, index structures. The database concept: data sharing, related data, data independence, data integrity, data dictionary. Relational databases: referential and entity integrity, SQL data definition, creating and amending tables and rows, data manipulation, distributed database, data warehousing and data mining. Assignments are done using the Oracle database management system.

Assessment: Assignment 1 (data retrieval): 20% + Assignment 2 (database planning, design and implementation): 20% + Examination (2 hours): 60% + Students must pass the examination in order to pass the subject