Data Bases
| Áreas Científicas |
| Classificação |
Área Científica |
| OFICIAL |
Informática |
Ocorrência: 2023/2024 - 2S
Ciclos de Estudo/Cursos
| Sigla |
Nº de Estudantes |
Plano de Estudos |
Anos Curriculares |
Créditos UCN |
Créditos ECTS |
Horas de Contacto |
Horas Totais |
| BINF |
37 |
Study Plan |
1 |
- |
5 |
67,5 |
135 |
Docência - Responsabilidades
Língua de trabalho
Portuguese
Obs.: Português
Objetivos
The student should be able to design, conceive and implement
databases using the relational database model.
Concepts, various models and existing database systems are
presented. It is intended that the student acquire the ability
to describe the architecture of a Database Management System
and use a database construction tool with this approach.
In this context, it should understand the transactional
operation, the mechanisms of competition, security and
fault tolerance and authorization/authentication in a DBMS.
It is also objective for the student to acquire skills in
analyzing and extracting information from the database.
Data definition and data manipulation languages will be
presented.
For the practical component, among the available tools,
a reference client/server architecture database on the
market will be used.
Resultados de aprendizagem e competências
It is intended to obtain the following learning outcomes
and skills:
Design and build a database using relational modeling;
Master the different components of a DBMS;
Develop scripts in SQL (structured Query Language);
Modo de trabalho
À distância
Programa
Database concepts: data, information and knowledge;
Modeling and development of Databases.
Models:
1st generation: hierarchical model and network model;
2nd generation: the relational model;
3rd generation: object-oriented models and extensions to the relational model (data warehouses, etc.).
Relational model: Concepts, Codd rules, entity-relation model,
integrity rules, database normalization: the normal forms.
Data definition and manipulation languages.
Relational algebra and SQL query language.
The Database Management System (DBMS) – the ANSI/SPARC
architecture, features and requirements.
Transactions in Databases
- ACID properties
- competition control
- Recovery mechanisms and fault tolerance
Practical development of a database using the
Microsoft SQL Server database engine.
Exercises on database queries.
Bibliografia Obrigatória
Connolly, Thomas • Begg, Carolyn; Database Systems: A practical approach to design, Implementation and Management, 6th edition, Addison Wesley, 2014
Bibliografia Complementar
Carvalho, Vidal • Azevedo, Ana • Abreu, António ; Bases de Dados com Microsoft Access 2007, Desenho e Implementação, CentroAtlantico.pt, 2008
Elmasri, Ramez • Navathe, Shamkant B.; Fundamentals of Database Systems, 6th edition, Addison-Wesley, 2010
Métodos de ensino e atividades de aprendizagem
Theoretical-practical classes will be given, using the
expository technique, through the presentation of slides
(powerpoint) or animations (prezi). It seeks to stimulate
students' interest, reasoning and critical thinking.
The computer will be used to carry out the practical exercises.
The student will put into practice the theoretical knowledge
acquired through the construction of a project of relational
databases, framed with practical exercises. To test the
databases created in these exercises, a database engine with a
client/server architecture will be used.
In addition to building the data model, the development of this
project should also give a perception from the user's point of
view, involving the construction of a query interface to the
database.
For this purpose, the student should use a database access tool
that allows the construction of a form interface.
Software
SQL Server Developer Edition (gratuito)
SQL Server Management Studio (gratuito)
Tipo de avaliação
Distributed evaluation with final exam
Componentes de Avaliação
| Designation |
Peso (%) |
| Teste |
20,00 |
| Trabalho escrito |
40,00 |
| Trabalho laboratorial |
40,00 |
| Total: |
100,00 |
Componentes de Ocupação
| Designation |
Tempo (Horas) |
| Elaboração de projeto |
10,00 |
| Frequência das aulas |
60,00 |
| Trabalho laboratorial |
10,00 |
| Estudo autónomo |
45,00 |
| Trabalho escrito |
10,00 |
| Total: |
135,00 |
Obtenção de frequência
Mandatory attendance as a condition of access to continuous assessment.
Fórmula de cálculo da classificação final
Continuous assessment:
NF = 10% Lab 1 + 10% Lab 2 + 40% Final Project + 40% written test
Exam assessment:
NF = 50% Final project+ 50% Exam
Minimum marks:
Final project >=8.0
Written test >=8.0
Exam >=8.0
NF >= 9.5