Homepage
Advanced databases - Schedule for spring 2022
| Date | Themes | Assignments | Due | Additional info/material |
|---|---|---|---|---|
| 13.1. | Course introduction | Moodle: quiz 1 | 20.1. | Objectives of this course |
| Learning report | Set your own goals | 20.1. | Return it to Moodle (Learning reports folder) | |
| Assignment: database project | Choose topic and project group | 20.1. | Tell the name of the topic and names of the group members to teacher | |
| SQL, modelling, and DB implementation test (self-evaluation) | Exercise 1: 1.1. SQL test + 1.2. design and implement a customer database | 13.1. | ||
| 20.1. | Design goals | Moodle: quiz 2 | 20.1. | Objectives of DB Design |
| Modelling exercise: Hotel-room-reservation | Exercise 2 | 20.1. | ||
| DBA roles and tasks, DBMS structure | Moodle: quiz 3 | 20.1. | Optional: examine SQL Server or Oracle | |
| MySQL administration | 20.1. | MySQL Workbench | ||
| 27.1. | NoSQL - no problems? | Listen the related video in Moodle | Optional: do the MongoDB excercises | |
| NoSQL databases | Examine NoSQL Databases | Optional: listen the related video from YouTube | ||
| MariaDB and history of MySQL | Examine MariaDB web site | |||
| Database Analysis | Start your group work | |||
| Conceptual Modelling | Exercise 3 (in Moodle) | 3.2. | Data modelling video, part 1 | |
| 3.2. | Logical data modelling | Data modelling video, part 2 | ||
| Target World Analysis | In Moodle (exercise 4) and related quiz | 10.2. | Analysing data needs; interviews | |
| Requirements Specification | Create the short req. spec. about your topic | |||
| 10.2. | Normalization (slides1) | Moodle: exercise 5 | 23.3. | |
| Normalization (slides2) | ||||
| From UML class diagrams to relational model | Moodle: quiz 6 | 17.3. | Object-relational mapping | |
| 17.2. | Physical DB design and PDM | DB management plan & physical design | 17.3. | From logical to physical |
| Transaction management, lesson 1 | Exercises 1.1-1.7 + Moodle: quiz 5 | 17.3. | Install lab environment | |
| 24.2. | Transaction management, lesson 2 | Exercises 2.1-2.7 + Moodle: quiz 5 | 17.3. | Install lab environment |
| Database Security | Include a security plan for your own database (=> DBMP); Moodle: quiz 8 | 17.3. | ||
| Midterm course evaluation | 24.2. (10.3.) | |||
| 10.3. | Index Design | Exercises in a virtual machine, e.g. DebianDB_VM6; Moodle: quiz 7 | 17.3. | |
| Automating tasks by creating procedures, triggers and functions | Create procedure | Data generation procedure | ||
| 17.3. | Data warehouse design | Moodle: quiz 9 | 24.3. | Examine tools and services, DW design video |
| Reverse engineering | Exercise: Install and reverse engineer a database | |||
| Answers to Moodle quizzes and exercises | ||||
| 24.3. | Instructions for exam and presentation | Document your database project | 21.4. | |
| Creating a prototype through ODBC | Create a simple CRUD UI to your database | 21.4. | ||
| Group work and personal guidance | Write the final report | |||
| 31.3. | Exam, part 1 | Data modelling | ||
| 7.4. | Exam, part 2 | Database management | ||
| 14.4. | Exam return; quidance for group work | |||
| 21.4. | Presentations, summary & course evaluation | Return all assignments to Moodle | 28.4. | If you have received an email asking to give feedback for this course, please do that! |
| 28.4. | Re-exam |
Last update: 11.1.2021
