Develop an NER diagram, and then develop a table diagram (schema diagram) based on the NER.

QSU is a state university. Students can register for a program and graduate with a degree from that program. It is possible that a student has been registered for more than one program. For students we want to know their name, SSN, contact info, GPA and registration date. The contact info includes address, email, and telephone. The mailing address includes street, city, state, and ZIP.

There are several degree levels for each program including BS, MS, and Certificate degree. For each program we want to know the program code and description. For each degree level, we want to know the degree code and description.

It is good to note that when you register for a program you should specify what the target degree level is, but it is possible to change your mind later and graduate with a different degree. Example: somebody registers for PhD in electrical engineering, but later they decide to graduate with an MS in electrical engineering. The reverse could be true too.

In order to graduate with a degree in a program, students should pass a set of courses. Different courses are offered in different semesters. Some courses are prerequisite for other courses, so the courses should be taken accordingly. The data we want to know about courses are the course code, description, and credit hours. Each semester has a code which is the season it is offered (Fall, Spring, Summer) plus the current year (example: Fall2015). Courses are taught by an instructor. For instructors we want to know their name, contact info, SSN, direct deposit bank account information, hire date, and whether they are full time or part time. The contact info is like what we have for students. The bank account info includes name of the bank, routing number, account number, and name of the owner.

Different departments offer different programs. Departments are part of a school. There are several schools in QSU, including School of Computer Science and Software Engineering, School of Architecture and Construction Management, School of Engineering Technology and Management, and so on. For each department we want to know the department code and description. For each school we want to know the school code and description.