CSE2132

Database systems ( 6 points, SCA Band 2, 0.125 EFTSL)

Leader: R Redpath

Offered:
Caulfield First semester 2005 (Day)
South Africa First semester 2005 (Day)
Caulfield Second semester 2005 (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