Educational guide School of Engineering |
english |
Bachelor's Degree in Computer engineering (2010) |
Subjects |
DATABASES |
Contents |
IDENTIFYING DATA | 2023_24 |
Subject | DATABASES | Code | 17234103 | |||||
Study programme |
|
Cycle | 1st | |||||
Descriptors | Credits | Type | Year | Period | ||||
6 | Compulsory | First | 2Q |
Competences | Learning outcomes | Contents |
Planning | Methodologies | Personalized attention |
Assessment | Sources of information | Recommendations |
Topic | Sub-topic |
1. Basic concepts |
1.1. Data Representation 1.2.External Memory 1.3. Logical and Physical Level 1.4. Concepts, Origin and evolution of Databases 1.5. Architecture of three levels of the DBMS 1.6. BD models 1.7.Languages: classification, use 1.8. BD administration |
2. Modeling of Databases | 2.1. Introduction to the design of Databases 2.2. Design Stages 2.3. Conceptual Design: The ER Model 2.4. Logical Design of Databases |
3. Relational Databases: Design and use | 3.1. Introduction to the Relational Model 3.2. Data Structure 3.3. Operations of the Relational Model 3.4. Rules of Integrity 3.5. Relational algebra 3.6. The SQL language: DDL, DML, DCL, specialized languages |
4. Complementary Concepts | 4.1. Logical Components 4.2. Transactions 4.3. Normalization 4.4.Storage |