Question

Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has only one major. One student can take multiple courses in one SemesterYear. One course can be taken by many students in each SemesterYear. Given values for StudentID, Course Number, and SemesterYear, one can determine all the rest of values for a record. However only Grade is functionally dependent on StudentlD, CourseNumber and Semester Year. StudentGrade HIM561-01 Intro to DB Design S1 Don MO1 Spring 2019 Eric Greer S2 MO1 HIM HIM361-01 Intro to DB Design IS200-01 Spring2019 Foundations of Information Spring2019 Mary | Nicholas | M02 Sharon Snead avier Adams M01 S4 M02 IS IS205-01 IT Infrastructure and SupportFall2019 C+ S5 IS CIS101-01 Computer Fundamentals and Fal12019 Applications B+ 4. According to three entities of Student, Major, and Course, sketch an Entity-Relationship model or information-level design with attributes. Show all the entities, relationships (non-identifying and identifying), attributes, primary keys, and foreign keys. (Create a new entity (table) if necessary for a many-to-many relationship ) (25 pts)

Answer 1

FName MajorNo MajorName LName Has Major Student Take courses course taken Course Grade CourseNumber SemesterValue CourseName