Learning Outcomes
The overall goal of the course is that students shall acquire knowledge of principles and methods for designing and using relational databases.
After completing the course the student shall be able to:
Knowledge and understanding
Skills and abilities
After completing the course the student shall be able to:
Knowledge and understanding
- explain the importance of normalisation when designing relational databases.
- explain the importance of designing good identifiers for database tables.
Skills and abilities
- use conceptual modeling and graphical description techniques for designing relational databases corresponding to the third normal form.
- manipulate (search, add, modify and delete) data, and create, modify and delete database objects (tables, constraints, procedures, functions, triggers) using SQL and PL/SQL.
- use normalisation to analyse, verify and modify a data model to meet the third normal form.
Course Content
The course introduces the relational database concept and system theory. Methods for designing and developing database systems are covered. The course also deals with knowledge about how and why databases are used by companies, authorities and organisations.
Assessment
Written examination (4.5 credits), written report on laboratory work (3 credits, U-G).
Forms of Study
Lectures and labs.
Grades
The Swedish grades U–VG.
The grade awarded on the written examination determines the final grade in the course.
Prerequisites
- Fundamentals of programming 7,5 credits
Other Information
The course is equivalent to Database Systems 7,5 credits. Due to the rapid development of the subject, the number of examinations is limited to five.
Replaces IK1051.
Replaces IK1051.