Using the un-normalized data below, normalize the data, then design the tables based on this normalization. List the name of the table, the field names, and the relationships between the tables. Utilize PK for primary key, and FK for foreign keys

Example:

Table: Employee

SSN (PK)

Employee_Name

Employee_DOB

Employee_Dept (FK)

Table: Department

Department_Number (PK)

Department_Name

Relationship between employee and department is one to one

aia O INOrTiaiize: Animal Anima Animal Name Piccolo Cat Animal Owner Owner GenderName Male Owner Doctor Docto AddressPhone Name Address 123 Main 555 e Type Breed 2233 Somewhere Drive 2233 Somewhere Drive 345 Main St Siamese Neale ones 1234 Widget Cat Male Neale 123 Main 555- 1234 Siamese ones Alex Dog Bloodhound Male Smith 2233 555- Mays Anywhere 7789 FiFi Dog Poodle FemaleSmith 2233 Mays 345 Main St Anywhere 7789 555- Hays Ave 6789 DoodleChicken Amber Female Jackson 3344 Jones 2233 Somewhere Drive White