1. General information
Course:
DATABASES
Code:
42319
Type:
CORE COURSE
ECTS credits:
6
Degree:
407 - DEGREE PROGRAMME IN COMPUTER SCIENCE ENGINEERING
Academic year:
2022-23
Center:
108 - SCHOOL OF COMPUTER SCIENCE OF C. REAL
Group(s):
20
21
22
Year:
2
Duration:
C2
Main language:
English
Second language:
Spanish
Use of additional languages:
English Friendly:
N
Web site:
Bilingual:
Y
Lecturer:
JOSE ANTONIO CRUZ LEMUS
- Group(s):
20
Building/Office
Department
Phone number
Email
Office hours
Fermín Caballero/3.21
TECNOLOGÍAS Y SISTEMAS DE INFORMACIÓN
+34926052329
joseantonio.cruz@uclm.es
Lecturer:
DAVID GARCIA ROSADO
- Group(s):
21
Building/Office
Department
Phone number
Email
Office hours
Fermín Caballero/2.15
TECNOLOGÍAS Y SISTEMAS DE INFORMACIÓN
+34926052105
david.grosado@uclm.es
Lecturer:
MARCELA FABIANA GENERO BOCCO
- Group(s):
21
22
Building/Office
Department
Phone number
Email
Office hours
Fermin Caballero/3.25
TECNOLOGÍAS Y SISTEMAS DE INFORMACIÓN
+34926052525
marcela.genero@uclm.es
Lecturer:
JAVIER VERDUGO LARA
- Group(s):
22
Building/Office
Department
Phone number
Email
Office hours
Fermín Caballero/1.06
TECNOLOGÍAS Y SISTEMAS DE INFORMACIÓN
Javier.Verdugo@uclm.es
2. Pre-Requisites
Databases and database systems are a basic component in the daily life of modern society, interaction with government, public services, etc. Companies can no longer be understood without the management of a database that allows communication between the various actors. At present, information technology cannot be understood without an underlying database to achieve the objectives. Technologies based on artificial intelligence, networks, web technologies, games, information systems, etc. would not be understood without database management.
Database management systems are therefore a fundamental component in information and communication technologies without which it would be impossible to imagine the social reach that the network and communications have reached in today's society.
3. Justification in the curriculum, relation to other subjects and to the profession
This course is integrated into the subject of Software Engineering, Information Systems and Intelligent Systems and serves as a basis for the following courses:
- Database Development.
- Advanced Databases.
- Administration of Databases.
4. Degree competences achieved in this course
| Course competences | |
|---|---|
| Code | Description |
| BA04 | Basic knowledge about the uses and programming of computers, operating systems, data bases, and digital programmes with applications in engineering. |
| CO12 | Knowledge and application of the features, functions, and structure of data bases so as to lead to an appropriate use, and the design, analysis, and implementation of application based on them. |
| CO13 | Knowledge and application of the required tools for the storage, process, and access to informational systems, even web based ones. |
| INS01 | Analysis, synthesis, and assessment skills. |
| INS03 | Ability to manage information and data. |
| INS04 | Problem solving skills by the application of engineering techniques. |
| INS05 | Argumentative skills to logically justify and explain decisions and opinions. |
| PER01 | Team work abilities. |
| SIS01 | Critical thinking. |
| SIS03 | Autonomous learning. |
| SIS04 | Adaptation to new scenarios. |
| SIS05 | Creativity. |
| SIS09 | Care for quality. |
| UCLM02 | Ability to use Information and Communication Technologies. |
5. Objectives or Learning Outcomes
| Course learning outcomes | |
|---|---|
| Description | |
| Building of applications that use databases. | |
| Knowledge of the characteristics and structures of databases, as well as the functionalities of systems that manage them and the languages ¿¿for their consultation and manipulation. | |
| Additional outcomes | |
| Not established. |
6. Units / Contents
-
Unit 1: Introduction to Databases
-
Unit 1.1: DB & DB Management Systems concepts and origin.
-
Unit 1.2: DB & DBMS evolution
-
Unit 1.3: DB Architectures
-
-
Unit 2: Data Models
-
Unit 2.1: Introduction to data modeling
-
Unit 2.2: Conceptual, logical and physical modeling
-
-
Unit 3: Relational Model
-
Unit 3.1: Introduction to Relational Model
-
Unit 3.2: Structuring data with the RM
-
Unit 3.3: RM operators
-
Unit 3.4: Integrity rules
-
Unit 3.5: Transforming E/R into RM
-
-
Unit 4: Structured Query Language
-
Unit 4.1: Introduction to SQL
-
Unit 4.2: Data Definition and Manipulation Languages in SQL
-
Unit 4.3: Views in SQL
-
ADDITIONAL COMMENTS, REMARKS
Laboratory contents:
- Accessing databases via programs
7. Activities, Units/Modules and Methodology
| Training Activity | Methodology | Related Competences (only degrees before RD 822/2021) | ECTS | Hours | As | Com | Description | |
| Class Attendance (theory) [ON-SITE] | Lectures | BA04 CO12 CO13 SIS01 SIS09 UCLM02 | 0.72 | 18 | N | N | Exposure of the syllabus by the teacher (MAG). | |
| Individual tutoring sessions [ON-SITE] | Other Methodologies | BA04 CO12 CO13 UCLM02 | 0.18 | 4.5 | N | N | Individual or small group tutorials in the teacher's office, classroom or laboratory (TUT). | |
| Study and Exam Preparation [OFF-SITE] | Self-study | BA04 CO12 CO13 SIS01 SIS09 UCLM02 | 2.1 | 52.5 | N | N | Individual study (EST). | |
| Other off-site activity [OFF-SITE] | Practical or hands-on activities | BA04 CO12 CO13 INS03 INS04 INS05 PER01 SIS03 SIS04 SIS05 UCLM02 | 0.6 | 15 | N | N | Preparation of laboratory practices (PLAB). | |
| Problem solving and/or case studies [ON-SITE] | Problem solving and exercises | BA04 CO12 INS01 INS04 PER01 SIS03 SIS09 | 0.6 | 15 | Y | N | Resolution of exercises by the teacher and students (PRO) | |
| Writing of reports or projects [OFF-SITE] | Self-study | CO12 INS01 INS04 INS05 PER01 SIS03 | 0.9 | 22.5 | Y | N | Preparation of a report on a topic proposed by the teacher (RES). | |
| Laboratory practice or sessions [ON-SITE] | Practical or hands-on activities | BA04 CO12 CO13 INS03 INS04 INS05 PER01 SIS03 SIS05 SIS09 UCLM02 | 0.6 | 15 | Y | Y | Performance in the laboratory of the scheduled practices (LAB). | |
| Other on-site activities [ON-SITE] | Assessment tests | BA04 CO12 CO13 INS01 INS04 INS05 UCLM02 | 0.15 | 3.75 | Y | Y | Performance of the partial test 1 corresponding to the first half of the course syllabus (EVA). | |
| Other on-site activities [ON-SITE] | Assessment tests | BA04 CO12 CO13 INS01 INS04 INS05 UCLM02 | 0.15 | 3.75 | Y | Y | Performance of the partial test 1 corresponding to the second half of the course syllabus (EVA). | |
| Total: | 6 | 150 | ||||||
| Total credits of in-class work: 2.4 | Total class time hours: 60 | |||||||
| Total credits of out of class work: 3.6 | Total hours of out of class work: 90 | |||||||
As: Assessable training activity Com: Training activity of compulsory overcoming (It will be essential to overcome both continuous and non-continuous assessment).
8. Evaluation criteria and Grading System
| Evaluation System | Continuous assessment | Non-continuous evaluation * | Description |
| Mid-term tests | 20.00% | 20.00% | Partial Test 2. Compulsory activity that can be retaken. To be carried out within the planned dates of the final exam call. The Partial Test 1 retake will be performed at this date only for students in "continuous assessment mode". |
| Theoretical papers assessment | 15.00% | 15.00% | Non-compulsory activity that can be retaken. To be carried out before end of teaching period |
| Laboratory sessions | 25.00% | 25.00% | Compulsory activity that can be retaken. To be carried out during lab sessions |
| Assessment of active participation | 10.00% | 0.00% | Non-compulsory activity that cannot be retaken (rescheduling). To be carried out in the theory/laboratory sessions for the students of the continuous modality. |
| Mid-term tests | 30.00% | 30.00% | Partial Test 1. Compulsory activity that can be retaken (rescheduling). To be carried out at the end of the first half of the teaching period (approx.) by the students in "continuous assessment mode". Students in "non-continuous evaluation" will perform this activity together with the Partial Test 2 in the planned date of the final exam call. |
| Total: | 100.00% | 90.00% |
According to art. 4 of the UCLM Student Evaluation Regulations, it must be provided to students who cannot regularly attend face-to-face training activities the passing of the subject, having the right (art. 12.2) to be globally graded, in 2 annual calls per subject , an ordinary and an extraordinary one (evaluating 100% of the competences).
Evaluation criteria for the final exam:
-
Continuous assessment:In compulsory activities, a minimum mark of 40% is required in order to pass that activity and have the possibility to therefore pass the entire subject. The evaluation of the activities will be global and therefore must be quantified by means of a single mark. In the case of the activities that may be retaken (i.e., rescheduling), an alternative activity or test will be offered in the resit/retake exam call (convocatoria extraordinaria).
The partial tests will be common for all the theory/laboratory groups of the subject and will be evaluated by the lecturers of the subject in a serial way, i.e., each part of the partial tests will be evaluated by the same lecturer for all the students.
A student is considered to pass the subject if she/he obtains a minimum of 50 points out of 100, taking into account the points obtained in all the evaluable activities, and also has passed all the compulsory activities.
For students who do not pass the subject in the final exam call (convocatoria ordinaria), the marks of activities already passed will be conserved for the resit/retake exam call (convocatoria extraordinaria). If an activity is not recoverable, its assessment will be preserved for the resit/retake exam call (convocatoria extraordinaria) even if it has not been passed. In the case of the passed recoverable activities, the student will have the opportunity to receive an alternative evaluation of those activities in the resit/retake exam call and, in that case, the final grade of the activity will correspond to the latter grade obtained.
The mark of the passed activities in any call, except for the partial tests, will be conserved for the subsequent academic year at the request of the student, provided that mark is equal or greater than 50% and that the activities and evaluation criteria of the subject remain unchanged prior to the beginning of that academic year.
The failure of a student to attend the partial 1 and partial 2 tests will automatically result in her/him receiving a "Failure to attend¿ (no presentado). If the student has not passed any compulsory evaluation activity, the maximum final grade will be 40%. -
Non-continuous evaluation:Students may apply at the beginning of the semester for the non-continuous assessment mode. In the same way, the student may change to the non-continuous evaluation mode as long as she/he has not participated during the teaching period in evaluable activities that together account for at least 50% of the total mark of the subject. If a student has reached this 50% of the total obtainable mark or the teaching period is over, she/he will be considered in continuous assessment without the possibility of changing to non-continuous evaluation mode.
Students who take the non-continuous evaluation mode will be globally graded, in 2 annual calls per subject, an ordinary and an extraordinary one (evaluating 100% of the competences), through the assessment systems indicated in the column "Non-continuous evaluation".
In the "non-continuous evaluation" mode, it is not compulsory to keep the mark obtained by the student in the activities or tests (progress test or partial test) taken in the continuous assessment mode.
Specifications for the resit/retake exam:
Evaluation tests will be conducted for all recoverable activities.
Specifications for the second resit / retake exam:
Same characteristics as the resit/retake exam call.
9. Assignments, course calendar and important dates
| Not related to the syllabus/contents | |
|---|---|
| Hours | hours |
| Individual tutoring sessions [PRESENCIAL][Other Methodologies] | 4.5 |
| Study and Exam Preparation [AUTÓNOMA][Self-study] | 52.5 |
| Other off-site activity [AUTÓNOMA][Practical or hands-on activities] | 15 |
| Writing of reports or projects [AUTÓNOMA][Self-study] | 22.5 |
| Laboratory practice or sessions [PRESENCIAL][Practical or hands-on activities] | 15 |
| Other on-site activities [PRESENCIAL][Assessment tests] | 3.75 |
| Other on-site activities [PRESENCIAL][Assessment tests] | 3.75 |
| Unit 1 (de 4): Introduction to Databases | |
|---|---|
| Activities | Hours |
| Class Attendance (theory) [PRESENCIAL][Lectures] | 2.5 |
| Unit 2 (de 4): Data Models | |
|---|---|
| Activities | Hours |
| Class Attendance (theory) [PRESENCIAL][Lectures] | 3 |
| Unit 3 (de 4): Relational Model | |
|---|---|
| Activities | Hours |
| Class Attendance (theory) [PRESENCIAL][Lectures] | 4 |
| Problem solving and/or case studies [PRESENCIAL][Problem solving and exercises] | 6 |
| Unit 4 (de 4): Structured Query Language | |
|---|---|
| Activities | Hours |
| Class Attendance (theory) [PRESENCIAL][Lectures] | 8.5 |
| Problem solving and/or case studies [PRESENCIAL][Problem solving and exercises] | 9 |
| Global activity | |
|---|---|
| Activities | hours |
| General comments about the planning: | The subject is taught in 3 x 1,5 hour sessions per week |
10. Bibliography and Sources
| Author(s) | Title | Book/Journal | Citv | Publishing house | ISBN | Year | Description | Link | Catálogo biblioteca |
|---|---|---|---|---|---|---|---|---|---|
| Connolly y Begg | Database Systems (6th edition) | Pearson Addison-Wesley | 978-01-329-4326-0 | 2015 | https://www.pearson.com/us/higher-education/program/Connolly-Database-Systems-A-Practical-Approach-to-Design-Implementation-and-Management-6th-Edition/PGM116956.html | ||||
| Elmasri y Navathe | Fundamentals of Database Systems (6th edition) | Pearson Addison-Wesley | 9780136086208 | 2011 | https://www.pearson.com/us/higher-education/product/Elmasri-Fundamentals-of-Database-Systems-6th-Edition/9780136086208.html | ||||
| Marqués | Bases de Datos | Publicaciones Univ. Jaume I | 978-84-693-0146 | 2011 | |||||
| Piattini, Marcos, Calero y Vela | Tecnología y diseño de bases de datos | Ra-Ma | 8478977333 | 2006 | http://www.ra-ma.es/libros/TECNOLOGIA-Y-DISENO-DE-BASES-DE-DATOS/235/978-84-7897-733-8 | ||||
| Silberschatz, Korth y Sudarshan | Database System Concepts (6th edition) | McGraw-Hill | 978-00-735-2332-3 | 2010 | https://www.mheducation.com/highered/product/database-system-concepts-silberschatz-korth/M9780073523323.html (Otra pagina www.db-book.com/db6/) |