Code: | CC2005 | Acronym: | CC2005 | Level: | 200 |
Keywords | |
---|---|
Classification | Keyword |
OFICIAL | Computer Science |
Active? | Yes |
Web Page: | http://www.dcc.fc.up.pt/~edrdo/aulas/bd |
Responsible unit: | Department of Computer Science |
Course/CS Responsible: | Bachelor in Computer Science |
Acronym | No. of Students | Study Plan | Curricular Years | Credits UCN | Credits ECTS | Contact hours | Total Time |
---|---|---|---|---|---|---|---|
L:B | 3 | Official Study Plan | 3 | - | 6 | 56 | 162 |
L:CC | 68 | Plano de estudos a partir de 2014 | 2 | - | 6 | 56 | 162 |
L:EG | 14 | The study plan from 2019 | 2 | - | 6 | 56 | 162 |
L:F | 1 | Official Study Plan | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:G | 0 | study plan from 2017/18 | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:M | 18 | Official Study Plan | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:Q | 4 | study plan from 2016/17 | 3 | - | 6 | 56 | 162 |
MI:ERS | 64 | Plano Oficial desde ano letivo 2014 | 2 | - | 6 | 56 | 162 |
Provide the students with the fundamentals and practice necessary for the design, implementation and analysis of relational databases.
The students should acquire the following competences:
Should know:
Should be able to do:
Introduction to Database Systems
Basic Concepts. Main characteristics and advantages of using the database approach. Typical DBMS Functionality. The database design process.
The ER and EER Models
The ER model: entity types, weak entity types, attributes, relationships and key attributes. The EER Model: subclasses, superclasses, specialization, generalization, categories. ER and EER diagrams.
The Relational Data Model
Relations, attributes, domains and tuples. Superkeys, primary keys and foreign keys. Integrity Constraints. Relational schema. Mapping the ER and EER models to the relational model.
The Relational Algebra and Calculus
Relational algebra operations. Tuple relational calculus and domain relational calculus.
The SQL Language
The DDL (Data Definition Language) of SQL: data definition, constraints and domains. The DML (Data Manipulation language) of SQL: simple, nested and correlated queries. Join, aggregate, insert, remove and update operations. Views.
Integrity and Security
Referential integrity. Embedded SQL. Assertions and triggers. Transactions, concurrency and fault tolerance.
Normalization
Normal forms and normalization of relations. Functional, multivalued and join dependencies. Non-additive join decomposition. Normal forms: 3rd, 4th and Boyce-Codd.
Physical Data Organization
Basic file structures, hashing and indexing.
Theory classes and practical classes with practical assignments.
designation | Weight (%) |
---|---|
Exame | 60,00 |
Teste | 20,00 |
Trabalho prático ou de projeto | 20,00 |
Total: | 100,00 |
designation | Time (hours) |
---|---|
Estudo autónomo | 70,00 |
Frequência das aulas | 56,00 |
Trabalho laboratorial | 36,00 |
Total: | 162,00 |
Student valuation components and corresponding weight: