Question: Need help If an employee can work on many projects and a project can be worked on by many employees, what type of relationship is

Need help

If an employee can work on many projects and a project can be worked on by many employees, what type of relationship is there between projects and employees? How would you implement this relationship? How many tables would you use, why

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!

If an employee can work on many projects and a project can be worked on by many employees, what type of relationship is there between projects and employees? How would you implement this...

TASK A company has a database that tracks the companys departments, employees, and their dependents. For the company, we maintain company name as Primary key (Pkey) and its address. Employees and...

A company has a database that tracks the companys departments, employees, and their dependents.For the company, we maintain company name as Primary key (Pkey) and its address. Employees and their...

Assignment 2 - Chapter 3 & 4 6. What does it mean to say that a database displays both entity integrity and referential integrity? 7. What are the requirements that two relations must satisfy in...

Example - Problem Description A company runs a business and has employees, departments and projects. The details of employees, departments and projects are maintained. Employees have dependents....

This is an introduction to database question which needs deep understanding of concepts Analyze the business rules of a Wall Coverings Company carefully and use it to answer the given questions.The...

I need an EDR MSIS 3333 Remember to make a copy for yourself. 1. Projects, Inc. is an engineering firm with approximately 500 employees. A database is required to keep track of all employees, their...

Help , Make ER diagram and state assumption you believe you have to make in order to develop complete diagram . Will Upvote!! (DATABASE MANAGEMENT) 1. Draw an ERD for the following situation. State...

Your hand drawn ( pencil / paper ) ORGINAL CHEN METHODOLOGY ( Ovals for attributes, Diamonds for relationships ) . Take a picture of your drawing ( ER Data Model ) and post it to Canvas in the...

Given the accounting equation, answer each of the following questions (a) The liabilities of McGlone Company are $120,000 and the owners equity is $232,000.What is the amount of McGlone Companys...

Two forces, F1, and F2, act at a point. The magnitude of F1 is 9.00 N, and its direction is 60.00 above the x-axis in the second quadrant. The magnitude of F 2 is 6.00 N, and its direction is 53.10...

The cost of an annuity varies with the age of the annuitant at issue. age of the annuitant when payment begins. method of proceeds distribution. sex of the annuitant. all of the above.

At 700 K, acetaldehyde decomposes in the gas phase to methane and carbon monoxide. The reaction is: CH3CHO(g)CH4(g)+CO(g) A sample of CH3CHO is heated to 700 K, and the pressure is measured as 0.22...

=+2 Are there or can there ever be universal approaches to performance appraisal?

=+3 How does the international character of the MNE impact the implementation of the performance management system?

=+5 What are the major issues involved in performance management of international assignees?