LE04: 06/03/2020

Master in Informatics and Computing Engineering
Database and Web Applications Laboratory
Instance: 2019/2020
—

Lecture #4 :: 06/03/2020

By the end of this class, the student should be able to:

Conceptual (data) modelling (A4)
Structure modelling using UML
- Class diagrams
- Classes
- Attributes
- Aggregation relationship
- Composition relationship
- Generalization relationship
- Dependency relationship
- Class-association
Relational schema (A5)
- Relation schemas
- Attributes, domains
- Primary keys, foreign keys and other integrity rules
Mapping UML in relations (and objects in tuples)
- Relational Paradigm vs. Object-oriented Paradigm
- Object identification with primary keys
- Mapping rules
- Mapping associations and generalizations
Introduction to schema refinement
- Problems caused by redundancy
- Functional dependencies
Normal forms (recap)
- Boyce-Codd Normal Form (BCNF)
- Third Normal form
Decomposition of relations
- Lossless-join decomposition
- Dependency-preserving decomposition
Relational Schema refinement

Scott Ambler, The Object Primer, Cambridge University Press, 3rd Edition, 2004 (section 8.4, 8.5 and 12.3)
Alberto Rodrigues da Silva, Carlos Videira, UML — Metodologias e Ferramentas CASE, 2ª Edição, Centro Atlântico Editora, Maio 2005 (capítulos 6 e 10)
R. Ramakrishnan, J. Gehrke. Database Management Systems. McGRAW-Hill International Editions, 3rd Edition, 2003, ISBN=0-07-246563-8 (Chapter 19)

Illustrations presented in class: Conceptual Modeling, Mapping to Relational, Schema validation
J. Correia Lopes, Sérgio Nunes. Database Specification (EBD) (A4-A6), February 2020
Scott W. Ambler. Agile Modeling: UML 2 Class Diagrams, Ambysoft, last accessed in February 2020

Conceptual Data Model. Database specification. Relational Schema. Relational Schema validation.¹⁾

— LBAW, 2019/20

¹⁾

Modelo Conceptual de Dados. Especificação de Base de Dados. Esquema Relacional. Validação do Esquema Relacional