Data Bases

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)

No

Syllabus

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)

Catarina Helena Branco Simões da Silva

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.