5014 - Databases and SQL
Course information
- Title
- Databases and SQL
- Course number
- 5014.23
- Academic year
- 2023-2024
- ECTS
- 7.50
- Level
- Bachelor
- Faculties
- Science and Tecnology
- Educations
- BSc in Software Engineering, Diploma of Higer Education in Web Development
- Prerequisites
- Introductions into Computer Science and programming in Python, Java or C++
- Language of instruction
- The course is taught in Faroese and English
- Registration
- Students on the second semester of Bachelor of Software Enineering and Diploma of Higer Education in Web Development are automatically enrolled. Applicants for an individual course must apply via the Faculty of Science and Technology Office by sending an email to NVD@setur.fo.
- Beginning date
- Tuesday, January 16, 2024
- End date
- Friday, March 8, 2024
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 oral assessment is set for 12-13 March 2024
- Deadline for withdrawal from exam
- Tuesday, January 16, 2024
Academic responsibility and teachers
- Academic responsibility
- Hans Blaasvær
- Teachers
- Hans Blaasvær