Competencies and objectives


Course context for academic year 2023-24

Database design subject gives a more detailed insight into concepts previously presented in Fundamentals of database subject and, also, considering every stage in the database design process. Performing this process in the right manner is crucial for ensuring that the resulting database efective and efficiently agrees with the user requirements and expectations. This course is the foundation of other subjects related to the design and management of systems that deal with huge amount of data and how they are integrated in the business process.



Course content (verified by ANECA in official undergraduate and Master’s degrees) for academic year 2023-24

Specific Competences (CE)

  • CE12 : Coneixement i aplicació de les característiques, funcionalitats i estructura de les bases de dades, que permeten el seu adequat ús, i el disseny i l'anàlisi i implementació d'aplicacions basades en ells.
  • CE13 : Coneixement i aplicació de les eines necessàries per a l'emmagatzematge, processament i accés als sistemes d'informació, incloent-hi els basats en web.




Learning outcomes (Training objectives)

No data



Specific objectives stated by the academic staff for academic year 2023-24

Specific competences (CE)
CE12: Understand and apply the characteristics, functionalities and structure of databases to allow their correct use and design, analyze and implement applications based on the same
CE13: Understand and apply the tools needed for the storage, processing and access to Information Systems, including web-based systems
Learning goals
-Acquire basic knowledge and techniques to be able to learn and develop new methods and technologies, as well as skills to face up with novel situations
-Ability for solving problems with own initiative, informed decision making, autonomy and creativity
-Communicate knowledge, capabilities and skills related to Computer Engineer profession
Subject objectives/competences
-Design a database: conceptual design by using the EER model, logical design by using the Relational model, and Physical design by using the Oracle DBMS.
-Know issues related to management and security of databases




Code: 34014
Lecturer responsible:
Credits ECTS: 6,00
Theoretical credits: 1,20
Practical credits: 1,20
Distance-base hours: 3,60

Departments involved

    Theoretical credits: 1,2
    Practical credits: 1,2
    This Dept. is responsible for the course.
    This Dept. is responsible for the final mark record.

Study programmes where this course is taught