AutoChef

Creation of a Database from theorical definition to implementation, using the following steps:

1. Requirement Analysis
   • Analysis of all the requirements needed by the client and filtering of them.
   • Evaluation of functional and non functional requirements.
   • Specification of which tools are going to be used to implement the final application (PostgreSQL, Java, etc.).
   • Definition of Operating Systems on which the application will be developed.
2. ER model
   • Definition of all the entity needed in the database with their attributes.
   • Definition of relations, made by entities.
   • Entity-Relationship Schema
   • External constraints needed in future implementation of the database.
   • Functional requirements satisfaction check.
3. Relational model
   • Transformation of the Entity-Relationship Schema
   • Redundancy Analysis
   • Removal of multi-valued and composite attributes
   • Removal of IS-A Relations and Generalizations
   • Choice of principal identifiers
   • Specification of additional external constraints
   • Variation to the Data Dictionary
   • Analysis of Database Load
   • Relational Schema and its normalization
   • Data Dictionary
   • External constrains
4. Physical Design
   • Variations to the Relational Schema.
   • Physical Schema.
   • Population of Database and Trigger function.
   • Queries
   • JDBC implementation of the principal queries

Implementation

The implementation of the database is made in PostgreSQL and its code is reported here. You can find also the implementation of the application layer made in Java using JDBC here. You can also find the presentation of all the main phases of the project.

Authors

The project was developed by RaffaDNDM, CristiFab, DavidePistilli173, bordignonb, MatPerin.