Course Description
-
Course Name
Databases
-
Host University
Universidad del Norte
-
Location
Barranquilla, Colombia
-
Area of Study
Systems Engineering
-
Language Level
Taught In English
-
Prerequisites
Intermediate skills in computer programming
Algorithms & Complexity
-
Contact Hours
64 -
Recommended U.S. Semester Credits4
-
Recommended U.S. Quarter Units6
Hours & Credits
-
Overview
DESCRIPTION ? COURSE CATALOG
This course introduces fundamental data bases topics focusing in the relational model. Design concepts are put into practice with the implementation of a real case application over a relational database system.BIBLIOGRAPHICAL REFERENCES: text book, other supplemental materials
Silberschatz, Abraham et al. Fundamentos de Bases de datos
Connolly, Thomas et al. Sistemas de Bases de Datos. Un enfoque práctico para diseño, implementación y gestiónCOURSE LEARNING OUTCOMES
- Identify the characteristics and strengths of databases systems over file based systems.
- Model information systems using the relational model.
- Extract information of databases systems using SQL.
- Develop software applications that interact with databases systems.
- Model information systems using the entity-relationship model.
TOPICS COVERED
- Introduction and basic concepts of Databases
- Entity ? Relationship model
- Relational model
- SQL
- Relational database design. Normal forms
- Integrity and security
- Special Topics: Transactions, Concurrency, Indexation