Databases - Modeling and SQL Concepts
- Details
- Category: Discipline
- Não
- The course introduces the concepts of database design and analysis, with a focus on the relational model, the logical design of databases and implementation. The main objective of this course is introducing the student to the fundamental concepts involved in the creation of database management systems, as well as its practical difficulties.
- Semestral
Descrição dos instrumentos de avaliação (individuais e de grupo) ¿ testes, trabalhos práticos, relatórios, projetos... respetivas datas de entrega/apresentação... e ponderação na nota final.
Exemplo:
Descrição
Data limite
Ponderação
Teste de avaliação 1 29-05-2026
30%
Teste de avaliação 2 20-06-2026
30%
Trabalho de Grupo
20-06-2026
30%
Participação
10% - Welcoming and presentation of the teacher and program. Analysis and Design of Databases. Definition, objectives, types and concepts; Entity-Relationship model; UML model; Normalization of relational schemas; Relational algebra. Logical Design - SQL Queries. Data manipulation in SQL; Selection, insertion, removal and update instructions; Filtering, ordering, aggregation, joining and manipulation of null values operations; Data description in SQL; CREATE, ALTER, DROP, UPDATE and DELETE instructions. Application of Databases. Database Administration; Vulnerabilities in Databases;
- This curricular unit aims to provide the students with knowledge of analysis and design of Databases, use and administration of database tools and mastery of the SQL language and its use.
- Mandatory
- Exposition Sessions, in class or online, with concepts, definitions and theoretical framework - Practical lessons, with realization of individual and group work - Practical exercises based in analysis, design, creation and use of Databases. Continuous evaluation: - Written Test 1, 30% of the final grade - Written Test 2, 30% of the final grade - Participation and presence in class, 10% of the final grade - Group work, 30% of the final grade. Approval with a evaluation of 10 or higher. There exists a requirement for the average of the Written test grades to be more or equal to 8 and the group grade to be more or equal to 8. Appeal Evaluation: -Written exam of recover 100% of the final grade. This is intended for students who have not passed the continuous evaluation.
- Português
- Raghu Ramakrishnan e Johannes Gehrke, Database Management Systems, McGraw--¿Hill, 3ª edição, 2003, ISBN 0072465638
- 4
- 0
- 5
- 1
- IPLUSO6130-22250
- Databases - Modeling and SQL Concepts
- 22250
- 6130
- Cybersecurity
