We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ 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.
Semester Fall 2016
Information System– CS507
Total Marks: 20
Due Date: 23rd Jan 2017
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.
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
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.
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.
.+ 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)