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