تمرین خیلی مهم 1 برای پایگاه داده ها

تمرین شماره ۱(الزامی)

لطفا مطالب و نمودار ER زیر را ترجمه کرده

و بر روی کاغذ A4 به صورت دست نویس به همراه بیاورید

اگر نوشته های تصویر مشخص نیست تصویر را ذخیره کنید و سپس آن را مشاهده نمایید

ویا بر روی لینک کمکی تصویر کلیک کرده و آن را بزرگنمایی کنید 

---

 

Entity and Relationship sets for the hospital called
"General Hospital".

 

patients, hospemployees, doctors, nurses, pharmacists, rooms-beds, visits, bed-assignments, operates, orders-prescrip, fills-prescript , gives-prescrip, drug-orders.	موجوديت ها و ارتباط ها
patients, entity set with attributes MedRecNo, LastName, FirstName, sex, DateofBirth, age, SSNo.
hospemployees, entity set with attributes EmployeeNo, LastName, FirstName, DateofHire, TimeEmployeed, BirthDate, Sex, SSNo.
doctors, entity set with attributes EmployeeNo, DrID, Specialty, Title, DateResidencyCompleted.
nurses, entity set with attributes EmployeeNo, Title, StationAssigned.
pharmacists, entity set with attributes EmployeeNo, LicenseNo, PharNo.
rooms-beds, entity set with attributes RoomNumber, BedNumber, Status.
visits, relational set with attributes Date, Time, Diagnosis.
bed-assignments, relational set with attributes Date, Time.
operates, relational set with attributes DateScheduled, TimeScheduled, OpProcCodes, Room.
orders-prescrip, relational set with no attributes.
fills-prescrip, relational set with no attributes.
gives-prescrip, relational set with no attributes.
drug-orders, entity set with attributes OrderNo, MedRecNo, DrID, DrugID, PrescriptionNo, PharNo, DateTimeOrdered, DateTimeFilled, DateTimeGiven, QuantityOrdered, QuantityFilled,

 

 

 

لینک تصویر درصورت عدم مشاهده ـ نمودار (ارتباط/موجوديت) بيمارستان

(لینک کمکی تصویر)

General Hospital Tables

The following tables are required for the database for "General Hospital"

patients

MedRecNo	Lastname	FirstName	Sex	DateofBirth	Phone	SSNo

hospemployees

EmployeeNo	Lastname	FirstName	Sex	DateofHire	BirthDate	Phone	SSNo

doctors

EmployeeNo	DrID	Title	Specialty	DateResidencyCompleted

nurses

EmployeeNo	Title	StationAssigned

pharmacists

EmployeeNo	PharNo	LicenseNo	SSNo

rooms-beds

RoomNumber	BedNumber	Status

visits

MedRecNo	DrID	Date	Time	Diagnosis

bed-assignments

RoomNumber	BedNumber	MedRecNo	Date	Time

operates

DrID	MedRecNo	DateScheduled	TimeSchedules	Room	OpProcCodes

No table is required for orders-prescrip because data is in drug-orders table.

Fills-prescrip

MedRecNo	PharNo

drug-orders

OrderNo	DrID	MedRecNo	DrugID	DateTime Ordered	Quantity Ordered	DateTime Filled	Quantity Filled

Prescription No	DateTime Given

gives-prescrip

MedRecNo	EmployeeID