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.
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.
{cite}mysql_Workshop,Elmasri,carlsocoronel,Silberschatz,cjdate,codd.
::::{grid} :gutter: 2
:::{grid-item}
:header-rows: 1
:name: example-table
* - **Period**
- **Date**
* - First
- 13/09/2024
* - Second
- 25/10/2024
* - Final
- 25/11/2024
::: :::{grid-item} :margin: auto auto 0 0
:header-rows: 1
:name: example-table
* - **Presentation**
- **Date**
- **Porcentage**
* - First
- 16/09/2024
- 10 %
* - Second
- 17/11/2024
- 10 %
* - Final
- 02/12/2024
- 80 %
::: ::::
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.
:::{tip} 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. :::
::::{grid} :gutter: 2
:::{grid-item-card} ETITC Parking
- Isaac Pachón Lugo
- Luis Ángel Duran Serrano
- Stiven Jherbey Palacio Escobar
- David Santiago Babativa González. :::
:::{grid-item-card} ETITC Restaurant
- Juan Lara
- Daniel Torres
- Diego Burgos
- Kevin Ochoa ::: ::::
::::{grid} :gutter: 2
:::{grid-item-card} ETITC workers attendence
- Yeison Andrés Ruano Viuche
- Ana Sofia Cobaleda Rodríguez
- Cristian Felipe Vargas Perez
- Jonh Bayter Jiménez. :::
:::{grid-item-card} Anti-theft security
- Juan Diego Rivera Silva
- Carlos Alberto Mojica
- Brayan Chacón
- Michael Andres orjuela ::: ::::
::::{grid} :gutter: 2
:::{grid-item-card} Fish Company
- Kevin Ricardo Díaz Sandoval
- Darwin Esteban Escobar Arias
- Juan Diego Daza Beltrán
- Eliezer Alejandro Rojas Beltrán :::
:::{grid-item-card} ::: ::::
(referencias)=
- The-MySQL-Workshop
- SQL-101
- Learn-SQL
- banco-de-dados
- SQL-interview-questions
- sql-cookbook
- SQL-exercise
- Intro-Database-SQL
:::{important} You can find all reference's books in the Google Drive folder References, to get acces you must enter with the institutional email. :::