Learning Outcomes
The overall goal is that students shall acquire knowledge about the 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
- apply basic principles of relational databases in accordance with the relational model
- 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 3NF
Course Content
The course introduces the concept of database, system theory and basic design principles for relational databases. It provides a method to develop database systems. The course imparts knowledge on how and why databases are used in businesses, and private and public organisations.
Assessment
Written examination (3.5 credits) and written report on laboratory work (4 credits).
Forms of Study
Lectures and labs
Grades
The Swedish grades U–G.
Prerequisites
- Object-Oriented Programming 7.5 Credits, First cycle or other course in Fundamentals of Programming
Other Information
The course is equivalent to Database Systems 7,5 credits, Qualification course in Database Systems for master programme in Business Intelligence 7,5 credits and the first 7,5 credits in the course Databases and Information Systems 15 credits.