Please help i have that list of teachers. how can i distribute the subjects based on days of the week without any conflict using any insert into stored procedure.
Days |
|
Monday |
|
Tuesday |
|
Wednesday |
|
Thursday |
|
Friday |
|
Saturday |
|
Sunday |
|
|
|
CLASS |
|
S1K |
|
S1K |
|
S2B |
|
S3C |
|
|
|
Software Engineering |
|
Computer Networks |
|
Physics |
|
Chemistry |
|
Mathematics |
|
Applied Mechanics |
|
|
|
List of teachers |
No |
MUKASA JOHN |
2-0001 |
MUKISA PAUL |
2-0002 |
please help