This project is to create a database for hospitals to query the stored information.
The database is created by PostgreSQL and Neo4j, and stores tables like doctors, patients, illnesses, and treatments.
The database has at least 10000 unique patients, 100 unique doctors, 1000 unique illnesses, and 750 unique treatments. Every patient should be seeing 1-5 doctors and should have between 0-3 different illnesses. Any patient that has an illness should be receiving at least one treatment.
The database runs smoothly and quickly.
The code is attached under page "Github Codes".
This project is to use both PostgreSQL and Mongoose in MongoDB to construct a database for pizza store to track orders.
The database has the following tables, users, inventory, recipes. Additionally, there is a function to insert new order automatically. • The function will take in a user and recipe as parameters, it needs to validate that there are ingredients sufficient to make the pizza, then update the ingredients to decrement the count of each ingredient by what is required for the recipe(If there aren't enough ingredients, raise an exception!). Finally, an entry will be written to the orders table to track the order, generating a new timestamp in the process.
The whole database has at least 1000 unique users, 25 different recipes, and at least 50,000 orders.
The database runs well and takes less time to process.
The code is attached under page "Github Codes".