Course - Data modeling and database systems - IDATG2204
Data modeling and database systems
Choose study yearAbout
About the course
Course content
- Basic introduction to data modelling with emphasis on conceptual modelling.
- The relational model, relational algebra and SQL.
- Normalization as a design theory for relational databases.
- Other database models.
- Database construction.
- Developing and testing database applications.
- Security in database systems.
- Storage technologies, file organization, and index structures.
- Query processing.
- Database management systems (DBMS).
- Data integrity, transactions, concurrency, and recovery.
Learning outcome
The student has knowledge of:
- Database management systems - general characteristics and system structure.
- Data modeling with an emphasis on conceptual modelling.
- Relational database model for database systems, database schema, and data integrity.
- Other database models.
- Query languages: Relational Algebra and SQL.
- Design theory for relational databases.
- System design and programming using database systems - including database application testing and data and application security preservation.
- Data storage, file organization and index structures.
- Execution of database queries.
- Transactions, concurrency, and robustness against errors.
The students are skilled in:
- Developing and assessing functional and effective conceptual models.
- Realization of relational databases.
- Developing, testing, and reviewing database applications using SQL, database APIs, and development tools.
- Evaluation and improvement of relational database schema based on normalization theory.
- Analysis and optimization of the performance of database systems.
General qualifications in the form of:
- Knowledge of applications of database systems and understanding of the benefits and limitations of such systems.
- Modelling and analytical approach to computer technical problems.
- Use of computer tools for software system development.
- Reviewing software design and program code.
Learning methods and activities
Learning activities include prerecorded lectures, interactive classroom activities, exercises, project work, peer code review, and self-tuition.
Compulsory assignments
- Mandatory assignments
Further on evaluation
The portfolio consists of project work and formative assessment.
The project work shall result in a database application software system and a project report. An early version of the system shall be submitted for peer student code review. The project report shall document how experiences from - and feedback received in - the peer review process has had an impact on the final version of the system.
To pass the course both the portfolio and the final exam must be passed.
Mandatory assignments need to be passed to be eligible for attending the final exam. The student becomes eligible to attend the exam in the next three years if passing these mandatory coursework requirements.
The resit examination (written exam in August) may be oral if few students are enrolled. No resit for the portefolio.
Retake can be carried out for some partial assessments without all partial assessments having to be taken up again.
Specific conditions
Admission to a programme of study is required:
Digital Infrastructure and Cyber Security (BDIGSEC)
Programming (BPROG)
Recommended previous knowledge
PROG1003 Object-Oriented Programming or IDAT2001 Programming 2 and IDATG2102 Algorithmic Methods
Course materials
Announced at the start of the course.
Credit reductions
| Course code | Reduction | From |
|---|---|---|
| IMT2261 | 7.5 sp | Autumn 2020 |
| IMT2571 | 7.5 sp | Autumn 2020 |
| IDATG2002 | 7.5 sp | Autumn 2023 |
| IDATA2002 | 7.5 sp | Autumn 2023 |
| IDATT2002 | 7.5 sp | Autumn 2023 |
Subject areas
- Engineering