Teaching GuideTerm Faculty of Computer Science |
Grao en Enxeñaría Informática |
Subjects |
Databases |
Contents |
|
|
|
Identifying Data | 2018/19 | |||||||||||||
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 | Relationship definition Domains and attributes Keys Integrity constraints The SQL language |
Relational algebra | Expressions Operators |
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 |
|