This course aims to give the student the necessary theoretical and
practical background for the design and manipulation of large
database systems. The student will also learn how to construct a
basic web application that accesses a database.
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 and use methods and tools for basic web applications
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
Normalise tables to third normal form
Draw and explain a referential integrity diagram
Describe property tables
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
Implement a simple web application that accesses a
database
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
Database management systems (DBMS)
o Physical database design and configuration
o Indexing
o System catalogue
o Security and user rights
Web applications and databases
o Basic HTML
- Server-side programming, using for example Java Server Pages
(JSP)
