Use the business rules to create an ERD

Assignment Help Operation Management

Reference no: EM13900472

Use the following business rules to create an ERD which include all appropriate connectivities and cardinalities.

Also, specify the relational schema for the resulting ERD.

a) An employee may be assigned many projects, and a project may have many employees assigned to it.

b) A project must have at least one employee assigned to it.

c) One of the employees manages each department, and each department is managed by only one employee.

d) One of the employees runs each division, and each division is run by only one employee.

Reference no: EM13900472

Questions Cloud

In distributive strategy-the union makes opening proposal : Management in a small company has recently realized a $100,000 increase in profits. This has occurred after two years of poor economic performance due to expensive storm damage in two of its facilities. In a distributive strategy, if the company open..

Partnership liabilities consist of accounts payable : Partnership liabilities consist of accounts payable

How individual choices interacted with individual choices : For each of these actions, describe how your individual choices interacted with the individual choices made by others. Were other people left better off or worse off by your choices in each case?

What will be the number of share outstanding after the split : What will be the number of shares outstanding after the split? If the common stock had a market price of $165 per share before the stock split, what would be an approximate market price per share after the split?

Use the business rules to create an ERD : Use the following business rules to create an ERD which include all appropriate connectivities and cardinalities.

For what reasons might aspen have purchased treasury stock : Where will the balance in Paid-In Capital from Sale of Treasury Stock be reported on the balance sheet? For what reasons might Aspen Inc. have purchased the treasury stock?

Portfolio project on trust and estates : Portfolio Project: Trust and Estates

Power to improve the lives of its stakeholders : How can Google use its power to improve the lives of it's stakeholders? Do you feel there is any way Google can respect privacy and yet still maintain it's profitability? What are some of the effects government regulation of the internet might have o..

Write paragraph that shows a reflection of michaels ideas : Watch the Strategy and Project Management video from PMI with Michael Porter from Harvard. Write one paragraph that shows a reflection of Michael's ideas

User Account

All Pages