Subject: Database Management Systems I

Scientific Area:

Computer Science

Workload:

64 Hours

Number of ECTS:

6 ECTS

Language:

Portuguese

Overall objectives:

1 - Recognize the need/functionality of database management systems.
2 - Know concepts regarding the structures of databases.
3 - Identify the models used in database management.
4 - Know data modeling techniques and their basic concepts.
5 - Implement systems and applications with databases and associated technologies.

Syllabus:

1 - Introduction to DBMS.
2 - Entity-Association Model.
3 - Relational Model - Structure of Databases.
4 - Model and Relational Algebra.
5 - Structured Query Language (SQL).
6 - Normalization.
7 - Files and Indexing.
8 - Transactions.
9 - Applications development

Literature/Sources:

A. Silberschatz, H. Korth, S. Sudarshan , 2005 , Database System Concepts (5ª ed.) , McGraw-Hill Education

Assesssment methods and criteria:

Classification Type: Quantitativa (0-20)

Evaluation Methodology:
In accordance with the expected for the Professional Higher Technical Courses.