Skip to main content

ISLA Santarém 15497

Database I

Computer Networks and Systems
  • ApresentaçãoPresentation
    .
  • ProgramaProgramme
    1. The need for databases  2. Databases  - Data model concepts  - Database architecture  - Files and databases  3. Database management systems  4. Models used in database management (relational, hierarchical, network)  5. Relational model of databases  - Relational model structure  - Database integrity and consistency  6. The ER (entity-relationship) model for graphical representation of databases  - Entities  - Attributes  - Relationships  - Candidate keys. Primary keys. External keys  7. Normalization  - Representation in non-normalized form  - Type of notation  - Codd normalization phases: 1st, 2nd and 3rd form of normalization  - "Denormalize" to achieve better performance - Information integrity  8. Relational databases  - Table concept (rows representing records and columns representing fields)  - Index concept. Simple and compound indexing keys.
  • ObjectivosObjectives
    The objectives of the course are:  Recognize the need for/functionality of databases.  Acquire vocabulary related to databases.  To know concepts relating to database structures.  Know database management systems.  Identify the models used in database management (relational, hierarchical, network).  Know data modeling techniques and their basic concepts.  Apply data modeling techniques to solve specific problems at DB level.
  • BibliografiaBibliography
    Hoffer, Jeffrey A. et. al (2013). Modern Systems Analysis & Design, 2nd Edition, Addison-Wesley Longman. Lopes, Filomena, Morais, Paula e Carvalho, Armando (2009). Desenvolvimento de Sistemas de Informação, FCA – Editora de Informática. Pereira, J.L. (2001). Tecnologia de Bases de Dados, FCA - Editora de Informática. Carriço, José António e Carriço, António  João (2004). Desenho de Bases de Dados e Linguagem SQL, Edições Chambel, Lda,
  • MetodologiaMethodology
    Classes are taught using (1) active methodologies, mainly project-based learning for project development and (2) problem-based learning to enable students to autonomously seek solutions to problems they encounter.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    5
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não