31061 Database Principles

6cp; 2hpw (lectures, face-to-face), 1hpw (lab); availability: BBus/BComp and non-Faculty of IT students
Anti-requisite(s): 31271 Database Fundamentals AND 31474 Database Fundamentals AND 31487 Database Management Systems
Recommended studies:
it is assumed that students are familiar with basic system analysis concepts and have basic software skills.

Undergraduate

Description

This subject introduces the students to basic database design and implementation concepts, database design techniques, and using a relational design via Entity Relationship Diagram. This subject also includes how to interpret an Entity Relationship Diagram. Students learn how to access a database via Structured Query Language (SQL) to retrieve data from the database. The code required to implement a database is also covered in this subject.

This subject requires significant preparation before students come to the lectures. Practical exercises are covered during the labs.

Typical availability

Autumn session, City campus

Spring session, City campus

Detailed subject description.

Fee information

Information to assist with determining the applicable fee type can be found at Understanding fees.

Commonwealth-supported students: view subject fees at Fees Search: Commonwealth-supported
Postgraduate domestic fee-paying students: fees are charged according to the course enrolled in; refer to Domestic Fees Search: Postgraduate and Research
International students: fees are charged according to the course enrolled in; refer to International Fees Search
Subject EFTSL: 0.125

Access conditions

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.