question

makumbi asked Mar 12, '22

How can i distribute subjects based on days in a week without creating a conflict using sqlserver

Please help i have these day and the classes where teachers teach the classes are S1K, S2B,S3C how can i use the subjects they teach and distribute them based on days

Days
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

CLASS
S1K
S1K
S2B
S3C

Subject
Software Engineering
Computer Networks
Physics
Chemistry
Mathematics
Applied Mechanics

List of teachersNoMUKASA JOHN2-0001MUKISA PAUL2-0002