Checking date: 09/06/2021


Course: 2022/2023

Data Base
(16488)
Study: Dual Bachelor in Data Science and Engineering and Telecommunication Technologies Engineering (371)


Coordinating teacher: MORENO LOPEZ, LOURDES

Department assigned to the subject: Department of Computer Science and Engineering

Type: Basic Core
ECTS Credits: 6.0 ECTS

Course:
Semester:

Branch of knowledge: Engineering and Architecture



Objectives
CB2: Students acquire the ability to apply their knowledge to their work in a professional manner as well as the skills required, normally demonstrated through the formulation and defence of arguments and the resolving of problems within their area of study. CE8: The ability to differentiate data structures, algorithms, databases and files dealing with the processing of data. CG1: The acquisition of the knowledge and skills needed to analyse and summarise basic problems related with data sciences and engineering, as well as the ability to resolve and communicate them efficiently. CT1: Students acquire the ability to communicate their knowledge, orally and in writing, to both specialised and general audiences. RA1: To have acquired the advanced knowledge and demonstrated understanding of both the theoretical and practical aspects, as well as the work methodology used in the field of data sciences and engineering, with a depth of knowledge that shows their comprehension of even the most cutting-edge aspects of the subject RA2: Using arguments and procedures created by themselves, students must be able to apply their knowledge, understanding and abilities to the resolving of problems related to complex labour or professional, specialised situations which require the use of creative and innovative ideas.
Skills and learning outcomes
Description of contents: programme
1. Introduction 1.1. Information systems. Databases. Database Management Systems 1.2. Modeling methodologies 1.3. Management of semi structured and complex data; distributed and noSQL databases 2. Relational database 2.1. Design of a database. Relational model 2.2. Query languages. SQL language 2.3. Introduction database management systems 3. NoSQL Databases 3.1. Comparison of relational databases to new NoSQL stores 3.2. NoSQL Databases Types 3.3. NoSQL Database installation and, use and deployment
Learning activities and methodology
AF1: THEORETICAL ¿ PRACTICAL CLASSES. The knowledge students must acquire will be presented. Students will receive the class notes and will be provided with basic reference texts in order for them to be better able follow the classes and carry out the subsequent projects. Students will solve exercises, tackle practical problems and workshops and assessment exams will be carried so that students can acquire the abilities needed. AF3: STUDENTS¿ INDIVIDUAL OR GROUP WORK. AF8: WORKSHOPS AND LABORATORIES. MD1: THEORETICAL CLASS. The professor will give in-class presentations, including computer and audiovisual aids in which the course¿s main concepts are developed. Additional materials and literature will also be provided in order to supplement the student¿s learning. MD2: PRACTICAL CASES. Students will be required to resolve case studies, problems, etc. posed by the professor both individually and in groups.
Assessment System
  • % end-of-term-examination 40
  • % of continuous assessment (assigments, laboratory, practicals...) 60
Calendar of Continuous assessment
Basic Bibliography
  • Connolly, Thomas M, Begg, Carolyn E. Database systems : a practical approach to design, implementation, and management. Addison Wesley. 2015
  • Elmasri, Ramez, Navathe, Sham. Fundamentals of database systems. Pearson Addison Wesley. 2017
  • Ramakrishnan, Raghu, Gehrke, Johannes. Database management systems. McGraw-Hill. 2003
Recursos electrónicosElectronic Resources *
Additional Bibliography
  • Redmond, E. &Wilson. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement . The Pragmatic Bookshelf. 2010
  • Sadalage, P. & Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pearson Education. 2013
(*) Access to some electronic resources may be restricted to members of the university community and require validation through Campus Global. If you try to connect from outside of the University you will need to set up a VPN


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