Prerequisite/Recommended prerequisite for
participation in the module
Basic knowledge of programming.
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
Name of exam | Database Development |
Type of exam | Written or oral exam |
ECTS | 5 |
Assessment | Passed/Not Passed |
Type of grading | Internal examination |
Criteria of assessment | The criteria of assessment are stated in the Examination
Policies and Procedures |
Additional information
Contact: The Study board for Computer Science at
cs-sn@cs.aau.dk or 9940
8854