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 ID$,$ name, current address and phone, permanent address and phone, birthdate, sex, program $($a $4-$char code$),$ and home department. For address, the database needs to record individually street, city, state $(2-$char abbreviation$)$ and zip code $($some use $5-$digit, some use $9).$ The database also needs to record students' first and last names separately. ID is unique to each 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 instructor's ID$,$ first name and last name.

Each course has a number $($e$.$g$.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$),$ department, course number and section number. The section number is unique within the university.

A student enrolls in a section of a course and gets a letter grade $($A$,$ BA$,$ B$,...,$ E$,$ X$,$ I$).$

Note: If the above requirements leave out any important detail, assume that it is handled the way WMU does things in the real world.

Submission:

$1)$Draw an E$-$R diagram of the above information, take a picture of the diagram and upload the picture as an attachment of your submission by clicking the "Add a File" button under the answer window.

$2)$Convert the E$-$R diagram to relational schema. Express the schema using SQL CREATE TABLE statements, with proper primary keys and foreign keys identified. Format your SQL statements nicely and paste to your answer window.