You are asked to develop a database system to keep track of student advising sessions at Lake View College. Each appointment is 30 minutes. A student can ask advising from any staff advisor. They advise any students who make advising requests. Appointments are given in the office of an advisor. Appointments can be made between 9 am and 5 pm. When making an appointment, students must indicate their advising issue (either course selection, grade, graduation, other) and provide questions. The staff advisors enter their note after each appointment. These staff advisors can block certain appointment slots when they cannot meet students. Hint: We can use tblAppointmentSchedule to keep track of blocked appointment time slots.

Based on the above case, draw a 3NF ER diagram. For each entity, attributes can be shown as short-hand text notation, attribute names inside the entity box, or bubbles connected to the entity (see the attached examples). The number of attributes can be a representative few unless the case is explicitly requiring.