Closed

Draw an Entity-Relationship (ER) diagram for a General Hospi - repost

TASK:

Draw an Entity-Relationship (ER) diagram for a General Hospital’s database using the following information.

1. The General Hospital consists of a number of specialized WARDS (such as Maternity, Pediatrics, Oncology, etc). Each ward has a name, code and hosts a number of patients.

2. On admission, the personal details of every PATIENT are recorded. These include ID, name, address, gender, birth date and illness. We also need to store the information of the tests undertaken by a patient and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required.

3. Each patient also has a ATTENDANT. This person is a family member or friend who looks after the patient and takes responsibility for them.

4. DOCTORS have their own IDs and a specialization in some branch of medicine and there are three types of doctors – consultants, specialists and interns. Each intern is supervised by a specialist doctor. One doctor can act as a consultant for a several patients. Their patients can be admitted in a number of wards.

Clearly show primary key attributes.

Skills: Database Administration

See more: specialist doctor, specialist consultant, family id, be a consultant, need a consultant, hospital consultants, ward, relationship, oncology, maternity, illness, ER diagram, entity relationship, draw, draw name, diagram, attendant, relationship database diagram, number draw, draw database hospital, diagram hospi, hospital database entity, entity relationship patient doctor diagram, draw diagram hospital database, diagram hospital patients admitted

About the Employer:
( 0 reviews ) Saudi Arabia

Project ID: #5056028

9 freelancers are bidding on average $500 for this job

elboukharimu

Hi, I'm very interested helping you creating ER diagram, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of More

$250 USD in 5 days
(10 Reviews)
4.3
oplalchandani

I am computer science graduate and have extensive experience in software design and development I can provide you the perfect ERD for the General Hospital’s database as per the given specifications Quality work in More

$750 USD in 3 days
(2 Reviews)
3.0
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE More

$555 USD in 3 days
(1 Review)
2.0
shehzadwork

I have the required skills and have done this kind of work on different types of systems. I can do this work. Consider me for your this project. I will be waiting for your response................

$250 USD in 2 days
(1 Review)
1.2
RoseOffice

Dear tota775, I am very pleased to provide you the ERD for general hospital. You will get the ERD in any format you like, also if you have a PowerDesigner then I can provide you the framework for your reference or f More

$250 USD in 7 days
(0 Reviews)
0.0
apbijwe

Hi, I am very good data analyst and 4+ years database experinced professional. Ready to work with proficiency and accuracy. Please have a look at my profile for industrial work experience. Guaranteed technical work w More

$722 USD in 3 days
(0 Reviews)
0.0
Singh160

I have 10+ years of experience working as Database Administrator/ Architect experiencing in Project Designing, Management& Implementation. Various solutions will be available with different requirements. so will choose More

$833 USD in 3 days
(0 Reviews)
0.0
ifmxconsultant

I am extremely thorough with collecting business requirements and ensuring data types and entity relationships are valid. I am thoroughly versed in the principles of relational database design and find ERD work to be More

$638 USD in 14 days
(0 Reviews)
0.0
dbacsharp

I have 4 years DBA experience in MS SQL Server and Oracle databases plus 2 years of developing databases and creating applications that use them. I am experienced with relational model, and I am capable of performing t More

$250 USD in 2 days
(0 Reviews)
0.0