Skip to content

alexasummers/cs470

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

129 Commits
DDL
DDL
 
 
hospital
hospital
 
 
Client_staff_junction_table.sql
Client_staff_junction_table.sql
 
 
Database Project Presentation (Purva).mp4
Database Project Presentation (Purva).mp4
 
 
Database Project Presentation.pptx
Database Project Presentation.pptx
 
 
Doctor to patient relations query.sql
Doctor to patient relations query.sql
 
 
Final ER.png
Final ER.png
 
 
Get staff client info- stored proc.sql
Get staff client info- stored proc.sql
 
 
Get staff information- stored proc.sql
Get staff information- stored proc.sql
 
 
Get_Drugid- Stored proc.sql
Get_Drugid- Stored proc.sql
 
 
Get_credentials- Stored Procedure.sql
Get_credentials- Stored Procedure.sql
 
 
Patients & meds RA tree.png
Patients & meds RA tree.png
 
 
README.md
README.md
 
 
aggregate medicine count.sql
aggregate medicine count.sql
 
 
aggregate patient by zip query.sql
aggregate patient by zip query.sql
 
 
citystatezip_table.sql
citystatezip_table.sql
 
 
client_drug_junction_table.sql
client_drug_junction_table.sql
 
 
client_table.sql
client_table.sql
 
 
database_backup_final (2).sql
database_backup_final (2).sql
 
 
department_table.sql
department_table.sql
 
 
er_diagram_creately.png
er_diagram_creately.png
 
 
hospital.zip
hospital.zip
 
 
logins.sql
logins.sql
 
 
medicine_staff_junction_table.sql
medicine_staff_junction_table.sql
 
 
medicine_table.sql
medicine_table.sql
 
 
mySQL demos.sql
mySQL demos.sql
 
 
patient meds stored procedure.sql
patient meds stored procedure.sql
 
 
patientinformation_table.sql
patientinformation_table.sql
 
 
schema_update_3.12.2020.png
schema_update_3.12.2020.png
 
 
staff_table.sql
staff_table.sql
 
 
stored procedure doc patinet relation.sql
stored procedure doc patinet relation.sql
 
 
stored procedure meds.sql
stored procedure meds.sql
 
 
stored procedure patient meds.sql
stored procedure patient meds.sql
 
 
stored procedure zip.sql
stored procedure zip.sql
 
 
updated_sitemap_2.12.2020.PNG
updated_sitemap_2.12.2020.PNG
 
 
views.sql
views.sql
 
 

Repository files navigation

cs470

MySQL database containing fake hospital records with patient, department, symptom, and medication information.

About

Hospital Database using MySQL

Resources

Readme
Activity

Stars

1 star

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages