Prerequisite/Recommended prerequisite for participation in the module

Content, progress and pedagogy of the module

Learning objectives

Knowledge

• the relational data model and its concepts
• data modelling (ERD / UML)
• concept of operations
• integrity constraints including primary keys, promoting keys, checks and not null
• SQL language for defining databases, basic and advanced data extraction and modification of data
• Extracting information from a DBMS from a programming language such as PHP, Java or C #
• "best practice" for good design and use of DBNS and SQL
• Understand and use the advanced queries using more than two tables, e.g., for inner join, outer join, and the set operators

Skills

• be able to construct and evaluate a database design and database scheme
• demonstrate understanding of the relational data model and how to evaluate the model
• construct and evaluate complex queries in SQL and other relevant query languages
• constructing transactions that comply with relevant technical and commercial criteria
• Informally argue for the goodness/quality of the database design using knowledge on unnecessary repetition of information plus first and third normal form

Competences

• use a database management system (DBMS) to store and retrieve information
• use SQL from a conventional programming language

Type of instruction

The teaching is organized according to the general teaching methods for the education, cf. chapter 3

Extent and expected workload

It is expected that the student uses 30 hours per ECTS, which for this activity means 150 hours

Exam

Exams

Additional information

Contact: The Study board for Computer Science at cs-sn@cs.aau.dk or 9940 8854