Subject: Database Management Systems

Scientific Area:

Computing

Workload:

80 Hours

Number of ECTS:

7,5 ECTS

Language:

Portuguese

Overall objectives:

1 - This course is designed in a way that the participants learn to think in an independent and creative way on how to design and implement systems and applications with databases and related and technologies.
2 - One of the consequences of the tremendous advance in TI is the opportunity of collecting and generating enormous amounts of data. So that they are well organized, easily available and changeable in an efficient and effective way, one needs functional Data Base Management Systems (DBMS) as well as a correct application of their potentialities and functionalities.

Syllabus:

1 - Entity-Relationship (E-R) model, relational model and relational algebra, convertion of E-R model to a relational schema, SQL language, Normalization
2 - Transactions, Files and Indexation, Views, Alternatives to E-R modeling like Object Role Modeling (ORM), Concurrency management, Faul recovery, DBMS architectures, Clustering, Comparative Analysis of current best open source DBMS, MySQL storage engines, Optimization.
3 - MySQL DBMS and XAMPP suite for development of DBMS based applications, PHP programming language.

Literature/Sources:

N/A , Diapositivos das aulas teóricas ,
A. Silberschatz, H. Korth, S. Sudarshan , Database System Concepts (5ª ed.) ,

Assesssment methods and criteria:

Classification Type: Quantitativa (0-20)

Evaluation Methodology:
Theory component - 40% (individual): 2 tests 20% + 20%. Practical component - 40% (in groups of 3 students) with 2 projects: Research Essay (RE) - 25% with 3 sub-components: 1) written paper resulting of research on a topic in the discipline's syllabus - 7,5% 2) Oral defense of the essay with presentation of slides summarizing the respective essay and answering of questions regarding its content - 7,5% 3) continuous evaluation (individual) 10%; Data Base Development Project (DBDP) - 35% with 3 sub-components: project involving conceptual modeling of a DB and respective implementation using PHP+MySQL - 12,5% 2) Oral defense of the project by presentation of implemented functionalities and answering questions regarding the implementation - 12,5% 3) continuous evaluation (individual) - 10%.