Teaching GuideTerm Faculty of Computer Science |
Grao en Enxeñaría Informática |
Subjects |
Databases |
Contents |
|
|
|
Identifying Data | 2019/20 | |||||||||||||
Subject | Databases | Code | 614G01013 | |||||||||||
Study programme |
|
|||||||||||||
Descriptors | Cycle | Period | Year | Type | Credits | |||||||||
Graduate | 2nd four-month period |
Second | Obligatory | 6 | ||||||||||
|
Topic | Sub-topic |
Relational databases | SQL: advanced queries, DDL, embedded SQL, views. |
Database design | Design problems Design phases Normalization Conceptual design ER to relational model translation |
File systems | Files Indexes |
Concurrency and fail recovery | Problems due to concurrency and failures Transactions Recovery techniques Concurrency control techniques |
|