Question: ) 6 points: Given the following two tables, StudentCourses & Course, respectively: StudentID CourseID Grade 1 1 A 2 1 A 1 3 B CourseID

)6 points: Given the following two tables, StudentCourses & Course, respectively:
StudentID CourseID Grade
11 A
21 A
13 B
CourseID CourseName
1 MIST
2 QANT
3 FINC
(a) The primary key in StudentCourses table is composite primary key (StudentID, CourseID), identify the primary key in the Course table (1 point):
(b) Identify the foreign key (1 point):
(c) Create outline notations for each table (2 points):
(d) Create entity-relationship diagram (2 points):

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!