Overordnede kursusmål
This course aims to give the student the necessary theoretical and
practical background for the design and manipulation of large
database systems.
To enable the student to:
- design a database structure that reflects the problem domain, for
example a small business
- understand and use methods and tools for constructing and
maintaining databases
- understand implications for a programmer developing a web
application that access a database
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)
- 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: Database Systems, 6/E,
Pearson 2011, ISBN 0-13-214498-0
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
01. november, 2016