Academic Year/course:
2017/18
453 - Degree in Mathematics
27025 - Database Systems I
Syllabus Information
Academic Year:
2017/18
Subject:
27025 - Database Systems I
Faculty / School:
100 - Facultad de Ciencias
Degree:
453 - Degree in Mathematics
ECTS:
6.0
Year:
4
Semester:
Second semester
Subject Type:
Optional
Module:
---
5.1. Methodological overview
Theoretical classes.
Problem solving sessions.
Acquisition of skills in the use of computer tools.
Exposition of the solutions to the proposed activities and problems.
5.2. Learning tasks
Development of skills in the use of computer tools.
Problem solving with the support of computer tools.
Resolution of cases drawn from the real world.
Analysis and specification of the solutions to the proposed practical cases.
5.3. Syllabus
1. Overview of database technology.
2. Table-based data models.
3. The relational model.
4. SQL: query language for relational databases.
5. Technological design in databases: methodology.
6. The conceptual schema: entity-relationship model. Perspective, formal model of knowledge representation and data model.
7. Textual specification of entity-relationship schemes.
8. An extended entity-relationship model.
9. Rules for the transformation of an entity-relationship schema into a relational schema.
5.4. Course planning and calendar
In addition to the final test, up to two partial tests will be done during the course.
5.5. Bibliography and recommended resources
-
Connolly, T. M., & Begg, C. E. (2005). Sistemas de bases de datos : un enfoque práctico para diseño, implementación y gestión. Madrid [etc.] : Pearson Educación, D.L. 2005.
Date, C. J., & Darwen, H. (1997). A Guide To Sql Standard (4th ed). Reading: Addison-Wesley.
- Elmasri, R., & Navathe, S. B. (2007). Fundamentos de sistemas de bases de datos. Madrid [etc.] : Pearson Addison Wesley, D.L. 2007.