A) EVALUATION RULES:

To pass the subject, it is necessary to pass the ICT practicals and the Mixed Test (that is, get at least 50% of the maximum score from each of these parts). If this minimum score is not reached in any of the tests, the qualification that will appear in the minutes will be a maximum of 4.0.

Assessment conditions: It is forbidden to access the exam room with any device that allows communication with the outside world and/or the storage of information.
Student identification: The student body must prove their identity in accordance with current regulations.
Plagiarism: Partial or total plagiarism will result in a 0 in the evaluation of said delivery or test. The teaching staff may request the defense of any test/work.

B) TYPES OF QUALIFICATION:

Qualification of not presented: Corresponds to students when they only participate in evaluation activities that have a weighting of less than 20% of the final qualification, regardless of the qualification obtained.
Students with recognition of part-time dedication and academic exemption from assistance: the rules for the evaluation of the work, problem solving and the mixed test will be the same as for the general case. However, if necessary, a specific calendar of dates compatible with their dedication will be established for these students.

C) EVALUATION OPPORTUNITIES:

First opportunity: the previously indicated evaluation criteria will be applied.
Second opportunity:

If 50% of the supervised work is not achieved in the 1st opportunity, the students may optionally present it in the 2nd opportunity, on the delivery dates that will be established during the course and will be published on the subject's website of the Virtual Campus.
The student who requests it, will be evaluated on the problem solving part, in writing, on the officially scheduled dates for the mixed test.
The student who did not reach the minimum mark in the ICT practicals, may take a written recovery test on the officially scheduled dates for the mixed test.
The student may take the mixed test if they did not achieved the minimum grade required.
Evaluations received on the first opportunity will be saved until the second opportunity.

3. Early call: students will be evaluated through a single mixed test that will allow them to obtain 100% of the score.

Learning outcomes	Study programme competences / results
Assimilate the basic concepts of databases to improve the management capacity of the company's IT developments.	A1 A3 A4 A5 A6 A7 A8 A9 A11 A12 A16 A17 A18 A19 A20	B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14	C1 C2 C3 C4 C5 C6 C7 C8
Know the fundamentals of Database Management Systems (DBMS).	A4 A5 A20 A24	B1 B2 B3 B4 B5 B7 B8 B10 B14	C1 C2 C3 C6 C8
Know and understand the structures, restrictions and basic operations of the relational model.	A4 A5 A20 A24	B1 B2 B3 B4 B5 B7 B8 B10 B14	C1 C2 C3 C6 C8
Being able to create, feed and query a previously designed database using SQL in interactive mode.	A4 A5 A20 A21 A23 A24	B1 B2 B3 B4 B5 B7 B8 B11 B12 B14	C1 C2 C3 C6 C8
Understand the need to design conceptual models; know and be able to use the ER model.	A4 A5 A20 A24	B1 B2 B3 B4 B5 B7 B8 B10 B11 B14	C1 C2 C3 C6 C8
Learn to rationalize and formally reflect the information storage needs of the company in order to carry out an organization of the data that allows its efficient use.	A4 A5 A6 A16 A19 A20 A24	B1 B2 B3 B4 B5 B7 B8 B10 B11 B12 B14	C1 C2 C3 C6 C8
To know the existence of other models different from the relational one.	A4 A5 A20 A24	B1 B2 B3 B4 B5 B7 B8 B10 B11 B14	C1 C2 C3 C6 C8
Know the databases as a support for decision making (Data mining, Data warehouse and OLAP).	A4 A5 A16 A19 A20 A21 A24	B1 B2 B3 B4 B5 B7 B8 B10 B11 B12 B14	C1 C2 C3 C6 C8
Stay motivated to delve into computing as an essential tool for the performance of the profession.	A1 A5 A11 A19 A20	B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B14	C1 C2 C3 C4 C5 C6 C7 C8

Topic	Sub-topic
Introduction to databases.	Relational databases. Database Management Systems.
Relational model.	Definition of relationship. Domains and attributes. Keys. Integrity Constraints.
Database design methodology.	Bad design problems. Methodology.
Conceptual design of databases.	Introduction to the Entity-Relationship Model.
Database query language: SQL.	Query sentences. Definition and update sentences.
Databases as support for decision making.	Multidimensional databases, Data mining, Data warehouse and OLAP.
Creation and exploitation of databases in a DBMS: Microsoft Access.	Microsoft Access

Methodologies / tests	Competencies / Results	Teaching hours (in-person & virtual)	Student’s personal work hours	Total hours
Guest lecture / keynote speech	A3 A5 A6 A7 A8 A9 A11 A12 A16 A17 A18 A19 A20 A24 B4 B5 B6 B7 B8 B9 B11 B12 B13 B14 C1 C2 C3 C4 C5 C6 C7 C8	17	35	52
Problem solving	A3 A5 A6 A7 A8 A9 A11 A12 A16 A17 A18 A19 A20 A24 B4 B5 B6 B7 B8 B9 B11 B12 B13 B14 C1 C2 C3 C4 C5 C6 C7 C8	0	5	5
ICT practicals	A4 A5 A9 A11 A16 A19 A20 A21 A23 A24 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B14 C1 C2 C3 C4 C5 C6 C7 C8	25	30	55
Supervised projects	A1 A5 A11 A12 A16 A19 A20 A21 A23 A24 B1 B2 B3 B4 B5 B6 B7 B10 B12 C1 C3 C5 C6 C7 C8	4	30	34
Mixed objective/subjective test	A19 A20 A24 B1 B3 B4 C2	2	0	2

Personalized attention		2	0	2

(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies	Description
Guest lecture / keynote speech	Classes will be taught in which theoretical content will be presented combined with practical exercises.
Problem solving	Practical exercises will be proposed for the students to carry out individually. Deadlines and delivery rules will be established during the course and will be published on the Virtual Campus.
ICT practicals	Practical classes will be given: tests will be carried out, exercises will be delivered, etc. They must be delivered within the proposed deadlines and following the rules established during the semester.
Supervised projects	A work will be proposed that the students will have to carry out individually. Deadlines and delivery rules will be established during the course and will be published on the Virtual Campus.
Mixed objective/subjective test	There will be a written exam that will contain short questions, multiple choice questions and exercises on the contents of the subject.

Methodologies	Competencies / Results	Description	Qualification
ICT practicals	A4 A5 A9 A11 A16 A19 A20 A21 A23 A24 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B14 C1 C2 C3 C4 C5 C6 C7 C8	They will take place at the time that the FEE schedules for each group. During the semester, the work and results of the students will be assessed continuously through deliverable exercise bulletins, tests, etc. It is essential to achieve 50% of the maximum grade to pass the subject. If the student does not get the minimum required score with the continuous evaluation, he/she will be able to opt for a new evaluation of this part in the second opportunity.	30
Supervised projects	A1 A5 A11 A12 A16 A19 A20 A21 A23 A24 B1 B2 B3 B4 B5 B6 B7 B10 B12 C1 C3 C5 C6 C7 C8	The final quality of the work will be evaluated, in terms of the application of the contents learned in the classes and the knowledge acquired through personal work, although the development process itself will also be taken into account. Delivery dates will be marked during the course. If the student does not get 50% of the maximum score in the 1st opportunity, she/he may opt for a new evaluation of this part in the second opportunity. It is not necessary to reach a minimum score in this part to pass the subject.	30
Mixed objective/subjective test	A19 A20 A24 B1 B3 B4 C2	In each opportunity, it will be carried out on the official dates that the FEE indicates for each subject. It is essential to achieve 50% of the maximum grade to pass the subject. If the student does not get the minimum required score on the 1st opportunity, she/he may opt for a new evaluation of this part on the second opportunity.	35
Problem solving	A3 A5 A6 A7 A8 A9 A11 A12 A16 A17 A18 A19 A20 A24 B4 B5 B6 B7 B8 B9 B11 B12 B13 B14 C1 C2 C3 C4 C5 C6 C7 C8	The exercises will be carried out and evaluated during the semester, and will compute for the final qualification of the subject. It is not necessary to reach a minimum score in this part to pass the subject.	5

Assessment comments
A) EVALUATION RULES: To pass the subject, it is necessary to pass the ICT practicals and the Mixed Test (that is, get at least 50% of the maximum score from each of these parts). If this minimum score is not reached in any of the tests, the qualification that will appear in the minutes will be a maximum of 4.0. Assessment conditions: It is forbidden to access the exam room with any device that allows communication with the outside world and/or the storage of information. Student identification: The student body must prove their identity in accordance with current regulations. Plagiarism: Partial or total plagiarism will result in a 0 in the evaluation of said delivery or test. The teaching staff may request the defense of any test/work. B) TYPES OF QUALIFICATION: Qualification of not presented: Corresponds to students when they only participate in evaluation activities that have a weighting of less than 20% of the final qualification, regardless of the qualification obtained. Students with recognition of part-time dedication and academic exemption from assistance: the rules for the evaluation of the work, problem solving and the mixed test will be the same as for the general case. However, if necessary, a specific calendar of dates compatible with their dedication will be established for these students. C) EVALUATION OPPORTUNITIES: First opportunity: the previously indicated evaluation criteria will be applied. Second opportunity: If 50% of the supervised work is not achieved in the 1st opportunity, the students may optionally present it in the 2nd opportunity, on the delivery dates that will be established during the course and will be published on the subject's website of the Virtual Campus. The student who requests it, will be evaluated on the problem solving part, in writing, on the officially scheduled dates for the mixed test. The student who did not reach the minimum mark in the ICT practicals, may take a written recovery test on the officially scheduled dates for the mixed test. The student may take the mixed test if they did not achieved the minimum grade required. Evaluations received on the first opportunity will be saved until the second opportunity. 3. Early call: students will be evaluated through a single mixed test that will allow them to obtain 100% of the score.

Basic	A. Silberschatz; H. Korth; S. Sudarshan (2006). Fundamentos de Bases de Datos.. Madrid: McGraw Hill Elmasri, R.; Navathe, S. (2007). Fundamentos de Sistemas de Bases de Datos . Madrid: Addison-Wesley Rivero, E.; Martinez, L.; Reina, L.; Benavides, J. y Olaizola, J. (2002). Introducción al SQL para Usuarios . Madrid: Thomson
	E-book links to the electronic versions of the two most relevant books in the bibliography of the subject (require authentication with UDC credentials): · Silberschatz; H. Korth; S. Sudarshan (2006). Fundamentos de Bases de Datos.. Madrid: McGraw Hill. https://elibro-net.accedys.udc.es/es/ereader/bibliotecaudc/50087 · Elmasri, R.; Navathe, S. (2007). Fundamentos de Sistemas de Bases de Datos. Madrid: Addison-Wesley. https://elibro-net.accedys.udc.es/es/ereader/bibliotecaudc/52533
Complementary	Cuadra, D.; Castro, E.; Iglesias, A. M.; Martínez, P.; Calle, F. J.; de Pablo, C.; Al-Jumaly, H.; Mo (2007). Desarrollo de Bases de Datos: casos prácticos desde el análisis a la implementación. Madrid: Ra-ma de Miguel, A,; Martínez, P.; Castro, E.; Cavero, M., Cuadra, D.; Iglesias, A. M.; Nieto, C. (2001). Diseño de bases de datos. Problemas resueltos. Madrid: Ra-ma Gómez Brandón, A.; Paramá, J.R. (2022). Structured Query Language: Manual Práctico. Coruña: Reprografía Noroeste S. L. Piattini, M. G.; Marcos, E.; Calero, C.; Vela, B. (2006). Tecnología y diseño de Bases de Datos. Madrid: Ra-ma