This project contains a comprehensive hospital database that includes SQL scripts for creating tables, inserting dummy data, and executing complex queries. The project is designed to be easily replicated and tested in any SQL workbench.
#Project Contents
SQL Script File: A document with all the SQL scripts needed to create and populate the database.
Business Document: A PDF file that outlines the business value and context of the project.
ERD: Entity Relationship Diagram, with all the primary and foreign key dependencies
Dummy Data: Separate Excel files containing dummy data for all tables.
Independent Tables: Tables 1 - 7
Dependent Tables (Level 1) : Tables 8 - 11
Dependent Tables (Level 2) : Tables 12 - 16
#SQL Script:
The SQL script provided in the document can be copied as a whole and run in any SQL workbench. This script will create the entire hospital database along with all the necessary tables and dummy data. Word File:
The word file includes all the dummy data from the tables as INSERT INTO statements at the end of the document. Users can copy-paste the entire content of the word file into their workbench to run everything at once. This will set up the entire hospital database with tables and data. Complex Queries:
At the end of the word file, there are several complex queries and scripts that demonstrate the detailed functionalities and complexities of the hospital database. These queries can be run to test and explore various aspects of the database.