need help with part 1 ?

Assignment 5: Database Design and Normal Forms Part 1 (20 points): Database Design You are asked to design a database schema for a university registrar's office to handle student and course registration information. The database keeps track of each student's name, WIN, current address and phone, permanent address and phone, birthdate, sex, level (freshman, sophomore, master, phd], major (a 4-char code), and home department. For address, some applications need to refer individually to the city, state (2-char abbrv.) and zip code (some use 5-digit, some use 9). Some applications need to refer to students' first and last names separately. WIN is unique to the student Each department has a name, a 4-char code, location (main building and room number), office phone, college, and a list of instructors. Department codes are unique within the university Each instructor has his/her WIN, first name and last name The course catalog contains the list of courses which WMU offers. Each course has a number (e.e 4430), name, description, credit hours & department. Course numbers are unique within a department, but not unique across the university (so taken together, they are unique) Each section has a single instructor (no team-taught class), semester, year (4-digit), course number and section number. The section number is unique within the university. A student enrolls in a course and gets a letter grade (A, BA, B, , E, X, Note: If the obove requirements leave out any importont detoil, assume that it is handled the way WMU does things in the real world. You are asked to: Draw an E-R diagram of the above information. . Convert the E-R diagram to a relational schema. Express the schema using SQL CREATE TABLE statements, with proper primary keys and foreign keys identified