Knowledge of relational databases and SQL and PL/SQL languages is essential, as is mastery of object-oriented concepts as well as object-oriented programming and programming.
These competencies are acquired in the following subjects
Fundamentals of Programming I and II
Data Structures
Databases.
Databases and database systems are a basic component in the daily life of modern society, interaction with government, public services, the company 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 cover information requirements. Technologies based on artificial intelligence, networks, web technologies, games, etc. would not be understood without database management.
The evolution and widespread implementation of object-orientation makes it increasingly necessary to design object-oriented databases. The use of databases, increasingly frequent in all aspects where ICTs are present, make it essential to maintain the integrity of the database and its independence from the applications that make use of it, which forces the database to be designed with active rules that improve independence.
The subject is integrated into the Software Engineering Specific Technology subject of the curriculum and serves as a foundation for the following subjects:
Advanced Databases
Database Administration
Course competences | |
---|---|
Code | Description |
INS01 | Analysis, synthesis, and assessment skills. |
INS02 | Organising and planning 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. |
IS04 | Ability to detect and analyse problems, and design, develop, implement, verify, and document software solutions on the base of adequate knowledge about theories, models, and current techniques. |
PER01 | Team work abilities. |
PER02 | Ability to work in multidisciplinary teams. |
PER04 | Interpersonal relationship skills. |
PER05 | Acknowledgement of human diversity, equal rights, and cultural variety. |
SIS01 | Critical thinking. |
SIS03 | Autonomous learning. |
SIS04 | Adaptation to new scenarios. |
SIS05 | Creativity. |
SIS06 | Leadership skills. |
SIS08 | Initiative and entrepreneurial abilities. |
SIS09 | Care for quality. |
Course learning outcomes | |
---|---|
Description | |
Knowledge and understanding of the application of the techniques of modeling and database design, both for classic and advanced models, following models and techniques that ensure running safety. | |
Additional outcomes | |
Not established. |
The practical part of the course will look at PL/SQL, triggers, and database tools to design and use the different types of databases that will be seen in the theory part.
Training Activity | Methodology | Related Competences | ECTS | Hours | As | Com | Description | |
Class Attendance (theory) [ON-SITE] | Lectures | INS01 INS02 INS04 INS05 IS04 SIS01 SIS09 | 0.6 | 15 | N | N | Teaching of the subject matter by lecturer (MAG) | |
Individual tutoring sessions [ON-SITE] | Collaborative on line international learning (COIL) | INS01 INS02 INS04 INS05 IS04 SIS09 | 0.18 | 4.5 | N | N | Individual or small group tutoring in lecturer¿s office, classroom or laboratory (TUT) | |
Study and Exam Preparation [OFF-SITE] | Self-study | INS01 INS02 INS04 INS05 IS04 SIS03 SIS08 SIS09 | 1.8 | 45 | N | N | Self-study | |
Other off-site activity [OFF-SITE] | Practical or hands-on activities | INS01 INS02 INS03 INS04 INS05 IS04 PER01 PER02 PER04 PER05 SIS03 SIS04 SIS05 SIS06 SIS08 SIS09 | 0.9 | 22.5 | N | N | Lab practical preparation (PLAB) | |
Problem solving and/or case studies [ON-SITE] | Problem solving and exercises | INS01 INS02 INS04 INS05 IS04 PER01 PER02 PER04 PER05 SIS04 SIS05 SIS06 SIS08 SIS09 | 0.6 | 15 | Y | N | Worked example problems and cases resolution by the lecturer and the students (PRO) | |
Writing of reports or projects [OFF-SITE] | Self-study | INS01 INS02 INS04 INS05 IS04 PER01 PER02 PER04 PER05 SIS01 SIS03 SIS04 SIS05 SIS06 SIS08 SIS09 | 0.9 | 22.5 | Y | N | Preparation of essays on topics proposed by lecturer (RES) | |
Laboratory practice or sessions [ON-SITE] | Practical or hands-on activities | INS01 INS02 INS03 INS04 INS05 IS04 PER01 PER02 PER04 PER05 SIS04 SIS05 SIS06 SIS08 SIS09 | 0.72 | 18 | Y | Y | Realization of practicals in laboratory /computing room (LAB) | |
Other on-site activities [ON-SITE] | Assessment tests | INS01 INS02 INS04 INS05 IS04 | 0.15 | 3.75 | Y | Y | Partial test 1 of the first half of the syllabus of the subject (EVA) | |
Other on-site activities [ON-SITE] | Assessment tests | INS01 INS02 INS04 INS05 IS04 | 0.15 | 3.75 | Y | Y | Partial test 2 of the second half of the syllabus of the subject (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).
Evaluation System | Continuous assessment | Non-continuous evaluation * | Description |
Final test | 0.00% | 50.00% | Compulsory activity that can be retaken (rescheduling) to be carried out within the planned exam dates of the final exam call (convocatoria ordinaria). |
Mid-term tests | 20.00% | 0.00% | Partial Test 1. Compulsory and activity that can be retaken (rescheduling). To be carried out at the end of the first half of the teaching period. |
Mid-term tests | 30.00% | 0.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. |
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% | 10.00% | Non-compulsory activity that can be retaken. To be carried out during the theory/lab sessions in the case of continuous evaluation students. The non-continuous evaluation students will have an alternative evaluation system for this activity. |
Total: | 100.00% | 100.00% |
Not related to the syllabus/contents | |
---|---|
Hours | hours |
General comments about the planning: | The subject is taught in 3 x 1,5 hour sessions per week. |
Author(s) | Title | Book/Journal | Citv | Publishing house | ISBN | Year | Description | Link | Catálogo biblioteca |
---|---|---|---|---|---|---|---|---|---|
Connolly y Begg | Database systems : a practical approach to design, implementation and management | 6th edition | Pearson | 9780132943307 | 2015 | ||||
Elmasri y Navate | Fundamentals of Database Systems | 7th edition | Pearson | 0-13-397077-9 | 2016 | ||||
Harrison G. | Next Generation Databases: NoSQL and Big Data | Apress | 9781484213292. | 2015 | |||||
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 |