Database HW

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