PLEASE DO 1 AND 2 FOR THUMBS UP!!

Write the one liner showing the relationship for each of the following scenarios. You must then draw an ER diagram using any of the tools that we have provided showing all diagramming conventions clearly depicting the type of respective relationship. Your answers must also clearly indicate the total number of tables and should not be left to be inferred by the instructor by looking at your diagram. Primary and Foreign keys of the tables should be clearly specified. You need NOT write the actual SQL statements to create the tables.

1. At the hypothetical NKU Business Informatics Department, every undergraduate major is assigned an advisor. There are many advisors but an advisor can advise a maximum of 35 students. Each student has only one advisor who helps students with scheduling classes, filing for graduation, and answering career-related questions. All students must have an advisor and all advisors must have students assigned to them.

2. Students schedule visit with their advisors. An advising session can last a maximum of 30 minutes. It is not necessary that students must schedule visits with their advisors. An advising session is needed only for students who need some help. A student can schedule multiple advising sessions if they need help with different things. An advisor in that case will have multiple sessions with the same student. Typically, all advisors have sessions with more than one student.