Titular Professors
There are no prerequisites.
Students acquire the knowledge and develop the skills indicated below:
1. Basic concepts of database architecture.
2. Design of a database using different models.
3. Implementation of a relational database.
4. Basic concepts on database transactions.
5. Use of query and advanced database operations tools.
6. Basic database security concepts.
Unit 1. Introduction to databases.
Unit 2. Conceptual model.
Unit 3. Relational model.
Unit 4. Physical model.
Unit 5. Advanced queries.
Unit 6. Data Control Language.
Unit 7. SQL programming (stored procedures, triggers and events).
Unit 8. Optimization.
Unit 9. Database security.
Unit 10. Introduction to NoSQL.
Unit 11. Introduction to OLAP.
The course lasts one semester and consists of two distinct parts: a theoretical knowledge component and a practical component. The knowledge part consists of theoretical classes accompanied by exercise sessions and live coding, enabling students to acquire knowledge. Practical classes involving problem solving and/or decision-making using theoretical knowledge will also be included. Students must complete exercises during class sessions and submit them online.
Students will consolidate the knowledge they have gained by carrying out an almost real design project involving the implementation and use of a database. During the first half of the semester, students will work on this project outside of class, building on the content covered in the theoretical sessions. From the second half of the semester, the course will focus entirely on project-based learning.
The assessment of the subject is based on a knowledge grade and a project grade, which must be passed separately. The knowledge component includes the achievement of the concepts covered in class, which will be assessed through the continuous assessment exercises and the final exam of the subject, in which the student will have to demonstrate their knowledge of relational database design, implementation and application.
The project grade assesses whether the students, working in groups, have been able to design a good database model to meet specific requirements and obtain data and statistics from the resulting database.
The assessment of the subject is based on a knowledge grade and a subject project grade, which must be passed separately:
- Knowledge grade (50%): (30%) Continuous assessment sessions in class + (70%) exam grade
- Project grade (50%): Project carried out in groups to design and implement a relational database
[1] R.Groff, P.N.Weinberg and A.J.Oppel, SQL: The Complete Reference, 3rd Edition, McGrawHill, ISBN: 978-0071592550,
2009.
[2] J.D.Ullman and J.Widom, A First Course in Database Systems, 3rd Edition, Prentice Hall, ISBN: 978-0136006374, 2007.
[3] Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom, Database Systems: The Complete Book, 2nd Edition,
Prentice Hall, 2008.
[4] Garcia-Molina, Hector; Ullman, Jeffrey D.; Widom, Jennifer, Database System Implementation, Pearson, 2009.
[5] Özsu M.Tamer and Patrick Valduriez, Principles of Distributed Database Systems, 4th Edition, Springer, 2020.