Question: o Design a Relational Data Model for the following ER model of a university: declare date deptNo location stulD StuName 2 Student Majors Department teaches

 o Design a Relational Data Model for the following ER model

of a university: declare date deptNo location stulD StuName 2 Student Majors

o Design a Relational Data Model for the following ER model of a university: declare date deptNo location stulD StuName 2 Student Majors Department teaches LetterGrade NumberGrade rade epo Grade Course CourseID CourseName Comments on the ER-diagram: - The Student entity represent the students in the university - The Department entity represent the departments in the university - The Course entity represent the courses -The Grade entity represent the different grades that you can receive (A, B, C, D, F) . The key in each entity is underlined with a solid line The Majors relationship represents the "who-majors-in-what" relationship - Important note: The declareDate is the date on that a student declares (one of) his/her major A student can have (at most) 2 majors (just like Emory) When designing this relationship in the Relational Model, make sure that your answer complies with the stated requirements in Question 1 above - The teaches relationship represents the course offerings The GradeReport relationship represents the "who-got-what-grade-in-which-course" relationship Your relational model answer must satisfy the following requirements: Use the smallest possible number of relations Attributes in relations must not have NULL values. . Exception: If avoiding NULL values will require creating a new relation, the attribute is allowed to have NULLs Underline the primary key of each relation For every foreign key in the relational model: Draw an arrow from the foreign key to the relation that the foreign key is "pointing to" (i.e., it's "home relation")

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!