For the DBMS assignment, draw the ER Diagram for the given case studies using a case tool such as VISIO, ERWING, or MSWORD.
Case Study 1: You have been tasked with designing the database for General Hospital. Their requirements are as follows: The record of doctors is maintained along with their designation, such as Professor, Associate Professor, Assistant Professor, Medical Officer, etc. Each patient is assigned a patient number and their complete record is stored. Each visit by a patient is recorded using the assigned patient number. A list is maintained to track the doctors treating a patient during each visit. The doctors receive a fixed monthly salary in addition to fees for treating private outdoor patients and fees for conducting operations.
The fees for each type of operation are predefined, while the fees for outdoor patients of each docto
...r vary. A bill is created and stored for each patient visit. The management is interested in the following reports, which are required on a daily basis:
e.g., between from-date and to-date) List of all the patients treated by a particular doctor; List of operations performed by a doctor; List of all the outdoor patients checked by a doctor; List of all the doctors a patient is under treatment by; Complete record of each patient's history; Record of any patient for a particular visit. Entities: Doctor, Patient, PatientVisit, Operation, OperationType, OutdoorPatient, Bill.
Case Study 2: Golden company wants to computerize its sales system. Golden Co. has its network spread across the country, which is distributed in zones.
Each zone includes one or more cities and every city has one or more distributors. Golden company offers a variety of products, som
of which have multiple packing sizes.
The sales process involves a delivery order being created for each approved order. Depending on material availability, one delivery order may be fulfilled by multiple supplies. An invoice is generated for each supply, which must be made from the corresponding delivery order.
Thus, it is necessary to preserve the record of pending items in the delivery order. Golden company collaborates with several transporters to send their goods to distributors, and maintains a record for each transporter. The name of the transporter is also included in the invoice.
Golden company collects payments from distributors and needs to keep records of each distributor. The company is interested in the following reports:
- Delivery orders between specific dates, organized by zones.
- Delivery orders for any zone within a certain period, organized by distributors.
- Delivery orders for any distributor within a certain time frame.
- Sales between specific dates, categorized by zones.
- Sales for any zone, organized by distributors.
- Sales for any distributor within a specific period.
- Sales between specific dates, categorized by products.
- Sales for any product within a certain packing.
Entities: Zone, City, Distributor, Product Range, Product, Delivery Order, Pending Delivery Order, Invoice, Transporter.
- Bankruptcy essays
- Earnings essays
- Tata Group essays
- S corporation essays
- Secretary essays
- Premise essays
- Cloning essays
- Medical Ethics essays
- Patient essays
- Therapy essays
- drugs essays
- Cannabis essays
- Aspirin essays
- Cardiology essays
- Hemoglobin essays
- Pharmacology essays
- Surgery essays
- alternative medicine essays
- Plastic Surgery essays
- Organ Donation essays
- Vaccines essays
- Medical essays
- Dentist essays
- Psychological Trauma essays
- Physical therapy essays
- Cold essays
- Cocaine essays
- Why Marijuana Should Be Legalized essays
- Drug Abuse essays
- Teenage Drug Abuse essays
- Heart Disease essays
- Artery essays
- Adidas essays
- Amazon essays
- Apple essays
- Bmw essays
- British Airways essays
- Burger King essays
- Coca-Cola essays
- Company essays
- Costco essays
- Dell essays
- Ebay essays
- Enron essays
- Facebook essays
- Ford Motor Company essays
- Gap essays
- General Motors essays
- Google essays
- Honda essays
