Answered You can hire a professional tutor to get the answer.

QUESTION

Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken, and the grades...

Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken, and the grades students have gotten in these courses. Courses have a number, a department, and a title, for example, "CS101: Introduction to computing" has department = CS, number = 101, and title = "Introduction to Computing." Numbers are assigned by departments, and different departments may use the same number. Students are represented by their (unique) student ID and their name. "Enrollments" each consist of a course, a student who took that course, and the grade the student got in the course.  a. (13 points) Draw an E/R diagram that represents this database structure correctly. b.  (7 points) Convert the E/R diagram of part a into a relational schema.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question