The first task is to design the ER diagram. You should draw or generate an ER diagram. Drawing is perfectly fine, but using a program to generate it is okay as well, if you happen to have access to such a program. Below are the rules of the schema: There are a set of Majors, each with an ID (numeric) and a name Students have first name, last name, a year in school, a major, and an student ID (numeric) Professors have first name, last name, and a faculty ID (numeric) Classes have a name and a class ID (numeric) A variety of classes are offered on a quarterly basis, each taught by one Professor and that class can have 1 or more Students in them Students receive a letter grade in every class Each Major has a list of required Classes for it