Skip to main content

ISLA Santarém 15498

Database II

Computer Networks and Systems
  • ApresentaçãoPresentation
    UC Database II is a fundamental component for Information Technology courses including Computer Networks and Systems, Systems Programming, among others. Its main objective is to provide the student with a solid foundation that involves installing, configuring and administering a database server. It also aims to enable the student to understand how a Database Management System (DBMS) works internally, including techniques used to manage transactions, create and process queries. Furthermore, it considers that students are capable of evaluating the management mechanisms of a DBMS. It also encompasses tasks to compare different programming strategies in relational databases, as well as to analyze the benefits of physical data structures and to index the processing of queries and transactions in a relational DBMS.
  • ProgramaProgramme
    1. Install and configure Database servers. 2. Define security policies. 3. Manage Databases 4. Relational algebra 5. SQL – Structured Query Language 5.1 Data Manipulation Language (DML) 5.2 Data Definition Language (DDL) 5.3 Create and Manipulate Views 5.4 Create and Manipulate Indexes 6. Database objects 6.1 Tables 6.2 Views 6.3 Triggers 6.4 Stored Procedures 7. SQL Programming
  • ObjectivosObjectives
    .::. The objectives of the curricular unit are: O1. Install, configure and manage a database server; O2. Define and apply security policies; O3. Monitor occurrences on the data server; O4. Define and apply coherent data backup strategies; O5. Create Databases on the SQL server; O6. Define database objects; O7. Create, alter and delete tables and indexes in SQL; O8. Apply the concept of transaction; O9. Apply privileges and control access. .::. At the end of the curricular unit students should be able to: C1. Master the mechanisms of the Database Management System (SGBD); C2. Manage techniques for creating scripts in relational databases. C3. practice techniques associated with transaction management, creation and processing of queries.
  • BibliografiaBibliography
    Damas, Luís (2005). SQL - Structured Query Language. FCA, Editora de Informática. Jobstraibizer, F. (2009). SQL para Profissionais. Universo dos Livros. Magalhães, a. (2012). SQL Server 2012 – Curso Completo. FCA, Editora de Informática. Vieira, Robert (2012). Beginning Microsoft SQL Server 2011 Programming, John Wiley and Sons Ltd.
  • MetodologiaMethodology
    Classes will use the expository method for theoretical concepts and the demonstrative method for practical content. The interrogative method will also be used during the assessment of learning through conceptual and practical exercises to be delivered at the end of each class (in person). Furthermore, Active Methodologies (Flipped Classroom and Problem/Project Based Learning) will be applied in the Scientific Research Project with the presentation of an Evaluative Seminar. Furthermore, the UC has 4 distinct assessment elements, namely: (a) Intermediate Work (class by class); (b) Practical Project; (c) Group Seminar; and (d) Theoretical/Practical Assessment requiring the student's mandatory participation in all of them. Therefore, students must, without fail, participate in the 4 assessments to calculate their Final Grade. Summary: (1) Expository and Interrogative Methodology; (2) Active Methodologies: Flipped Classroom and Problem/Project Based Learning.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    6
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não
  • AvaliaçãoEvaluation

    Época Normal - Avaliação com Trabalhos Intermediários (aula a aula) (*): O estudante realiza individualmente atividades de avaliação ativa (TI - Trabalhos Intermediários - aula a aula) ao longo do semestre. Realiza também dois testes de avaliação individual, sendo eles: Avaliação com Prova Teórico/Prática (FRE - Frequência) e Avaliação com Projeto Prático (PP - contendo todos os conteúdos vistos em aula). Além disso, apresenta um Trabalho Científico: Seminário (TCS). O estudante aprova se a classificação final for superior ou igual a 9.5 valores em 20 valores.

    (*) A realizar no decorrer do semestre.

    A classificação final é calculada pela fórmula: 

    Classificação Final = 0.2*(TI) + 0.3*(FRE) + 0.3*(PP) + 0.2*(TCS), conforme descrição na Tabela abaixo. 

    Época Normal - Avaliação final: O estudante realiza o exame completo e aprova se obtiver classificaçãos superior ou igual a 9.5 valores em 20 valores.

    Épocas de Recurso e Especial: O estudante realiza o exame completo e aprova se obtiver classificação superior ou igual a 9.5 valores em 20 valores.

     

    Descrição

    Data limite

    Ponderação

    TI - Trabalhos Intermediários (aula a aula)

    Consultar Moodle, consoante a turma.

    20%

    FRE - Prova Teórico/Prática (Frequência)

    Consultar Moodle, consoante a turma.

    30%
    PP - Projeto Prático Consultar Moodle, consoante a turma. 30%
    TCS - Trabalho Científico: Seminário Consultar Moodle, consoante a turma. 20%

    (...)