Question: Study the STUDRECORD spreadsheet below and answer the following questions. table [ [ STUDENT _ ID , COURSE ID , ENROLL DATE,COURSE NAME,DEPARTMENT _
Study the STUDRECORD spreadsheet below and answer the following questions.
tableSTUDENTIDCOURSE IDENROLL DATE,COURSE NAME,DEPARTMENTCODE,DEPARTMENTNAME,GRADE,COURSEFEECStableIntroduction toCSCSComputer Science,AMATHCalculus,MATH,Mathematics,BENGEnglish CENG,English,ABIBiology,BIO,Biology,BHISWorld History,HIS,History,C
Convert the spreadsheet to and write the relational schema. You can assume that the table does not contain repeating groups and that any STUDENTID may reference more than one COURSENAME.
Hint This table uses a composite primary key.
Show all primary key attributes using after the attribute name eg EmpNumPK
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
