Data Bases
1
2022-2023
02000649
Industrial Engineering
Portuguese
Face-to-face
SEMESTRIAL
6.0
Compulsory
2nd Cycle Studies - Mestrado
Recommended Prerequisites
Not applicable.
Teaching Methods
Theoretical classes with detailed presentation, using audiovisual means, of the concepts, principles and fundamental theories and solving of basic practical exercises to illustrate the practical interest of the subject and exemplify its application to real cases.
Laboratory classes where practical aspects of database design will be addressed, allowing the student to consolidate the theoretical background involved on a typical database design project. Six assignments will be proposed covering all stages of database design.
Learning Outcomes
This curricular unit main goal is to provide students with important theoretical knowledge fundamental for the project of a database system. After attending this course, the student should understand the background theory behind a database project, namely requirement analysis, data analysis and modeling and data manipulation using an appropriate query language like SQL.
After attending this course, the student should be able to develop computer software that integrates a database, taking into account all the methodologies learned.
Special care will be put in the practical component of the course. The student will be introduced to a set of tools typically used on a database project.
Work Placement(s)
NoSyllabus
Introduction to Database Management Systems
Conceptual data models: ER model
The relational model
Normalization theory and relational algebra
SQL Query Language
Development of a Database application
Integrity and Security in a DBMS.
Head Lecturer(s)
Pedro Nuno San-Bento Furtado
Assessment Methods
Assessment
Mini Tests: 20.0%
Project: 30.0%
Exam: 50.0%
Bibliography
• Ramez Elmasri e Shamkant B. Navathe (2003), Fundamentals of Database Systems (4th Edition), Addison-Wesley Publishing
• Raghu Ramakrishnan e Johannes Gehrke (2003) Database Management Systems (3rd Edition), McGraw-Hill
• Paulo Peixoto (2009) – Diapositivos das aulas teóricas de Bases de Dados, DEEC-FCTUC.
• Paulo Peixoto (2009) – Folhas Laboratoriais de Bases de Dados, DEEC-FCTUC.