Prescription is in 2NF. Is table Prescription in 3NF, given the dependencies? If yes, why? If not, normalize to 3NF. Prescription (PrescriptionNum, Date, Drug, Dosage, PhysicianID, PhysicianLastName,...

Prescription is in 2NF. Is table Prescription in 3NF, given the dependencies? If yes, why? If not, normalize to 3NF. Prescription (PrescriptionNum, Date, Drug, Dosage, PhysicianID, PhysicianLastName, PatientID) PrescriptionNum is the primary key. In addition, PhysicianID --> PhysicianLastName