I need to create an ER Diagram for the scenario described below.
You are commissioned to design a database to keep records of a small college. You talked with various key members of this community and obtained the following information:
The college keeps information about students and student performance. Every student is known by her/his first name, initials and last name. They are also identified by a unique StudentID provided by the University. Every student also belongs to one of five Schools (Arts & Sciences, Education, Management, Music and Engineering), and has a Major within that School (History, Chemistry, etc.). All programs of study require 4 years of study, and students are classified as freshmen, sophomore, junior, or senior, depending of the year that are currently attending. Each student is assigned and advisor from Faculty.