ZuoTi.Pro
Question

Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.


Exercise 1: ERD 

Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. 

  • A department employs many employees, but each employee is employed by only one department. 

  • Some employees, known as "rovers," are not assigned to any department. 

  • A division operates many departments, but each department is operated by only one division. 

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

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

  • One of the employees manages each department, and each department is man-aged by only one employee. 

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

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1

Entity Relationship Diagram

Data model according to the business rules given

Connectivity in the Entity relationship Diagram

Relationship between DIVISION and DEPARTMENT – 1: M relationship

Relationship between DEPARTMENT and EMPLOYEE - 1: M relationship

Relationship between EMPLOYEE and PROJECT- M:N relationship

Cardinalities are shown in the above diagram of data model between the identities.

There is M:N relationship between Employee and Project.

Spiting this M:N relationship between Employee and project and creating Crow’s Foot ERD.

step: 2 of 2

Crow’s Foot ERD – Based on the above data model the ERD is shown below:

1 0
Add a comment
Know the answer?
Add Answer to:
Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Create a complete ERD for the problem described in problem ch team those cond Identif ....

    Create a complete ERD for the problem described in problem ch team those cond Identif . Identify . Identif . Identif PLAY . Draw . Draw Part 2 Design Concepts blems 1. Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD . A department employs many employees, but each employee is employed by only one department Some employees, known as "rovers," are not assigned to any department. . A...

  • Create a Crow's Foot ERD to include the following business rules for a given company: Each...

    Create a Crow's Foot ERD to include the following business rules for a given company: Each employee can complete many invoices. Each invoice is completed by one employee. Each employee is employed by one department. Each department has many employees. Each customer can generate many invoices. Each invoice is generated by one customer.

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • can you show me how the crow foor ERD should be for this example 1. Given...

    can you show me how the crow foor ERD should be for this example 1. Given the following business rules, finish the business rule and create the appropriate Crow's Foot ERD. Paste the ERD from Visio into this document. a A COMPANY operates many DEPARTMENTS. b. Each DEPARTMENT employs one or more EMPLOYEEs. c. Each of the EMPLOYEEs might or might not have one or more DEPENDENTS. d. Each EMPLOYEE might or might not have an EMPLOYEE HISTORY Given the...

  • create a Crows Foot ERD using specilization ERD

    Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in.  For each department, the department name, internal mail box number, and office phone extension are kept.  A department can have many assigned employees, and each employee is assigned to only one department.  Employees can be salaried employees, hourly employees, or contract employees.  All employees are assigned an employee number.  This...

  • Problem (40 points) Prepare an Entity Relationship diagram with the cardinalities for the following business rules:...

    Problem (40 points) Prepare an Entity Relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares a purchase order, which is sent to a supplier, although ea 2. A supplier is able to ship many different inventory items, although each inventory item can be 3. 4. Each department has only one supervisor. Supervisor must oversee at least one department, but supplier can make many orders. ordered from a specific supplier Each department has at least...

  • Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...

    Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...

  • 11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for...

    11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. b. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in...

  • Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business...

    Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares many purchase orders, each of which is sent to a specific supplier. 2. Each supplier is able to ship many different inventory items, although each inventory item can be ordered from a specific supplier. 3. Each department has at least one employee. Employees must be assigned to at least one, but possibly more departments. 4. Each department has...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT