CSE2138

Database systems (8 points)

(IT)

Leader: R Redpath

Offered:
Caulfield First semester 2003 (Day)
Caulfield Second semester 2003 (Evening)
Caulfield First semester 2004 (Day)
Caulfield Second semester 2004 (Day)

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.

Assessment: Examination (2 hours): 60% + Assignment work: 40%

Contact Hours: One 2-hour lecture and one 2-hour tutorial per week

Prerequisites: COT1140,CSE1201 or equivalent

Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT2901, COT3180, CSC3161, CSE2132, CSE2180, CSE3180, CSE3316