Consider the following Table for the entity ENROLL : CLASS_CODE CLASS_NAME STU_NUM STU_NAME ATTENDANCE ENROLL_GRADE 10014 INFO3233-01 321452 Jan Jones 30/35 Classes C 10014 INFO3233-01 324257 Tom...


Consider the following Table for the entityENROLL:































































CLASS_CODE




CLASS_NAME




STU_NUM




STU_NAME




ATTENDANCE




ENROLL_GRADE



10014



INFO3233-01



321452



Jan Jones



 30/35 Classes



C



10014



INFO3233-01



324257



Tom Poole



 25/35 Classes



B



10018



INFO3234-01



321452



Jan Jones



 35/35 Classes



A



10018



INFO3234-01



324257



Tom Poole



 30/35 Classes



B



10021



INFO3236-01



321452



Jan Jones



 35/35 Classes



C



10021



INFO3236-01



324257



Tom Poole



 20/35 Classes



C




  1. Is [CLASS_CODE, CLASS_NAME, STU_NUM, STU_NAME] aSuperkey? Why?

  2. Is [CLASS_CODE, CLASS_NAME, STU_NUM] aSuperkey? Why?

  3. Is [CLASS_CODE, CLASS_NAME, STU_NUM] aCandidate Key? Why?

  4. Is [CLASS_CODE, STU_NUM] aCandidate Key? Why?


Please label your answers (for #1, 2, 3, or 4) clearly.



Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here