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