This subject is the second in the line dedicated to databases and focuses especially on the design aspects of a database.

The specific competencies of this subject are: Stages in Database Design. Conceptual design: requirements analysis and data design, transformation to the relational model, normalization. Physical design. Specification of integrity rules in databases: restrictions, triggers.



Recommended previous skills:

- Acquired in the Basic Programming subject: Basic programming concepts

- Acquired in the Databases subject: Understanding the characteristics of the relational model and being able to use the SQL language to perform data definitions, queries and data manipulation.

Conceptual design: The stages of database design are presented: conceptual design, logical design and physical design. The conceptual design and the transformation process to the relational model are explained.



Normalization: Insertion and deletion anomalies are explained. The normal forms that consider these anomalies are explained.



Integrity rules: The different options are explained to define the integrity restrictions that will ensure compliance with the integrity of the database: inter-table restrictions, intra-table restrictions, triggers.



Physical design: The characteristics of the indices and other aspects related to the implementation of logical schemes are analyzed.

Master classes (M) will be used mainly for the presentation of the theoretical concepts associated with the subject and the resolution of doubts raised by the students.

In GL classes and in some of the master classes, both individual and group exercises will be carried out to reinforce the concepts presented in the theoretical classes.

• Continuous Assessment System
• Final Assessment System
• Tools and qualification percentages:
  • Written test to be taken (%): 70
  • Realization of Practical Work (exercises, cases or problems) (%): 30

The evaluation of the subject in the ORDINARY call is carried out either through continuous evaluation or final evaluation. By default, all students will take the continuous evaluation system, unless they resign from it. Students who do not pass or do not appear in the ordinary call may take the exam in an EXTRAORDINARY call in which they will be evaluated in a global exam of the entire subject.



* FINAL EVALUATION:

The student may decide to forgo the continuous evaluation to take the final evaluation. This resignation must be presented to the responsible teaching staff within the deadlines stipulated in Article 8 of the regulations on student evaluation (within the first 9 weeks of the term). Exceptional cases or resignations will not be accepted after the dates authorized for this. The final evaluation will consist of a single exam whose weight in the final grade will be 100% of the grade. This exam will evaluate the theoretical knowledge as well as practical aspects developed during the course.



* CONTINUOUS ASSESSMENT:

It is the default evaluation form of the subject. It will be considered that the student has taken the ORDINARY call if he or she has completed the continuous evaluation, that is, if he or she has not resigned from it.



The continuous evaluation is composed of:

The continuous evaluation is composed of:

- Tests associated with continuous monitoring (two partial exams): 70%

- 1st partial exam: 40%

- 2nd partial exam: 30%

- Evaluation of laboratory practices: 10%

- Practice: 20%



In any case, to pass the subject, it is necessary to take the exams and, in addition, have completed all the requested tasks and laboratory practices. To pass the subject it will also be necessary to obtain, at a minimum:

- 40% of the grade in each of the exams

- 40% of the grade on the average of all laboratories and work carried out



If the minimum required grade is not obtained in any of them, the ordinary call for the subject will be considered to have been suspended. Furthermore, assuming that the student obtains the minimum grade in each and every part, the minimum grade that must be obtained to pass the subject is 5 points out of the total of 10 for the subject. If a lower grade is obtained, the ordinary call for the subject will be considered to have been suspended.



* WAIVER of the right to the exam:

Students enrolled in continuous evaluation will have until week 11 of the term to present to the teaching staff responsible for the subject their wish to appear as "Not Presented" in the ordinary call. The students enrolled in the final evaluation will renounce the ordinary call by not appearing for the final test.



* COPY CASES:

Article 11 of the regulations for the management of undergraduate and first and second cycle education regarding student evaluation will apply. In case of cheating in any evaluation test, all students involved in it will receive a failing grade in the ordinary call.

The extraordinary call consists of a 10-point exam in which both theoretical knowledge and practical aspects developed during the course are evaluated.

To pass the subject, it is necessary to obtain a minimum grade of 5 points out of the total of 10 on the exam.

To waive the right to the exam, it will be enough to not appear for the final exam.



* COPY CASES:

Article 11 of the regulations for the management of undergraduate and first and second cycle education regarding student evaluation will apply. In case of cheating in any evaluation test, all students involved in it will receive a failing grade in the corresponding call.



* NOTE:

The grade obtained in the ordinary call is not saved.

Material available in the eGela for the subject

Basic bibliography

Fundamentos de Sistemas de Bases de Datos. Ramez Elmasri y Shamkant B. Navathe. Addison-Wesley

Iberoamericana, 2007.



Fundamentos de Bases de Datos. Henry Korth, Abraham Silberschatz y S. Sudarshan. Mc.Graw-Hill, 2002.



Sistemas de Bases de Datos. Un enfoque práctico para Diseño, Implementación y Gestión. Thomas Connolly y Carolin Begg. Addison Wesley, 2005.

In-depth bibliography

Introducción a los Sistemas de Bases de Datos. C.J. Date. Prentice-Hall, 2001.

Web addresses

PostgreSQL website: http://postgresql.com

PostgreSQL documentation: https://www.postgresql.org/docs/current/index.html

MySQL website: http://www.mysql.org

Normalization tool: https://app-ltphp-tst-ae.azurewebsites.net/normalization_tool/ind.php