Hello!
In this university project, I was given a mock client, who was running a fitness business, and wanted to store that businesses data, in an electronic database. After considering the nature of the data, and how it would be interacted with on a daily basis, I determined a relational database would be most appropriate, and then began building said database:
So, first I created a conceptual model of the fitness businesses relational database, here:
Then, the client gave me some additional information. They use 2 different paper forms as part of their business, a class staffing report form, and a class attendance report form. They wanted the data from those forms, to be put into the database as well.
Thus, I took the forms, and applied the normalization process to them, to help cut down on redundancy and inconsistencies that would very likely arise eventually otherwise. The process applied to both forms, is visible here:
https://github.com/peterw-github/FitnessSQL/blob/main/Logical%20Model/Normalisation%20Process.pdf
The normalised forms and conceptual model were then combined, and a logical model was built (what the relational database will look like):
Finally, the SQL code to build the physical model (a more detailed version of the logical model, and what the database will actually be) is here:
https://github.com/peterw-github/FitnessSQL/blob/main/Logical%20Model/logicalmodel_schema.sql
With the businesses relational database now fully built in Oracle SQL Developer, I began practicing SQL, on two other mock relational databases in Oracle.
The first was medical facilities database, and I wrote queries for it, visible here:
https://github.com/peterw-github/FitnessSQL/blob/main/Additional%20SQL%20Code/Mock%20Medical%20Facility/medfacility_queries.sql
The second was a library networks database, and I wrote inserts, deletes, and general alterations, visible here:
https://github.com/peterw-github/FitnessSQL/tree/main/Additional%20SQL%20Code/Mock%20Library%20Network