Overview
An introduction to fundamental database technology, including database theory, database design, and extensive practical work.
About this paper
| Paper title | Database Theory and Applications |
|---|---|
| Subject | Computer Science |
| EFTS | 0.15 |
| Points | 18 points |
| Teaching period | Semester 1 (On campus) |
| Domestic Tuition Fees ( NZD ) | $1,318.20 |
| International Tuition Fees | Tuition Fees for international students are elsewhere on this website. |
- Prerequisite
- COSC 203 or COSC 242
- Restriction
- COSC 444
- Recommended Preparation
- COSC 201
- Schedule C
- Arts and Music, Science
- Contact
- More information link
- Teaching staff
- Paper Structure
Database theory, design, implementation, use, and administration, focusing on the Relational Model of Data and SQL database management systems (DBMSs). Relational theory, including relational algebra, functional dependencies, and normalisation. Advanced features of SQL including server-side database programming and triggers. Database administration including recovery and protection, transactions and concurrency, query optimisation and performance, and underlying storage structures and access methods. Includes an introduction to distributed databases and NoSQL DBMSs.
- Teaching Arrangements
- There are two 1-hour lectures and a 2-hour lab per week. Weekly exercises also have to be completed.
- Textbooks
Recommended:
Elmasri, R. & Navathe, S., Database Systems: Models, Languages, Design, and Application Programming (7th Edition), 2016.- Course outline
- Graduate Attributes Emphasised
- Lifelong learning, Critical thinking, Self-motivation.
View more information about Otago's graduate attributes. - Learning Outcomes
Students will:
- Design and implement a database in an SQL database management system, based on a high-level specification.
- Master advanced features of SQL.
- Understand key database administration tasks including security management, backup and recovery, and concurrent data access.
- Understand internal storage mechanisms of a database management system and how these affect database and query performance.
- Understand issues relating to distributed data management and NoSQL database systems
- Assessment details
- Assignment and lab work 40%
- Final exam 60%