Hospital Database

Preview 6 of 17 pages

See the first 6 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Hospital Database PRESENTED BY: _____________________ DATED: _____________________ 1
Page 2
Page 3
Read page 3 as text
Presentation outline Introduction Purpose Project Description Package Diagram Entity Type 3NF / BCNF Form 3NF ERD Diagram Tables Constraints Reports References 2
Page 4
Read page 4 as text
Introduction The ERD which is provided belongs to multi - specialty hospital that incorporates various divisions, rooms, specialists, medical caretakers, compounders, and other staff working in the healing facility . Patients having distinctive sorts of infirmities go to the hospitals and get complete checkup from the concerned specialists . In the event that obliged they are conceded in the healing facility and released after treatment . 3
Page 5
Read page 5 as text
purpose The point of this contextual investigation is to plan and build up a database for the healing facility to keep up the records of different offices, rooms, and specialists in the healing center . It additionally keeps up records of the standard patients, patients conceded in the healing facility, the examination of patients done by the specialists, the room records dispensed to patients, and the representatives who are delegated in front office . 4
Page 6
Read page 6 as text
Project description When patients come they get a registration card for examination from the concerned specialist . After making section in the card, they go to the concerned specialist's room and the specialist looks up their infirmities . As indicated by the diseases, the specialist either recommends solution or concedes the understanding in the concerned division . The patient may pick either private or general room as indicated by his/her need . (To be continued…) 5

11 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.