Describe implement relationship between employees-projects

Assignment Help Database Management System

Reference no: EM1372316

1. Suppose a given user view contains information about employees and projects. Suppose further each employee has a unique EmployeeNum and each project has a unique ProjectNum. Explain how you would implement the relationship between employees and projects in each of the following scenarios:

a. Many employees can work on a given project, but each employee can work on only a single project.

b. An employee can work on many projects, but each project has a unique employee assigned to it.

c. An employee can work on many projects, and a project can be worked on by many employees.

Reference no: EM1372316

Questions Cloud

How does it affect level of investment and interest rates : How does it affect level of investment and interest rates. How does it affect individual consumer. Give at least three examples in your response.

Question about marginal productivity theory : What if a company employs ten workers and pays each $15 each hour. Further suppose that the MP of the 10th worker is five units of output

What is the spring constant : A 140 g air-track glider is attached to a spring. The glider is pushed in 12.00 cm and released. A student with a stopwatch finds that 9 oscillations take 10.0 s.

What is price of an additional dollar of local spending : What is price of an additional dollar of local spending in each case. Which of two methods do you think would lead to higher levels of local spending on roads. Explain your answer.

Describe implement relationship between employees-projects : Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

Why to avoid the weight of the bat : Avoid the weight of the bat, since it is so much less than the force of the bat. Select the direction of the incoming ball as positive direction.

Calculate the profit maximizing price : General Cereals, (GCI) produces and markets Sweeties!, a popular ready to eat breakfast cereal. In an effort to expand sales in the Secaucus,

What is the net work done on the weights : A charge of -3.55 nC and a charge of -5.65 nC are unconnected by a distance of 60.0 cm. Find the position at which a third charge of +7.20 nC can be located so that the net electrostatic force on it is zero.

What is the change in length of rod : If a drop is to be deflected a distance = 0.28 by the time it reaches the end of the deflection plate, what magnitude of charge should be given to the drop? Imagine that the density of the ink drop is 1000 and ignore the effects of gravity.

User Account

All Pages