Bases de Datos I#
Tabla de Contenidos (ToC)#
Introducción
BDs Relacionales
Normalización
Diagramas Relacionales
Programación en MySQL
Administración
Objective#
Provide students with a solid understanding of the fundamental concepts of databases, including their modeling, querying, and use in information systems. Students will learn how to apply this knowledge to design and develop information systems that respond to specific requirements, using relational databases in a transactional multi-user environment.
Subject Learning Results (RAC)#
At the end of the course the student will be able to:
RAC 1: Identify, describe, and explain basic concepts of data bases: entities, attributes, relationships, and keys in the context of relational databases.
RAC 2: Apply normalization techniques to organize and design efficient and consistent databases.
RAC 3: Develop and execute database queries using SQL, interacting effectively with database management systems.
These learning outcomes ensure that students have the technical and analytical skills necessary to manage databases in real-world applications and develop software solutions that effectively utilize databases.
Grades#
For all periods the grade is divided into: Co-evaluation (10 %), self-evaluation (10 %), and teacher evaluation (80 %) which is divided into exams (40 %) and assignments (40 %). The first and second periods are 35 % of the final grade, while for the last period it is 30 %. In the first and second periods the exam consists of two tests: one practical (60 %) and the other theoretical (40 %).
The project is divide in two grades: first report (20 %) and last (80 %) assignment.
Truco
You can practice and complement the course by solving programming problems in any of the following pages:
Each solved problem, which has passed all the tests created for the page, can be exchanged for points. Very simple problems are not valid.
Projects#
Isaac Pachón Lugo
Luis Ángel Duran Serrano
Stiven Jherbey Palacio Escobar
David Santiago Babativa González.
Juan Lara
Daniel Torres
Diego Burgos
Kevin Ochoa
Yeison Andrés Ruano Viuche
Ana Sofia Cobaleda Rodríguez
Cristian Felipe Vargas Perez
Jonh Bayter Jiménez.
Juan Diego Rivera Silva
Carlos Alberto Mojica
Brayan Chacón
Michael Andres orjuela
Kevin Ricardo Díaz Sandoval
Darwin Esteban Escobar Arias
Juan Diego Daza Beltrán
Eliezer Alejandro Rojas Beltrán
References#
Repositories#
Books#
Henry Korth Abraham Silberschatz and S. Sudarshan. Database System Concepts. Volume 7 of. McGraw-Hill Education, edition, 2020. ISBN 0078022150, 9780078022159, 1260515044, 9781260515046.
Steven Morris Carlos Coronel. Database Systems: Design, Implementation, & Management. Volume of MindTap Course List. Cengage, 14 edition, 2023. ISBN 0357673034,9780357673034,9780357673072.
E. F. Codd. The relational model for database management: version 2. Volume of. Addison-Wesley, edition, 1990. ISBN 9780201141924,0201141922.
C. J. Date. Instructor's Manual for an Introduction to Database Systems. Volume of. 8th edition, 2003. ISBN.
Shamkant Navathe Ramez Elmasri. Fundamentals of Database Systems. Volume of. Pearson, 7 edition, 2016. ISBN 0133970779,9780133970777.
Scott Cosentino Thomas Pettit. The MySQL Workshop: A practical guide to working with data and managing databases with MySQL. Volume of. Packt Publishing, 1 edition, 2022. ISBN 1839214902,9781839214905.
Importante
You can find all reference’s books in the Google Drive folder References, to get acces you must enter with the institutional email.