Foundation of Databases Course at UniPD - Department of Information Engineering - A.A. 2023/2024

General Overview of the Project

Acronym:

RHO

Description:

The scenario is the one of a Research Hospital in Oncology that needs to be able to manage the information about the anagraphic, the clinical data, the results from the scientific experiments and analysis, and the logistic aspects of the research pipeline in the hospital.

Members:

• Campoy Fernandez Pablo Julian: pablojulian.campoyfernandez@studenti.unipd.it
• De Faveri Francesco Luigi: francescoluigi.defaveri@phd.unipd.it
• Padoan Claudio: claudio.padoan@studenti.unipd.it
• Petrucci Riccardo: riccardo.petrucci@studenti.unipd.it
• Vezzosi Giacomo: giacomo.vezzosi@studenti.unipd.it

Project Structure

HW 1 - Requirements Analysis

Contents:

• Objectives
• Interviews
• Users & Stakeholders
• Natural Language Sentences
• Filtered Sentences
• Term Glossary
• Functional Requirements
• Non-functional Requirements
• Constraints

Contributions

• Campoy Fernandez Pablo Julian: Users & Stakeholders + Term Glossary.
• De Faveri Francesco Luigi: Objectives + Interviews.
• Padoan Claudio: Functional Requirements + Non-functional Requirements.
• Petrucci Riccardo: NL Sentences + Filtered Sentences.
• Vezzosi Giacomo: Term Glossary + Constraints.

HW 2 - Conceptual and Logical Design

Contents:

• Conceptual Design

  • Variations to the Requirement Analysis
  • Entity-Relationship Schema
  • Data Dictionary
    • Entities Table
    • Relationships Table
  • External Constraints
  • Functional Requirements Satisfaction Check

• Logical Design

  • Transformation of the Entity-Relationship Schema
    • Redundancy Analysis
    • Choice of Principal Identifiers
  • Analysis of Database Load
  • Relational Schema
  • Data Dictionary
  • External Constraints

Contributions

• Campoy Fernandez Pablo Julian: Data Dictionary (Conceptual Design) + Functional Requirements Satisfaction Check + External Constraints (Logical Design).
• De Faveri Francesco Luigi: Variations to the Requirement Analysis + Functional Requirements Satisfaction Check + Transformation of the Entity-Relationship Schema.
• Padoan Claudio: Analysis of Database Load + Relational Schema + Data Dictionary (Logical Design).
• Petrucci Riccardo: Entity-Relationship Schema (Conceptual Design) + External Constraints + Data Dictionary (Logical Design).
• Vezzosi Giacomo: Data Dictionary (Conceptual Design) + Analysis of Database Load + External Constraints (Logical Design).

HW 3 - Physical Design

Contents:

• Variations to the Relational Schema
• Physical Schema
• Populate the Database: Example
• Principal Queries
• JDBC Implementations of the Principal Queries and Visualization

Contributions

• Campoy Fernandez Pablo Julian: Variations to the Relational Schema + JDBC Implementations of the Principal Queries and Visualization.
• De Faveri Francesco Luigi: Physical Schema + JDBC Implementations of the Principal Queries and Visualization.
• Padoan Claudio: Populate the Database: Example + Principal Queries.
• Petrucci Riccardo: Variations to the Relational Schema + Physical Schema.
• Vezzosi Giacomo: Populate the Database: Example + Principal Queries.