Teaching GuideTerm Faculty of Economics and Business |
Grao en Ciencias Empresariais |
Subjects |
Databases for Business |
Learning aims |
|
|
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 | ||||||||||
|
Learning outcomes | Study programme competences / results | ||
Assimilate the basic concepts of databases to improve the management capacity of the company's IT developments. | A1 A3 A4 A5 A6 A7 A8 A9 A11 A12 A16 A17 A18 A19 A20 |
B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14 |
C1 C2 C3 C4 C5 C6 C7 C8 |
Know the fundamentals of Database Management Systems (DBMS). | A4 A5 A20 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B14 |
C1 C2 C3 C6 C8 |
Know and understand the structures, restrictions and basic operations of the relational model. | A4 A5 A20 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B14 |
C1 C2 C3 C6 C8 |
Being able to create, feed and query a previously designed database using SQL in interactive mode. | A4 A5 A20 A21 A23 A24 |
B1 B2 B3 B4 B5 B7 B8 B11 B12 B14 |
C1 C2 C3 C6 C8 |
Understand the need to design conceptual models; know and be able to use the ER model. | A4 A5 A20 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B11 B14 |
C1 C2 C3 C6 C8 |
Learn to rationalize and formally reflect the information storage needs of the company in order to carry out an organization of the data that allows its efficient use. | A4 A5 A6 A16 A19 A20 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B11 B12 B14 |
C1 C2 C3 C6 C8 |
To know the existence of other models different from the relational one. | A4 A5 A20 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B11 B14 |
C1 C2 C3 C6 C8 |
Know the databases as a support for decision making (Data mining, Data warehouse and OLAP). | A4 A5 A16 A19 A20 A21 A24 |
B1 B2 B3 B4 B5 B7 B8 B10 B11 B12 B14 |
C1 C2 C3 C6 C8 |
Stay motivated to delve into computing as an essential tool for the performance of the profession. | A1 A5 A11 A19 A20 |
B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B14 |
C1 C2 C3 C4 C5 C6 C7 C8 |
|