Checking date: 19/05/2022


Course: 2022/2023

Databases and Data Modeling
(17627)
Study: Bachelor in Management and Technology (351)


Coordinating teacher: MARTINEZ FERNANDEZ, PALOMA

Department assigned to the subject: Computer Science and Engineering Department

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Objectives
This course aim is to understand the databases roll in an Information System, to know the features which define a Databases System, and to acquire skills to implement a Databases Systems through different data models. - Analysis and synthesis abilities - Organize and plan abilities - Troubleshooting - Teamwork - Ability to apply knowledge in practice Cognitive (Knowledge) - Fundamentals of Databases - Databases development methodology - Relational data model Procedural/Instrumental (Know how) - Database Design to different abstraction levels - Implementing Database Systems using a DBMS Attitudinal (To be) - Ability to create designs (creativity) - Discuss and clarify the diverse solutions for a problem
Skills and learning outcomes
Description of contents: programme
1. Data Life cycle 2. Data modelling: describing data at different levels 3. Components of a database management system (DBMS) 4. Relational data model 5. Use of a declarative query language: SQL 6. Data governance and information management roles 7. Managing unstructure data: SQL and NoSQL databases
Learning activities and methodology
AF1. THEORETICAL-PRACTICAL LECTURES. These lectures will present the knowledge that students should acquire. They will receive the lecture notes and will have basic texts of reference to facilitate the follow-up of the classes and the development of the subsequent work. Exercises, practical problems on the part of the student will be solved, and workshops and evaluation tests will be carried out to acquire the required skills. AF2. TUTORIES. Individualized assistance (individual tutorials) or group (collective tutorials) to students given by the teacher. AF3. INDIVIDUAL OR GROUP STUDENT WORK. MD1 THEORY LECTURE. Talks with support of computer and audiovisual media, in which the main concepts of the subject are developed and the materials and bibliography are provided to complement the students' learning process. MD2. PRACTICES. Resolution of practical cases, problems, etc. organized by the teacher individually and/or in groups. MD3. TUTORIES. Individualized assistance (individual tutorials) or group (collective tutorials) to students given by the teacher. For 6 credits subjects, 4 hours will be dedicated with 100% of attendance required.
Assessment System
  • % end-of-term-examination 50
  • % of continuous assessment (assigments, laboratory, practicals...) 50
Calendar of Continuous assessment
Basic Bibliography
  • Dolores Cuadra, Elena Castro, Ana Mª Iglesias, Paloma Martínez, Fco. Javier Calle, Cesar de Pablo, Harith Al-Jumaily, Lourdes Moreno. Desarrollo de Bases de Datos: Casos prácticos desde el análisis a la implementación. RA-MA. 2012
  • Gaurav Vaish . Getting Started with NoSQL. Packt Publishing. 2013
  • Henry Korth, S. Sudarshan, Abraham Silberschatz. Database System Concepts, 6th edition. McGraw-Hill Education. 2010
  • Ramez Elmasri, Shamkant B. Navathe. Fundamentals of Database Systems . Pearson. 2017
Recursos electrónicosElectronic Resources *
(*) 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.