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.
\table[[STUDENT_ID,COURSE ID,ENROLL DATE,COURSE NAME,DEPARTMENT_CODE,DEPARTMENT_NAME,GRADE,COURSE_FEE],[001,CS101,2023-09-01,\table[[Introduction to],[CS]],CS,Computer Science,A,500],[002,MATH201,2023-09-03,Calculus,MATH,Mathematics,B+,600],[003,ENG101,2023-09-05,English C,ENG,English,A-,450],[004,BI0101,2023-09-10,Biology,BIO,Biology,B,550],[005,HIS101,2023-09-15,World History,HIS,History,C+,400]]
Convert the spreadsheet to 1NF and write the relational schema. You can assume that the table does not contain repeating groups and that any STUDENT_ID may reference more than one COURSE_NAME.
(Hint. This table uses a composite primary key.)
(Show all primary key attributes using {PK} after the attribute name eg EmpNum{PK})
Study the STUDRECORD spreadsheet below and answer

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 Programming Questions!