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.