I'm working on a database project. I avve to build a DB for medical record (hospital) but I'm not too familiar with hospital stuff. I have to come up with entity sets with their attributes, build an ER diagram and then do a Query with GUI included. What I need from you guys is ideas about entity sets for medical records. I don't need anybody to build the ER or anything. I just need ideas of Entity sets. Specify if it's weak entity. I don't need attributes or relationships either. I can come up with those myself.
Righ now, the only entities I can think of are: Patient - Nurse - Doctor - Drugs - Symptoms - Hospital ... with their attibutes. So, need help asap. It's due in 2 weeks :)