Mini project Databases

To carry out your mini$-$project, you need to follow the steps below:

$1.$ Carry out a complete analysis of the specifications for your mini$-$project.

$2.$ Derive the E$/$A model, justifying your choice of attributes, cardinalities and associations.

$3.$ Give the corresponding relational schema and apply the standardisation rules studied.

$4.$ Create the database, adding the constraints studied $($integrity constraints $+$ validation constraints$).$

$5.$ Populate the database while respecting the added constraints

$6.$ Query the database using the operators studied. This stage can be carried out by imagining scenarios, so be creative. The objectives are : $-$ Apply the concepts studied in class: E$/$A model, logical model, SQL $-$ Propose a satisfactory, elegant solution that respects the integrity of the data.

You should include a description of the general approach you have taken to analysing, specifying and implementing your solution, a description of the various stages in implementing the solution and a conclusion that summarises : $-$ The strengths and weaknesses of your solution $-$ The improvements you could$/$should$/$would like to make to your development.

The source code in SQL must contain the database modelling file, the file for creating your database and the corresponding tables, the file containing the validation constraints, the file containing the data insertion queries and the file containing all the database exploration queries. All files must be commented

Project theme: Create an application that offers subscribers a realistic diet and sports regime tailored to their needs. A daily menu of healthy recipes. Recipe composition based on the number of calories required. A variety of sports sessions depending on the desired objective.

This is the basic idea. You are free to add other entities and specific features to enhance your project, and you must add integrity constraints $($An integrity constraint is a clause used to restrict table modifications, made via user requests, so that the data entered in the database conforms to the expected data$)$ and validation constraints for attributes $($You can create a validation constraint in a table to specify the data values allowed in one or more columns$)$