Overordnede kursusmål
This course aims to give the student the necessary theoretical and
practical background for the design and manipulation of large
databases.
Læringsmål
En studerende, der fuldt ud har opfyldt kursets mål, vil kunne:
- Apply technical terms correctly
- Develop an entity/relationship diagram (ER-diagram) that
reflects a chosen problem domain, for example a small business
- Explain and carry out transformation of ER to table structure;
draw and explain a referential integrity diagram
- Normalise tables to third normal form
- Understand the purpose of transaction control and how to apply
it
- Understand relational algebra as the basis for database
queries
- Use SQL to define tables and constraints
- Use SQL to define views (including complex queries)
- Describe the use of indexes
- Describe the concepts of users and rights
- Describe possible implications for a programmer developing a
(web) application that access a database (e.g. domain-specific
constraints or queries, error handling, or access rights)
- Write a report as documentation for the course
assignment
Kursusindhold
SQL - the standard language for relational databases
o Data Definition Language (DDL)
o Data Manipulation Language (DML)
o Data Control Language (DCL)
Logical database design
o Entity/relationship diagrams (ER)
o Transformation of ER to table structure
o Functional dependency and normalisation
o Relational integrity
o Documentation, including property tables
o Relational algebra
Database management systems (DBMS)
o Physical database design and configuration
o Indexing
o System catalogue
o Security and user rights
o Transaction control
Web applications and databases
Implications for a programmer developing a (web) application that
access a database
Litteraturhenvisninger
Elmasri, Ramez & Navathe, Shamkant: Fundamentals of Database
Systems, 7/E, Global Edition, Pearson 2017, ISBN 1-292-09761-2
Bemærkninger
Exam:
The course is examined on the basis of an assignment where a small
problem domain is identified and modelled, and a database
implemented.
Sidst opdateret
05. april, 2019