A course can have many sections and each section is associated with one course; it’s best to represent the semester as two attributes namely semster domain (Autumn, Winter and Spring) and Year. Each of these entities use an artificial number as their primary key.
Kozi na Sehemu ya. Bila shaka unaweza kuwa na sehemu nyingi na kila sehemu ni kuhusishwa na kozi moja; ni bora kuwakilisha muhula kama sifa mbili ambazo ni semster uwanja (Autumn, Winter na Spring) na Mwaka.