|
Teaching GuideTerm Faculty of Economics and Business |
| Grao en Ciencias Empresariais |
 Subjects |
| Databases for Business |
| Contents |
|
|
| Identifying Data | 2023/24 | |||||||||||||
| Subject | Databases for Business | Code | 650G01022 | |||||||||||
| Study programme |
|
|||||||||||||
| Descriptors | Cycle | Period | Year | Type | Credits | |||||||||
| Graduate | 1st four-month period |
Third | Obligatory | 6 | ||||||||||
|
||||||||||||||
| Topic | Sub-topic |
| Introduction to databases. | Relational databases. Database Management Systems. |
| Relational model. | Definition of relationship. Domains and attributes. Keys. Integrity Constraints. |
| Database design methodology. | Bad design problems. Methodology. |
| Conceptual design of databases. | Introduction to the Entity-Relationship Model. |
| Database query language: SQL. | Query sentences. Definition and update sentences. |
| Databases as support for decision making. | Multidimensional databases, Data mining, Data warehouse and OLAP. |
| Creation and exploitation of databases in a DBMS: Microsoft Access. | Microsoft Access |
|
