ISLA IPGT 8448

Databases

• ApresentaçãoPresentation

  The course unit offers an in-depth exploration of principles and practices related to database management, equipping students to work as specialists in fields such as software development, data analysis, system administration, and data science. With a focus on advanced topics like complex modeling, query optimization, and data security, this UC is highly relevant in various fields, making it essential for deepening knowledge in the study cycle and preparing students for complex challenges in the field of information technology.
• ProgramaProgramme

  Databases Data concept Data model concept Database architecture Files and databases Relational databases Database management system architecture Relational Model Relational data structure Model integrity rules Data management in the relational model Tables, Records, Fields, and Keys Normalization Representation in non-normalized form DeMarco notation type Gane and Sarson notation type Codd's normalization stages Information integrity DBMS (Database Management Systems) Usage domains Architecture Configuration Database creation Database maintenance Implementation of security and integrity
• ObjectivosObjectives

  The learning objectives of the course unit include developing a strong knowledge of database systems, advanced skills in designing complex databases, query optimization, and data security, as well as the utilization of emerging technologies. Students also gain the ability to apply this knowledge to solve practical problems and effectively communicate complex concepts. Teamwork is emphasized for effective collaboration in database projects. These objectives prepare students for advanced challenges in information management and technology
• BibliografiaBibliography

      •    Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson.     •    Date, C. J. (2019). Database Design and Relational Theory: Normal Forms and All That Jazz (2nd ed.). Apress.     •    Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (Global Edition). Pearson.     •    Gouveia, F. (2021). Bases de Dados – Fundamentos e Aplicações (2ª ed.). FCA.     •    Belo, O. (2021). Bases de Dados Relacionais – Implementação com MySQL. FCA.
• MetodologiaMethodology

  The innovative methodologies to support the teaching and learning process in the course unit include active learning through problem-solving and case studies, collaboration on group projects, the use of interactive digital resources, regular formative assessments, and the practical application of knowledge in real-world projects. These dynamic and engaging approaches help students effectively and motivationally develop advanced database skills.
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não
• AvaliaçãoEvaluation

  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.

  Avaliação Contínua:

  Descrição	Data limite	Ponderação
  Teste Individual	Última Aula	60%
  Trabalhos realizados em sala de aula	Aula a que diz respeito o trabalho	40%

   

  Avaliação final:
  Todos os estudantes que não tenham concluído com sucesso a avaliação continua poderão realizar um exame final (100%) na época de avaliação definida pela instituição.