Take the following excel spreadsheet and analyze it$.$ It currently is not in $3$rd normal form and needs to be normalized into proper relations. Create an entity$-$relationship diagram $($ERD$)$ in $3$rd normal form using the crow's foot notation with either Visio or Lucid Charts. Show the relationships between the entities. Add the attributes to the entities from the spreadsheet and the associated primary keys. You can type PK next to the attribute that represents the primary key on each entity. You will need to add additional attributes as well as an additional entity to normalize the Entity$-$Relationship diagram. Feel free to review the normalization steps and problems in chapter $6.$ When complete your diagram should represent an ERD with several relationships. Do not be concerned with the data in the spreadsheet for this assignment, only the ERD. and the entity names The business rules are as follows:

A PROFESSOR can advise $(1$:M$)1$ to many STUDENTS

A DEPARTMENT can have $(1$:M$)1$ to many PROFESSORS

A DEPARTMENT can have $(1$:M$)1$ to many MAJORS

A MAJOR can have $(1$:M$)1-$to$-$many STUDENTS

Please provide entity relationship diagram