Database Management Style

The Institute of concern Sciences [pic] A Project on Database Management system of Shalamar infirmary Lahore Prepared For Sir Abdul Ghaffar Khan Prepared by Jazib Ali (093171) M. Fazan Munir (093170) Raheel Khawar (092123) Contents Database Management brass misconduct! bookmarker not defined. IntroductionError! bookmark not defined. HistoryError! Bookmark not defined. Shalamar Hospital LahoreError! Bookmark not defined. HistoryError! Bookmark not defined. Existing governance3 File affect System (FPS)3 outline of DBMS and FPSError! Bookmark not defined. Entity relationship DevelopmentError! Bookmark not defined. Need Analysis of Shalamar Hospital3 Entities4 Identifier in EntitiesError! Bookmark not defined. saucer-eyed ERD7 Tables8 Relationship10 Queries14 FormsError! Bookmark not defined. ReportError! Bookmark not defined. Recommendation14 Existing System File Processing System (FPS) Hospital is currently using this system, which have side by side(p) disadvantages: 1. Program-Data Dependence. 2. Duplication of Data. 3. Limited data sharing. 4. Lengthy Development Times. 5. excessive Program Maintenance 6. Integrity Problem 7.

Inconsistence Data Need Analysis of cairne Hospital Cairne Hospital executive wants to salve the record of Hospital in following modal value: Patients are identified by an Serial No, and their names, addresses, and ages must be recorded. Doctors are identified by an Serial No. For all(prenominal) doctor, the name, specialty, and years of experience must be recorded. Each pharmaceutic company is identified by name and has a reverberate number. For each drug, the trade name and formula must be recorded. Each drug is sold by a devoted pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company is deleted, you need not keep track of its products any longer.... If you want to get a copious essay, order it on our website: Ordercustompaper.com

Ordercustompaper.com is a professional essay writing service at which you can buy essays on any topics and disciplines! All custom essays are written by professional writers!