5014 - Databases and SQL
Course information
- Title
- Databases and SQL
- Course number
- 5014.23
- Academic year
- 2024-2025
- ECTS
- 7.50
- Level
- Bachelor
- Faculties
- Science and Tecnology
- Educations
- BSc in Software Engineering, Diploma of Higher Education in Software Engineering
- Prerequisites
- Introductions into Computer Science and programming in Python, Java or C++
- Language of instruction
- The course is taught in Faroese.
- Registration
- Students on the 2nd semester of B.Sc. in Software Engineering and Diploma of Higher Education in Web Development are automatically enrolled. Applicants for an individual course must apply via the Student Affairs Office.
- Beginning date
- Tuesday, January 14, 2025
- End date
- Friday, March 7, 2025
Academic content
- Purpose
- To give the student a first introduction to databases, database management systems, SQL and database design.
- Learning outcomes
- The successful student will be able to: • Create an external database model with the entity relationship model. • Create a conceptual database model suited for an external database model. • Install the SQL database management system and create a database. • Define and execute low to medium level complexity SQL queries. • Define and explain the relational database model including its most important data constraints. • Explain the potential causes and consequences of redundancy implied anomalies to maintaining data. • Define 3NF, BCNF and execute the synthesis algorithm for achieving 3NF. • Explain why transactions are used and what ACID-transaction are. Explain what conflict-serializability and deadlock means and why these concepts are important for transaction processing.
- Content
- The course starts with an introduction to SQL and database management systems. It continues with a discussion of entity relationship modeling. Then the relational model as well as mapping rule for turning an entity relationship diagram into a relational schema is discussed. Finally 3NF and BCNF as well as respective design algorithm are discussed. Transactions, concurrency, Big Data and blockchain databases are the final course issues.
- Learning and teaching approaches
- There will be lectures and practice exercises on each course day. The details will be agreed on at the first meeting. Attending the classes is very strongly encouraged. The assignments will be issued at the beginning of the course. A mini-project will be discussed and implemented in class with a report as a result.
Assessment
- Assessment method
- Oral exam bases on the short report mentioned above produced by students in groups during the course. The mini project report counts 50% and the exam 50% in the student’s grade. Failing students may be reexamined by amendment to their report and a repeat exam.
- Examination (internal/external)
- External
- Grading scale
- 7-scale
- Exam date/dates
- The examination hand-in is on the 07th of March, 2025. The oral examination is set for the 13th and 14th of March, 2025. The reexamination is set for week 23, 2025.
- Deadline for withdrawal from exam
- Tuesday, January 14, 2025
Academic responsibility and teachers
- Academic responsibility
- Hans Blaasvær
- Teachers
- Hans Blaasvær