Checking date: 24/07/2024 19:32:27


Course: 2024/2025

Database Fundamentals
(19510)
Engineering Program for International Students (Plan: 335 - Estudio: 84)


Coordinating teacher: CALLE GOMEZ, FRANCISCO JAVIER

Department assigned to the subject:

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Desirable Skills It is recommended to have completed some course on - Discrete Mathematics - Computers Structures - Programming
Description of contents: programme
Topic 1. Introduction to Databases 1.1 Storage and Databases: need, evolution and typology. 1.2 Conceptualization of Databases 1.3 Database Management Systems 1.4 Structured DB vs. Analytical DB Topic 2. Structured Databases 2.1 Database Design: statics of the Relational Model 2.2 Database Manipulation: Relational Algebra 2.3 Interacting with Relational Databases: the SQL data language 2.4 Extensions and advanced elements of transactional DB 2.5 Introduction to the administration of transactional DB Topic 3. Analytical Databases 3.1 Massive Structured Databases: Data Warehouse 3.2 NoSQL Technologies: objectives and foundations 3.3 NoSQL Back-End for BigData: needs and solutions 3.4 Using NoSQL systems: manipulation and query 3.5 Replication and Distribution
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 to 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. AF9: FINAL EXAM. In which the knowledge, skills and abilities acquired throughout the course will be globally assessed. 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. MD3: TUTORIALS. Individualized (individual tutorials) or group (group tutorials) assistance to students by the professor. MD6: LABORATORY PRACTICES: Applied/experimental teaching in workshops and laboratories under the supervision of a tutor.
Assessment System


Basic Bibliography
  • Banker K., Bakkum P., Verch S., Garrett D., Hawkins T.. MongoDB in Action (2nd Ed). Manning Publications Co.. 2016
  • Elmasri R., Navathe S.. Fundamentals of Database Systems (7th ed.). Pearson Education. 2017
  • J. Calle. . Course Teaching Materials . (provided via Aula Global webpage) . 2024
  • Silverschatz, A., Korth, H. F. & Sudarshan, S.. Database System Concepts, 7th ed.. Mc-Graw Hill. . 2019
Recursos electrónicosElectronic Resources *
Additional Bibliography
  • Bradshaw S., Brazil E., Chodorow K.. MongoDB: The Definitive Guide: Powerful and Scalable Data Storage (3rd ed.). O'Reilly Media. 2019
  • Connolly TM, Begg CE. . Database Systems: a practical approach to design, implementation, and management. . Addison Wesley . 2015
  • Ramakrishnan, R.; Gehrke, J.. Sistemas de Gestión de Bases de Datos. (3ªed). WCB/McGraw Hill. . 2012
(*) 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.