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
