This course aim is to understand the need of secondary storage, to learn the wide diversity of solutions and to become skilled at choosing and implementing the most appropriate in each case.
Agenda will cover the physical level from elementary to the Relational Model for database management. To achieve these objectives, the student must acquire a set of generic capabilities, knowledge, skills and attitudes.
1.- Cross/Generic Capabilities
o Analysis and synthesis abilities (PO a)
o Organize and plan abilities
o Troubleshooting (PO c, e)
o Teamwork (PO d)
o Ability to apply knowledge in practice (PO c, e, k)
2.- Specific Capabilities
o Cognitive (Knowledge) (PO a)
- Fundamentals of Databases
- Basic File Structures
- Relational Data Model
o Procedural/Instrumental (Know how) (PO a, b, c, e, g, k)
- Abstraction and design of an information system using the Relational Model
- Use of tools provided by RDBMS for creating, operating and controlling DB
- Develop and implement tests for proving correctness and benefits of a database design.
- Plan and manage adequate physical organizations for an information system
- Implementing File Structures (on RDBMS and prog. languages)
- Evaluate the performance of diverse physical structures
o Attitudinal (To be) (PO c, i)
- Ability to create designs (creativity)
- Concerns about the effectiveness
- Concerns about the efficiency
- To discuss and clarify the diverse solutions to a problem
The aimed competences are of diverse type: basic (CB2), general (CG1, CG2, CG3, CGB4) and specific (CECRI5, CECRI7, CECRI12, CECRI13).