Consider a STUDENT and ADVISOR database. Students have a student number and student name. Advisors have names, of ce numbers, and advise in some major. Te major the advisor advises in is designated by a major code (e.g., Chemistry, CHEM; Biology, BIOL; Computer Science, COMPSC; . . .). Draw the ER diagram using the Chen-like model. Follow the methodology and include all English descriptions of your diagram. Map the ER diagram to a relational database and include some sample data.