We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Assignment No.3
Graded
Semester Fall 2016
Information System– CS507
Total Marks: 20

Due Date: 23rd Jan 2017

Instructions:
Please read the following instructions carefully before solving & submitting assignment:

1. The assignment will not be accepted after due date.
2. Zero marks will be awarded to the assignment that does not open or the file is corrupt.
3. The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
4. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
5. Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at CS507@vu.edu.pk
Do not post queries related to assignment on MDB.

GOOD LUCK

Scenario

A Hospital has large number of registered Physicians; attributes of physicians include the physician_id that is identifier and specialty, the patients are admitted to the hospital on the recommendation made by the doctor. The attributes related to a patient are the patient_id and name. Any patient who has been admitted to the hospital must have one physician who has recommended his admission while a physician can admit any number of the patients.
A patient after admission must be treated by at least one physician while a physician can treat any number of patients or may not treat any patient. Whenever a patient is treated by physician the hospital wishes to record the details of the treatment (treatment details) which include the date, time and results

Question No.1

For the scenario given above you have to draw the ER diagram with properly showing the relationship cardinalities using the format and shapes given in the handouts.

Question No.2

A Patient taken after a call is received to the emergency ambulance department of the hospital to the above hospital and is admitted there of treatment and is treated by more than one physicians with different medicines recommended and also the medical tests for diagnostic purposes has been done while he is also allocated a room from hos admission to till his discharge draw a data flow diagram related to all the process.

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 5065

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Mr. Mayo

Attachments:

thnx bro :) :) :) :)

CS507 

Attachments:

RSS

© 2020   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.