Main field of study: Information Systems
The course has no instances planned right now
- Search other courses
- Contact us if you have questions: support@du.se.
Learning outcomes for the course
The overall goal is that students shall acquire knowledge of principles and methods for designing and using relational databases.After completing the course the student should be able to:
Knowledge and understanding
- explain the importance of normalization 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
Judgement and approach
- use normalization to analyze, verify and modify a data model to meet the third normal form
- relate their database design to the Personal Data Act (PDA) to show that the design does not conflict with PDA