This is Database class by Oracle

Patient Patient Visit Doctor DoctorCheckin Checkout Tr Treatment OtyUnit Name Number Date ID Decription Price 100156 Andy y 82903 0927Name Date Lee 10/1/2016 10/1/2016 101 X-Ra 102 Aspirin 103 Shot 83513 0908 Blake 10/2/2016 10/5/2016 103Shot 204 Hypnosis 1 312 Water 10 100845 Betty 81553 0908 Blae 10/3/2016 10/4/2016 103 Shot 312 Water Smith 108/2016 108/2016 101 X-Ray 198 Aspirin 022 Tylenol 845130924 100 5 100 5 The General Hospital has many patients. Each patient has a Patient ID and a Patient Name. No two patients have the same patient ID, but patients may have the same name. Patient may visit the hospital many times. Each time he/she visits, there is Visit Number. For each visit, the patient is assigned a doctor, who has a Doctor ID and Doetor Name. The doctors were assigned on an availability basis, so a patient may be assigned to a different doctor each time. Each visit has a Checkin Date and Checkout Date. A patient may have multiple visits on the same day. In each visit, the patient may receive multiple treatments. Each treatement has a Treatment ID and Treatment Description. For instance, on Andy's 82903 visit, he received 1 unit of X-Ray, 80 units of Aspirin, and 3 shots. Each treatment always has the same unit price. For instance, X-Ray Test is always $200 per unit. Pationt PatientiDoctor Doctor Chckin CheckoutTrTreatment ty Unit ID Name Number Name Price 1. Identify a candidate key of this table. 2. Identify all functional dependencies in the format of S# SNAME