Databases

1. Introduction to databases (DBs) and DB Management Systems.
2. Architecture of DB Systems.
3. Entity-Relationship model.
4. Relational Model.
5. Relational Algebra.
6. Structured Query Language (SQL).
7. Functional Dependencies and Normalization.
8. Physical organization of DBs and means of storage.
9. Indexes.

The expected learning outcomes are the following:
1. Understanding the basic principles of design and implementation of Database Systems
2. Familiarity with using Entity Relationship Diagrams
3. Understanding the Relational Model
4. Acquisition of basic knowledge of Relational Algebra and SQL
5. Acquisition of advanced SQL capabilities knowledge
6. Experience with MySQL
7. Understanding the basic principles of normalization
8. Acquisition of knowledge about the storage of Databases and basic indexing structures
9. Experience in collaborative database implementation

-

The evaluation is done through:
1. written examination at the end of the semester
that includes short answer questions and resolution
of exercises
1. scoring the report and the code of the project
carried out during the semester. The scoring is 

done separately for each of the four phases of the
project and in total at the end
2. oral presentation of the various phases of the
project carried out during the semester
The evaluation criteria are as follows:
• correctness
• clarity
• accuracy
• efficiency

- Recommended Book Resources:
• Elmasri Ramez, Navathe Shamkant B., Fundamentals of Database Systems, 2007.
• Ramakrishnan Raghu, Gehrke Joahannes, Database Management Systems, 2012.
• Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database Systems, 2011.
- Recommended Article/Paper Resources:
ACM Transactions on Database Systems, VLDB Journal, IEEE Transactions on Knowledge and Data Engineering,
Information Systems