JCL

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:lectures:03

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

teach:lbaw:lectures:03 [21/02/2020 14:41]
teach:lbaw:lectures:03 [26/02/2021 15:16] (current)
Correia Lopes created
Line 1: Line 1:
 +====== L: 01/03/2021 ======
 +
 +**Master in Informatics and Computing Engineering\\
 +Database and Web Applications Laboratory\\
 +Instance: 2020/21**
 +\\
 +---
 +\\
 +
 +====== Lecture #3 :: 01/03/2021 ======
 +
 +===== Goals =====
 +
 +By the end of this class, the student should be able to:
 +  * Obtain the Conceptual Model
 +  * Obtain the Relational Schema from the Conceptual Model
 +  * Validate the Relational Schema using the database normalization
 +
 +===== Content =====
 +
 +  - 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 
 +
 +===== Bibliography =====
 +
 +  * 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)
 +
 +===== Materials =====
 +
 +  * Illustrations presented in class: {{04-modeling.pdf|Conceptual Modeling, Mapping to Relational, Schema validation}}
 +  * J. Correia Lopes, Sérgio Nunes. [[..:artefacts:index#ii_database_specification_ebd_20|Database Specification (EBD) (A4-A6)]], February 2021
 +  * Scott W. Ambler. [[http://www.agilemodeling.com/artifacts/classDiagram.htm|Agile Modeling: UML 2 Class Diagrams]], Ambysoft, last accessed in February 2021
 +
 +===== Summary =====
 +
 +  * Conceptual Data Model. Database specification. Relational Schema. Relational Schema validation.
 +
 + --- //LBAW, 2020/21//
 +
 +[[02|« Previous]] | [[index|Index]] | [[04|Next »]]