Part of this Programme
Level of Qualification|Semesters|ECTS
Bachelor | Semestral | 6
Year | Type of course unit | Language
2 |Mandatory |Português
Total of Working Hours | Duration of Contact (hours)
168 | 60
Recommended complementary curricular units
Prerequisites and co-requisites
Introduction to Database Concepts Modeling Entity Relationship Physical Modeling Relational SQL Commands DDL, DML, Views Data Model Optimization: Normalization Schema refinement: Normalisation and Transactions concept Architecture of DBMS and some Advanced SQL
At the end of the course the student must obtain the following knowledge and skills: - Understanding the reasons why companies need to manage databases - What is concetual and physical database modeling - Knowledge of competition concepts and transactions - Acquisition of the fundamentals of SQL commands ¿Structured Query Language - Knowledge of the main suppliers of database technologies (DBMSs)
Teaching methodologies and assessment
In the continuous assessment, the theoretical component, which is performed using multimedia and audiovisual content, will have a weight of 50%, broken down by 2 minitestes, a final test and an analysis of student participation. The practical component, which is carried out using technical database tools, will also have a weight of 50%, where a work will be carried out, 2 mini-tests and an analysis of the student's participation. In any of the components, the minimum grade is 8, with the final grade being 10.
Date, C.J., 2003. An Introduction to Database Systems, 8 edition. ed. Pearson, Boston.
Elmasri, R., Navathe, S.B., 2015. Fundamentals of Database Systems, 7 edition. ed. Pearson, Hoboken, NJ.
Silberschatz, A., Korth, H., Sudarshan, S., 2010. Database System Concepts, 6 edition. ed. McGraw-Hill Education, New York.