1) Come up with a mission statement for the project (1 point)

2) Show the ER-Diagram (data model diagram) for the database tables along with cardinalities of the relationships at both ends. You may hand draw this legibly, scan and upload with your assignment (4 points)

3) All the tables should be normalized containing no repeating data items and redundant non-key items (4 points)

4) Identify the primary column(s) and applicable foreign key column(s) for each of the tables. (3 points)

5) List down all the columns for each of the tables (3 points)

Design a relational database for a Course Registration System (CRS) for a college. This database maintains registration data for one semester only. Each course is instructed by a professor and a professor may teach one or more courses. A course and professor combination is known as "Class Session." The students register for a set of Class Sessions in the beginning of the semester. The database maintains following information for each student: 1) STUDENT ID (A unique identifier given to each student) 2) FIRST NAME 3) LAST NAME 4) MIDDLE INITIALS 5) SSN 6) Date of Birth 7) ADDRESS IN CAMPUS 8) HOME ADDRESS 9) COUNTRY OF CITIZENSHIP 10) E-MAIL ADDRESS The database maintains the following information about each professor: 1) EMPLOYEE ID (A unique identifier given to each employee of the college) 2) FIRST NAME 3) LAST NAME 4) MIDDLE INITIALS 5) HOME ADDRESS 6) E-MAIL ADDRESS 7) CONTACT PHONE NUMBER The database maintains the following information about each course: 1) COURSE ID (A unique identifier given to each course. Example: INF202) 2) COURSE NAME 3) COURSE OBJECTIVE 4) CREDIT HOURS In addition to above pieces of information, the database should maintain information related students' registrations to class sessions