Objectives of Programme's Learning Outcomes

• ills in the various disciplines of computer science, which come after those within the Bachelor's in computer science.
• Apply scientific methodology.
• Critically reflect on the impact of IT in general, and on the contribution to projects.
• ills in the various disciplines of computer science, which come after those within the Bachelor's in computer science.
• Manage research, development and innovation.
• Understand unprecedented problems in computer science and its applications.
• Organise and lead a research, development or innovation project to completion.
• Methodically research valid scientific information, lead a critical analysis, propose and argue potentially innovative solutions to targeted problems.
• Apply scientific methodology.
• Critically reflect on the impact of IT in general, and on the contribution to projects.

Learning Outcomes of UE

At the end of the course, the students will be able to:
- Design a relational database model.
- Issue queries against a relational database.
- Understand the functioning of a relational database system.
- Identify the most suited database paradigm for a specific use case.

Content of UE

The course presents the basics theoretical aspects of database conception:
- Entity-relation diagram, conceptual model, logic model and physical model
- "Pure" query language: relational algebra, tuple relational calculus and domain relational calculus.
- The SQL query language.
- The normal form theory
- Indexing mechanisms
- Advanced functionalities (stored procedure, trigger, replication)
- Introduction to NoSQL systems Exercises allow the students to become familiar with the concepts presented during the course.

Prior Experience

Not applicable

Type of Assessment for UE in Q2

• Written examination

Q2 UE Assessment Comments

100% written examination.

Type of Assessment for UE in Q3

• Written examination

Q3 UE Assessment Comments

100% written examination.