Blog

A university registrar’s office is designing a database with…

A university registrar’s office is designing a database with the following characteristics: It is necessary to store information about courses and their corresponding unique course number, title, credits, and syllabus. Note that the prerequisite courses for any specific course (main course) is also needed to be known. Since not all existing courses may be offered to students to take, the database must store information about all courses offered and available, together with their year, semester, section number, room, and time. A specific course can be offered many times, or not at all. Logically, an offered course must match a single existing course.  The database must also store information about instructors, their unique IDs, names, departments, and titles. An instructor must teach at least one course, but no more than 7. Also, a course offered must be assigned to the taught by at least 1 instructor. Information about students must also be stored, including unique student ID, name, and academic program. In addition, the numeric grade obtained by students enrolled in a course must be stored. The database system must also be able to convert the numeric grade into its corresponding grade letter. A student can be enrolled in many courses, or in none. Below is an incomplete version of a possible ERD for the presented mini world. Each incomplete element will be marked and denoted in the diagram with a red letter within parenthesis. Question: In the ERD above, “REQUIRES” is a: