31474 Database Fundamentals
6cp;
availability: undergraduate degree students
This subject introduces students to basic database modelling, design, and implementation concepts and techniques. Entity-Relationship (E-R) modelling methodology is described in detail and students learn how to model information requirements and develop conceptual models from user specifications. Relational database theory is presented including the description of the relational model and theory of Normal Forms. Transformations techniques between the E-R and relational models are described. Database programming using SQL is introduced in lectures and supported by practical exercises using a relational DBMS. Transaction management and access control are also studied.
Typical availability
Autumn semester, City campus
Spring semester, City campus
Summer session, City campus
2007 contribution for post-2004 Commonwealth-supported students: $889.75
2007 amount for undergraduate domestic fee-paying students: $2,370.00
Subject EFTSL: 0.125
Note: The above fees are applicable in 2007 for Commonwealth-supported students who commenced after 2004 and domestic fee-paying undergraduate students only. Pre-2005 Commonwealth-supported students should consult the
Student contribution charges for Commonwealth supported students webpage.
Not all students are eligible for Commonwealth supported places, and not all subjects are available to Commonwealth supported students. Domestic fee-paying students and international students should refer to the
Fees webpage.
Note: The requisite information presented in this subject description covers only academic requisites. Full details of all enforced rules, covering both academic and admission requisites, are available at
Access conditions and My Student Admin.