Fundamentals of Databases

Category: Discipline
  • Luís D., ¿SQL¿, Editora FCA, 1999. Gouveia, F., Fundamentos de Base de Dados, Editora FCA, 2014 José Luís Pereira, ¿Tecnologia de bases de dados¿, Editora FCA, 1998. Alberto Magalhães SQL Server 2008 Curso Completo - 2ª Edição Raghu Ramakrishnan, Database Management Systems, McGraw-Hill, 2001. Silberschatz, Korth, Database Systems Concepts, III Ediçao, McGraw Hill, 1997.  
  • Computing Engineering
  • 6155
  • 13304
  • Fundamentals of Databases
  • ISLA Gaia6155-13304
  • 1
  • 6
  • 0
  • 27
  • Não
  • Português
  • Innovative methodologies at UC include active learning through problem-solving and case studies, collaboration on group projects, use of interactive digital resources, regular formative assessments, and practical application of knowledge in real-world projects. These dynamic and engaging approaches help students develop advanced database skills in an effective and engaging way.
  • Mandatory
  • -The design of appropriate information systems to users' needs and objectives of organizational management; -The definition of data models, according to the general principles of database theory and standards; -The definition of a schema of the database and understanding of the basics of the relational model; Computerization is a problem students should be able to: - Designing appropriate information systems to users' needs and objectives of organizational management; - Define a data model, according to the general principles of database theory and standardization; - Define the schema of the database and understand the basics of the relational model;
  • Introduction The information system of an organization. Concept of Database and Management System Database. Development of Information Systems. Entity-relationship model Entities and attributes. Types of associations. Relational Model   Notion of relationship, relational databases and relational schema.  Integrity constraints.   Draft Relational Database Mapping entity-relationship diagrams to relational schemas. Standardization.   Relational Algebra SQL Language Defining the structure of databases. Data modification.

  • Metodologia de avaliação:

    Os estudantes podem optar por uma das seguintes opções:

    Avaliação Curricular

     

    Opção 1

    Trabalho Prático (35%)

    Teste ( 65%)

     

    Opção 2

    Teste de Avaliação Global (100%)

     

    Avaliação Final

    Todos os estudantes que não tenham concluído com sucesso a avaliação curricular terão direito a um exame final, a realizar numa época de avaliação.
  • Semestral
  • This curricular unit aims at the development of skills in the project area and implementation of information systems and databases.

Databases

Category: Discipline
  •     •    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.
  • Development of Artificial Intelligence Applications
  • 7058
  • 8448
  • Databases
  • ISLA Gaia7058-8448
  • 1
  • 6
  • 0
  • 27
  • Não
  • Português
  • 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.
  • Mandatory
  • 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
  • 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

  • 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.

     
  • Semestral
  • 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.

Dissertation

Category: Discipline
  • Human Resource Management
  • 1192
  • 3157
  • Dissertation
  • ISLA Gaia1192-3157
  • 2
  • 54
  • 1387
  • 27
  • Sim
  • Português
  • Optional
  • Anual

Fundamentals of Physics

Category: Discipline
  • Alonso, M. & Finn, E. J. (1981). Física um curso universitário (vol. I e II). São Paulo: Ed. Edgard Blucher, Lda. Deus, J. D. (1992). Introdução à Física . Lisboa: Editora McGraw-Hill de Portugal, Lda, Zitzewitz, P. W. (1999). Physics: Principles and Problems - Student Edition , McGraw-Hill Editions. Bueche, F. J., Física Geral ¿ Problemas resolvidos ., São Paulo: Ed. McGraw-Hill do Brasil. Tipler, P. Física (vol. 1, 2 e 3) . Rio de Janeiro: Ed. Guanabara Koogan. Halliday, D. & Resnick, R. Física (vol. 1, 2, 3 e 4). Rio de Janeiro: Ed. Livros Técnicos e Científicos Editora Lda.  
  • Computing Engineering
  • 6155
  • 7336
  • Fundamentals of Physics
  • ISLA Gaia6155-7336
  • 1
  • 4
  • 0
  • 27
  • Não
  • Português
  • The approach of the subjects to be taught will be done in a simple way where the student will have the main role to transmit and express their gaps, regarding the mastery of the subjects, as well as their correct interpretation and use. The pedagogical approach of the contents is done in three duly accompanied phases: interpretation of statements, resolution of the exercises by the students, collective and individualized discussion of the issues that the problem raises and its resolution. Assessment Methodology: Continuous evaluation: 2 intermediate tests - 90% of the final grade, Attendance and participation - 10% of the final grade All students who have not successfully completed the assessment can take a final exam at the time defined by the institution.
  • Mandatory
  • Consolidate the basic notions of mathematics indispensable for the defined program. Introduce Physics as a basic science for the study of other sciences and its fundamental character for technological development. Associate the physical systems with a set of variables that, at each instant, assuming a certain value, can together constitute a model capable of describing the state of the system at that moment and predicting its evolution. Acquire habits of scientific rigor and critical sense, so that you see science not as a body of static knowledge, but as a system that regulates itself through comparison with reality (experimentation). Develop reasoning skills, essential throughout the course and necessary for professional life.  Encourage discussion and analysis of everyday problems where the acquired knowledge can be applied. Acquire fundamental knowledge of electrostatic and electricity, electromagnetism, Optics.
  • 1. Electrostatics and Electricity 1.1 Electric Charge and Electric Fiel. 1.2. Gauss's Law 1.3. Electric Potential. 1.4. Current, Resistance and Electromotive Force. 1.5. Direct Current Circuits. 2. Electromagnestism 2.1. Magnetic Field and Magnetic Force. 2.2. Electromagnetic Induction 2.3. Rationale for Current Generation Alternating. 3. Optics 3.1. Nature of Light Propagation. 3.2. Geometrical Optics 4. Basic notions of Quantum Physics.

  • 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 (*)

    A agendar durante o semestre

    45%(**)

    Teste de avaliação 2 (*)

    A agendar durante o semestre

    45%(**)

    Assiduidade e participação

    --

    10%

     

    (*) A realizar no decorrer do semestre.
    (**) Para avaliação da época normal (Curricular) , é necessário a existência de uma avaliação quantitativa em todos os elementos de avaliação para a obtenção de uma avaliação final. Sendo que para os testes intermedio terá uma nota mínima de 8 valores/cada, os alunos com nota inferior aos valores apresentados para os testes intermedios, terão de se submeter a avaliação final por exame.
  • Semestral
  • The course is intended to give students a broader and deeper basis in the field of physics, which will allow them to continue their studies in engineering.

Web Marketing

Category: Discipline
  • IT for eCommerce
  • 6616
  • 14881
  • Web Marketing
  • ISLA Gaia6616-14881
  • 2
  • 4
  • 0
  • 27
  • Não
  • Português
  • Semestral
  1. Hygiene at Work II
  2. Project - Part I
  3. Oral and Written Expression Techniques
  4. Technical English

Page 587 of 624

English Menu

Pesquisa

Login Form