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