6.c.    A University has a large number of courses in its catalog. Attributes of COURSE include Course_ID (Identifier), Name, and Credits.  Each course may have one or more different courses as a prerequisite, or may have no prerequisites. Similarly, a particular course may be a prerequisite for any number of courses, or may not be a prerequisite for any other course.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


NOTE: Course_ID AND PreReq_ID (in Associative Entity Prerequisite) Are BOTH Primary keys AND Foreign Keys (referencing attribute Course_ID in Table COURSE)