Using MSSQL code the following:

Create a program to monitor course allocated to lecturers and see if the lecturer has too much work or not.

entities -> course coordinator, lecturer, student, course

The course coordinator monitors the course allocation and manages the lecturers

The lecturer allocates marks to students

the course coordinator can print info on the course, such as the lecturer allocated to it, how many students it has and their marks.

If theres too much work no more work can be allocated to the lecturer, if not more work can be allocated.

the lecturer can only allocate 1 mark at a time, and if there are more than 20 students to allocat arks to, the system must wait until the 20 marks are allocated

the lecturer can only be allocated to 1 course