31061 Database Principles6cp; 2hpw (lectures, face-to-face), 1hpw (lab). Forms of attendance, mode of delivery and assessment requirements in this subject have changed to enable social distancing and reduce the risks of spreading COVID-19 in our community. Consequently, the Subject Outline information for this subject has changed. Details of the changes are published in an addendum to the Subject Outline which is available on UTSOnline/Canvas.; 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
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.
Autumn session, City campus
Spring session, City campus
Detailed subject description.
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