Question: 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.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CONTENTS COVID SAFETY ON CAMPUS 2 WHAT IS THE UNIT ABOUT? 3 UNIT DESCRIPTION 3 INTENDED LEARNING OUTCOMES 3 ACKNOWLEDGEMENT OF COUNTRY 3 GRADUATE STATEMENT 4 ALTERATIONS TO THE UNIT AS A RESULT OF...

CHAP TER 1 The Role of Human Resources HUMAN RESOURCE MANAGEMENT DAY TO DAY You have just been hired to work in the human resource department of a small company. You heard about the job through a...

Managerial Decision Making Six Decision Stages in Chapter 5 I. Identify and Diagnose the Problem Consider the following questions when identifying and diagnosing the problem: Is there a difference...

Exercise one. 1. Let the market demand curve be P=1000 - 10Q. Assume the market is controlled by a monopolist. Let fixed cost be $10,000 and Marginal Costs (MC)=20Q. a) What is the profit maximizing...

i. Explain all the questions well. 1). The market demand function for a good is given by Q = D(p) = 800 50p. For each firm that produces the good the total cost function is TC(Q) = 4Q+( Q2/2) ....

Explain the questions well. 1). The market demand function for a good is given by Q = D(p) = 800 50p. For each firm that produces the good the total cost function is TC(Q) = 4Q+( Q2/2) . Recall that...

Section A. 5. One key difference between traditional economics and behavioral economics is a) b) c) d) A. Traditional economics does not argue that markets are efficient while behavioral economics...

Adidas AG (Adidas ) is engaged in the design, development, manufacture and marketing of a broad range of athletic and sports lifestyle products such as footwear, apparel, hardware (bags and balls)...

only do the Individual reflective journal and statement Part A: Reflective Journal ?1000words? This assessment task requires you to reflect upon your learning experience in this course, including...

A university campus has 200 classrooms and 400 faculty offices. The classrooms are equipped with 12 fluorescent tubes, each consuming 110 W, including the electricity used by the ballasts. The...

Hudson Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or...

2 . How can a company nobody had heard of 1 0 years ago, have a capitalization greater than competitors with 1 0 0 years history?

Problem 1 od sales are $300,000, cost of food sales $120,000, direct operating expenses $60,000, and occupancy costs $80,000. What is the gross profit

1. Identify what positions are included in the plan.

2. Identify the employees who are included in the plan.

7. Discuss the implications of a skill-based pay plan for training.