Using the screenshot provided below complete the assignment using Normalization Step for several of the entities

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.

Thank you! please be thorough

Fultime part time Hire Date where he/she belongs n Address mplayee is treated by Patient Patien t enal emai Age cade DOB s an Treatment Treatment code cos Empkyee ID dliant Id Descripton Test bed Dctor bed number Cast speciaty Test