Skip to main content

ISLA Santarém 1792

Databases

Information Technology Management (ISLA Santarém)
  • ApresentaçãoPresentation
    Databases are part of Information Systems and are used in most of the computer applications we use on a daily basis. In addition, the value we attribute to data is increasing, and decisions are increasingly driven by the analysis of stored data. The Database course aims to provide students with the fundamental knowledge of how to store data in a structured way, without redundancy, and how to process data to obtain information. Understanding these concepts allows us to define how to structure data in order to guide the development of an application. 
  • ProgramaProgramme
    1. Basic concepts about databases: File System vs. DBMS. Database management systems. Database models. Transactions. Performance and scalability. Data access and security. 2. Design of relational databases: Entity-relationship model. The theory of normalization. 3. Relational algebra: SQL - Structured Query Language. Data Manipulation Instructions. (DML). Structure Definition Instructions (DDL).Creation and Manipulation of Views. Creation and Manipulation of Indexes. 5. Database interrogation languages: T-SQL and PL-SQL. 6. NoSQL databases: ACID and BASE. Design and Implementation. 7. Database applications. 8. Database development tools.
  • ObjectivosObjectives
    O1. Provide students with knowledge of fundamental concepts, methods and techniques in the field of databases. O2. Build relational data models suited to the requirements of an information system, using conceptual and logical database design techniques. O2 Explore the potential of a database management system (DBMS). O3 Explore NoSQL databases. Competences: C1. Design database systems suited to the needs and management objectives of organizations. C2. Create a database by implementing the mechanisms necessary for data integrity. C3. Appropriately use information extraction and interrogation operations from a database. C4. Use database management mechanisms, taking into account exploitation issues (security, competition).
  • BibliografiaBibliography
    Gouveia, F. (2021). Fundamentos de Bases de Dados. Lisboa: FCA.  Meier, A., & Kaufmann, M. (2023). SQL & NoSQL databases. Springer Fachmedien Wiesbaden.  Elmasri, R & Navathe, B. (2021).Fundamentals of Database Systems, 7th edition. Pearson  Silberschatz, A., Korth, H. F. & Sudarshan, S. (2022). Database System Concept (7th edition). McGrawHill Education.
  • MetodologiaMethodology
    Face-to-face:  Use of the Problem-Based Learning (PBL) methodology,  where each of the topics studied will follow the following phases: a) identification and definition of the problem to be solved. b) Accessing and using relevant information to solve the problem. c) Problem solving. d) Presentation of results and critical analysis.  Independent:  Completing additional exercises proposed by the instructor. The instructor provides feedback on the results obtained by the student in solving the proposed problems, either in person in the classroom or through the Moodle platform.  
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    7
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não
  • AvaliaçãoEvaluation

    Avaliação Curricular (contínua):

    A1. Projeto prático (grupo.

    A2. Teste teórico/prático individual.

    A classificação final é calculada através da fórmula Classificação Final = 0,5*A1+0,5*A2.

    O estudante é aprovado se obtiver classificação igual ou superior a 9,5 valores.

    Avaliação Final ou em Época de Recurso ou Época Especial (A):

    Hipótese 1:

    A1. Projeto prático (grupo). O estudante participou no trabalho de grupo e obteve classificação positiva na componente individual: mantém a nota que será considerada nestas épocas de avaliação.

    A2. Teste teórico/prático (individual). O estudante realiza este Teste em qualquer das épocas em que se submeta a avaliação.

    A classificação final é calculada através da formula prevista na avaliação Curricular (contínua).

    Hipótese 2:

    O estudante não participou no trabalho de grupo ou participando obteve classificação negativa na componente de avaliação individual.

    Avaliação Final, Avaliação em Época de Recurso/Especial (A):

    O estudante realiza o exame teórico-prático (A=100%) e é aprovado se obtiver uma classificação igual ou superior a 9,5 valores em 20.