Q:

A college course may have one or more scheduled sections, or may not have a scheduled section.  Attributes of COURSE include Course_ID, Course_Name, and Units.  Attibutes of SECTION include Section_Number and Semester_ID.  Semester_ID is composed of two parts:  Semester and Year.  Section_Number is as interger(such as "1" or "2") that distinguishes one section from another for the same coursebut does not uniquely identify a section.  How did you model SECTION?  Why did you choose this way versus alternative ways to model SECTION?

 

Attachments:
   
   
   
   

Want to take a stab at the bounty and post a tutorial? Need clarification? Join us now or log in! Read more on how this works.