CSE2132

Database systems (6 points)

(IT)

Leader: R Redpath

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

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% + Practical 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, CSE2138, CSE2180, CSE3180, CSC3161, CSE3316