Database Development
2021/2022
Prerequisite/Recommended prerequisite for participation in the module
Recommended professional prerequisite: Basic knowledge of programmingContent, progress and pedagogy of the module
Disclaimer.
This is an English translation of the module. In case of
discrepancy between the translation and the Danish version, the
Danish version of the module is valid.
Learning objectives
Knowledge
- the relational data model and its concepts
- data modeling (ERD / UML)
- transactions concept
- integrity restrictions including primary keys, promotion keys, checks and not null
- The SQL language for defining databases, basic and advanced extraction of data as well as modifying 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
Skills
- be able to construct a database design and a database schema
- demonstrate understanding of the relational data model
- construct and evaluate complex queries in SQL and other relevant queries
- construct transactions that meet relevant technical and business criteria
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 in accordance with the general teaching methods for the education, cf. section 17.
Extent and expected workload
The student is expected to spend 27.5 hours per ECTS, which for this activity means 137.5 hours.
Exam
Exams
| Name of exam | Database Development |
| Type of exam | Written or oral exam |
| ECTS | 5 |
| Assessment | 7-point grading scale |
| Type of grading | Internal examination |
| Criteria of assessment | The criteria of assessment are stated in the Examination Policies and Procedures |
Additional information
Contact: Study Board for Computer Science via cs-sn@cs.aau.dk or 9940 8854
Facts about the module
| Danish title | Databaseudvikling |
| Module code | DSNBAITFB402 |
| Module type | Course |
| Duration | 1 semester |
| Semester | Spring
|
| ECTS | 5 |
| Language of instruction | English |
| Empty-place Scheme | Yes |
| Location of the lecture | Campus Aalborg |
| Responsible for the module |
Organisation
| Study Board | Study Board of Computer Science |
| Department | Department of Computer Science |
| Faculty | Technical Faculty of IT and Design |
