Main field of study: Information Systems, Microdata Analysis
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 about the principles and methods for designing and using relational databases.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