Checking date: 26/06/2021


Course: 2021/2022

Database design and administration
(15809)
Bachelor in Computer Science and Engineering (2018 Study Plan) (Plan: 431 - Estudio: 218)


Coordinating teacher: IGLESIAS MAQUEDA, ANA MARIA

Department assigned to the subject: Computer Science and Engineering Department

Type: Electives
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Files and Data bases (Year 2; Term 2)
Skills and learning outcomes
Description of contents: programme
1. Database Design Methodologies 2. Fundamentals of Database Administration 3. Physical design of databases 4. Database Settings 5. Paradigms and Database Architectures.
Learning activities and methodology
* Lectures: 0.9 ECTS. They aim to achieve the specific cognitive competences of the subject, as well as the transversal competences of analysis and abstraction. * Practical classes: 0.9 ECTS. They aim to initiate the development of the specific instrumental competences, as well as the transversal competences problem solving and application of knowledge. * Continuous assessment exercises: 1 ECTS. Initiated during practical classes and completed outside of them, they aim to complete the development of the specific instrumental competences and initiate the development of the specific attitudinal competences, as well as the transversal competences problem solving and application of knowledge. * Practical work: 1.7 ECTS. Developed without the presence of the teacher, they aim to complete and integrate the development of all the specific and transversal competences, in the resolution of two practical cases where the approach to the problem, the choice of the method of resolution, the results obtained and their interpretation are well documented. * Tutoring classes: 1 ECTS. Individual (individual tutorials) or group (group tutorials) assistance to students by the lecturer. * Final exam: 0.5 ECTS. Its aim is to influence and complement the development of specific cognitive and procedural skills. It especially reflects the use made of the master classes.
Assessment System
  • % end-of-term-examination 30
  • % of continuous assessment (assigments, laboratory, practicals...) 70
Calendar of Continuous assessment
Basic Bibliography
  • Pramod J. Sadalage & Martin Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional. 2012
  • Andreas Meier & Michael Kaufmann. SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management. Springer. 2019
  • Craig Mullins . Database Administration: The Complete Guide to Practices and Procedures. Addison-Wesley Professional. 2012
  • Date, C.J.. An Introduction to Database Systems (8th Edition). Prentice Hall (2004).
  • Oracle. Oracle Administración de Oracle 10G. http://download-uk.oracle.com/docs/cd/B19188_01/doc/B15921/toc.htm.
  • Oracle. Oracle Database Administrator Guide. 11g. Release2 . http://docs.oracle.com/cd/E11882_01/server.112/e25494.pdf. 2014
  • R Ramakrishnan, J Gehrke. Database Management Systems - 3rd Edition. McGraw-Hill. 2013
  • Saeed K. Rahimi, Frank S. Haug. Distributed Database Management Systems. IEEE Computer Society. 2010
  • Thomas LaRock. DBA Survivor: Become a Rock Star DBA. ebook. 2014
Additional Bibliography
  • A. de Miguel, P. Martínez, E. Castro, J.M: Cavero, D. Cuadra, A. Iglesias, C. Nieto. Diseño de Bases de Datos: Problemas Resueltos. RA-MA (2001).
  • Biju Thomas. OCA: Oracle Database 12c Administrator Certified Associate Study Guide. Wiley / Sybex. 2014
  • D. Cuadra, E. Castro, A. Iglesias, P. Martínez, F.J. Calle, C. de Pablo, H. Al-Jumaily y L. Moreno. Desarrollo de Bases de Datos. Casos Prácticos desde el análisis a la implementación (1ª edición). RA-MA. 2007
  • De Miguel, A. y Piattini, M.. Fundamentos y Modelos de Bases de Datos. RA-MA (1999).
  • Elmasri y Navathe. Fundamentals of Database Systems, fourth edition. Pearson Addison Wesley, (2003).
  • Levene, M. y Loizou, G.. A Guided Tour of Relational Databases and Beyond. Springer Verlag (1999).
  • Silberschatz, A.; Korth, H.; Sudarshan, S.. Fundamentos de bases de datos (5ª edición). McGraw-Hill /Interamericana Mexico (2005).

The course syllabus may change due academic events or other reasons.