**do lab 3 only**

lab2

lab 3:

Elijay Community Hospital LAB 2 For this lab, please read the description of the Elijay Community Hospital and then complete the E/R diagram for the following entities PATIENT: PatientID, Name, DOB, age. gender, adress email. phone BED: BedNumber, PatientID EMPLOYEE: EmployeelD, Name, phone, email, phone, address, HireDate DEPARTMENT: DepartmentCode, DepartmentName TREATMENT: TreatmentCode, TreatmentDescription, TreatmentCost TEST: TestCode, TestDescription, TestCost Add new attributes to several of your tables if there is a need. Elijay Community Hospital You have been asked to develop a database system for the Elijah Community Hospital. ECH is a small, local community hospital with approximately 125 beds. The basic goal is to provide high- quality, cost-effective health-care services for the surrounding community in North Georgia The various business functions that the hospital currently has are .Patient care administration software-record keeping aspects of patient care Clinic and lab services software-provides lab testing and procedures and patient monitoring & screening Patient care software-provide patients with medical care and support services Financial management software-manage the financial resources and operations of the hospital Administrative services software- directly related to patient care provide general management and support services not The patient care and clinic and lab services include: laboratory tests, radiology procedures, admissions, in-patient and out-patient surgeries, labor and delivery services, intensive care cardiology, open-heart surgery, neurology department, pediatric medical and surgical care, orthopedics, oncology and a 24-hour emergency department. The staff on the hospital includes 600 full-time and 200 part-time personnel including doctors, registered nurses, laboratory technicians, counselors, rehabilitation therapists, social services staff, admittance/discharge staff, insurance staff, janitorial staff, and security staff Instructions For this lab we will be completing the Normalization step for several of your entities from your Lab 2 E/R diagram. After considering my feedback on your Lab 2 E/R diagram, you will normalize the following entities to 3rd normal form - show ALL steps - 1st normal form, 2nd normal form and 3rd normal form for each of the following entities: PATIENT BED EMPLOYEE DEPARTMENT TREATMENT TEST After going through your steps of normalization - add in your Foreign keys based on your cardinalities from your E/R diagram. You will add new attributes to several of your tables