The database keeps track of each student's name, SSN, current address & phone, permanent address & phone, birthdate, sex, class (freshman, sophomore, ......, master, phd), major department, college, major (a 4-char code). Some applications need to refer individually to the city, state (2-char abbrv.) and zip code (some use 5-digit, some use 9) of the students' address. Some applications need to refer to students' first and last names separately. SSN is unique to the student.
Each department has a name, a 3-char code, location (main building and room number), office phone, college, and a list of instructors. Department names are unique, even they are in the different colleges. Department codes are unique within the university.
Each instructor has his/her SSN, first name and last name.
The course catalog contains the list of courses which WMU offers. Each course has a number (e.g. 543), name, description, credit hours & department. Course numbers are unique within a department, but not unique across the university (so taken together, they are unique). Not every course is offered every semester.
Each section has a single instructor (first and last names - no team-taught class), semester (1-4), year (2-digit), course number and section number.
A grade report contains the student's name, SSN, course number & section, letter grade (A, BA, B, ..., E, X, I).
how do i write an ER diagram for this prob...i am not able to find a rln to the grade report...plz help me with this..