Management Homework Help

Take the following excel spreadsheet and analyze it.  It currently is not in 3rd normal form and needs to be normalized into proper relations.    Create an entity-relationship diagram (ERD) in 3rd normal form using 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 may need to add additional attributes 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.  The business rules are as follows: 

A PROFESSOR can advise 1 to many STUDENTS

A DEPARTMENT can have 1 to many PROFESSORS

A DEPARTMENT can have 1 to many MAJORS

A MAJOR can have 1 to many STUDENTS