Get help now

Business Rules for Creating ERD Crow’s Foot

  • Pages 3
  • Words 549
  • Views 1,006
  • dovnload

    Download

    Cite

  • Pages 3
  • Words 549
  • Views 1,006
  • Academic anxiety?

    Get original paper in 3 hours and nail the task

    Get your paper price

    124 experts online

    Problem Solutions

    1. Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivity’s and cardinalities in the ERD. 1.a. A department employs many employees, but each employee is employed by one department. 1.b. Some employees, known as “rovers,” are not assigned to any department. 1.c. A division operates many departments, but each department is operated by one division. 1.d. An employee may be assigned many projects, and a project may have many employees assigned to it. 1.e. A project must have at least one employee assigned to it. 1.f. One of the employees manages each department, and each department is managed by only one employee. 1.g. One of the employees runs each division, and each division is run by only one employee. The answers to Problem 1 (all parts) are included in Figure P4.1.

    Figure P4.1 Problem 1 ERD Solution

    As you discuss the ERD shown in Figure P4.1, note that this design reflects several useful features that become especially important when the design is implemented. For example: The ASSIGN entity is shown to be optional to the PROJECT. This decision makes sense from a practical perspective, because it lets you create a new project record without having to create a new assignment record. (If a new project is started, there will not yet be any assignments.) The relationship expressed by “DEPARTMENT employs EMPLOYEE” is shown as mandatory on the EMPLOYEE side.

    This means that a DEPARTMENT must have at least one EMPLOYEE in order to have departmental status. However, DEPARTMENT is optional to EMPLOYEE, so an employee can be entered without entering a departmental FK value. If the existence of nulls is not acceptable, you can create a “No assignment” record in the DEPARTMENT table to be referenced in the EMPLOYEE table if an employee is not assigned to a department. Note also the implications of the 1:1 “EMPLOYEE manages DEPARTMENT” relationship. The flip side of this relationship is that “each DEPARTMENT is managed by one EMPLOYEE.” (This latter relationship is shown as mandatory in the ERD. That is, each department must be managed by an employee!)

    Therefore, one of the EMPLOYEE table’s PK values must appear as the FK value in the DEPARTMENT table. (Because this is a 1:1 relationship, the index property of the EMP_NUM FK in the DEPARTMENT table must be set to “unique.”) Although you ought to approach a 1:1 relationship with caution — most 1:1 relationships are the result of a misidentification of attributes as entities — the 1:1 relationships reflected in the “EMPLOYEE manages DEPARTMENT” and “EMPLOYEE runs DIVISION” are appropriate. These 1:1 relationships avoid the data redundancies you would encounter if you duplicated employee data, such as names, phones, and e-mail addresses, in the DIVISION and DEPARTMENT entities.

    Also, if you have multiple relationships between two entities, such as the “EMPLOYEE manages DEPARTMENT” and “DEPARTMENT employs EMPLOYEE” relationships, you must make sure that each relationship has a designated primary entity. For example, the 1:1 relationship expressed by “EMPLOYEE manages DEPARTMENT” requires that the EMPOYEE entity be designated as the primary (or “first”) entity. If you use Visio to create your Crow’s Foot ERDs, Figure P4.3 shows how the 1:1 relationship is specified. If you use some other CASE tool, you will discover that it, too, is likely to require similar relationship specifications.

    This essay was written by a fellow student. You may use it as a guide or sample for writing your own paper, but remember to cite it correctly. Don’t submit it as your own as it will be considered plagiarism.

    Need a custom essay sample written specially to meet your requirements?

    Choose skilled expert on your subject and get original paper with free plagiarism report

    Order custom paper Without paying upfront

    Business Rules for Creating ERD Crow’s Foot. (2016, May 27). Retrieved from https://graduateway.com/crow-foot-diagram/

    Frequently Asked Questions

    Feel free to contact us anytime, we are always ready to help you!

    How do you use crow's foot notation?
    Crow's foot diagrams represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the relative cardinality of the relationship. These symbols are used in pairs to represent the four types of cardinality that an entity may have in a relationship.
    What are business rules in ER diagram?
    Business Rules are used every day to define entities, attributes, and relationships. Usually though they are used for the organization that stores or uses data to be an explanation of a policy, procedure, or principle.

    Hi, my name is Amy 👋

    In case you can't find a relevant example, our professional writers are ready to help you write a unique paper. Just talk to our smart assistant Amy and she'll connect you with the best match.

    Get help with your paper
    We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy