Member Avatar for FireBlah

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 :)

  • 4 Contributors
  • 4 Replies
  • 352 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by FireBlah
Member Avatar for DarkMonarch

hmm...

you sure your doing this for an hospital ?
usually health sector are very pointy.

lets say they're upgrading from paper to digital.
didn't they have patient records on paper, you can base your DB structure on it ?

i'm certain they would have insurance references in there somewhere, patient number or card number, dates of prescriptions and visits ...

Member Avatar for <M/>

You should ask the hospital about the entities... plus, doctor should go before nurses...
Here is a bunny...
(\/)
( ' ' )
c('')('')

Member Avatar for drjohn

Sounds like your homework to me ;)

Who ever heard of a hospital hiring a beginner to create a database, when they almost certainly use one of the existing medical / patient databases that are available commerically.

Member Avatar for FireBlah

@drjohn Yes, it is a school project and the project is to create a hospital DB. I've never said some hospital hired me to create a DB for them.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.