|
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 |
|
