Question

1. Please draw an ERD based on the following requirement statement. (10 Points) You are to design a database to keep track of student registration records. Any student can register up to 5 courses at any semester. Student does not have to register any course. Any course should have no less than 10 students. Any course should have exactly one professor as the instructor at any semester. But a course may be taught by a different professor at a different semester. Any professor should instruct exactly 3 courses in any semester. Your database system needs to record, at what semester and year, which student registers which course that is taught by which professor. In addition, for each student, you need to record student’s first name, last name, and the unique student id. For each course, you need to record a unique course id, course department, course number, and course title. For each professor, you need to record professor’s first name, last name, and his/her unique office phone number.

Name: 1 please draw an erd based on the following requirement statement 10 points you are to design a database to keep track of student registration records any student can register up to 5 course 05234
Uploaded: 2023-09-07T03:48:32-08:00
Duration: 2 min 27 s
Channel: Akash M
Description: 1 please draw an erd based on the following requirement statement 10 points you are to design a database to keep track of student registration records any student can register up to 5 course 05234

          1.     Please draw an ERD based on the following requirement statement. (10 Points)
You are to design a database to keep track of student registration records. Any student can register up to 5 courses at any semester. Student does not have to register any course. Any course should have no less than 10 students. Any course should have exactly one professor as the instructor at any semester. But a course may be taught by a different professor at a different semester. Any professor should instruct exactly 3 courses in any semester.
Your database system needs to record, at what semester and year, which student registers which course that is taught by which professor. In addition, for each student, you need to record student’s first name, last name, and the unique student id. For each course, you need to record a unique course id, course department, course number, and course title. For each professor, you need to record professor’s first name, last name, and his/her unique office phone number.

Added by Jean G.

Question

Please give Ace some feedback