Preview

Management: Employer and Employee

Satisfactory Essays
Open Document
Open Document
682 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Management: Employer and Employee
3. Answer the following questions concerning Figure 2-22.
a) Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on it be different in other organizations?
A unary relationship is shown with the EMPLOYEE entity; An EMPLOYEE Supervises 0:M EMPLOYEEs, An EMPLOYEE Is Supervised By 0:1 EMPLOYEE. This relationship tells us that we can determine what employees are supervised by another employee, as well as determine which employees are supervisors in this company.
In other organizations, there may be different policies regarding employee supervision that could cause the data relationships among EMPLOYEE instances to be different. For instance, another company might allow an employee to have multiple supervisors (e.g., in an organization with a matrix structure).
b) Why is Includes a one-to-many relationship and why might this ever be different in some other organization?
Includes is a one-to-many (1:M) relationship because of the business rules that PVFC has in place: “a product line may group any number of products but must group at least one product; and each product must belong to exactly one product line.” Another organization may have other business rules that could permit a product being assigned to more than one product line (changing Includes to a M:N relationship). Alternatively, another organization might also show Includes as a (1:M) overall relationship but might permit the establishment of a PRODUCT LINE without identifying PRODUCTs that belong to this group (e.g., thus permitting an optional minimum cardinality on the PRODUCT side of the Includes relationship).
c) Does Includes allow for a product to be represented in the database before it is assigned to a product line (e.g., while the product is in research and development)?
No, Figure 22 shows that the PRODUCT must be Included in at least 1 PRODUCT LINE by the mandatory 1 and only 1 cardinality notation near the PRODUCT LINE portion of the Includes

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Hollis IS3230 Lab1

    • 278 Words
    • 2 Pages

    2. Because it’s easier to manage a group than individuals. Once you have the group setup with permissions, you add or remove employees.…

    • 278 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Eco 550 Final Exam

    • 679 Words
    • 3 Pages

    27). Agency problems appear in many settings within a firm. All of the following are examples, except which is NOT a good example of this problem?…

    • 679 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Database Concepts Pt2520

    • 326 Words
    • 2 Pages

    2. FALSE You only need to include the most important stakeholders in the database discussions.…

    • 326 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Business p2 unit 2

    • 310 Words
    • 2 Pages

    There are a number of limitations and constraints that are involved within marketing products. These are:…

    • 310 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    IST223 Crib sheet

    • 3425 Words
    • 7 Pages

    rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist…

    • 3425 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Each of the above companies organizes their employees’ different ways. Company A gives an employee a specific…

    • 1087 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Entity-relationship Model

    • 411 Words
    • 2 Pages

    12. Linking Entities- Linking entities are used to resolve many-to-many relationships into two one-to-many relationships.…

    • 411 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mk411

    • 1913 Words
    • 8 Pages

    2. The product hierarchy stretches from basic needs to particular items that satisfy those needs. (TRUE)…

    • 1913 Words
    • 8 Pages
    Satisfactory Essays
  • Powerful Essays

    unit 11 level 5

    • 1435 Words
    • 6 Pages

    Davys and Beddoes 2010 supervision model integrate management and development and uses a triangle with each point having a supervisor function. 1)Managing service delivery, 2)organisation policies, procedures and protocols, 3)quality and quantity of work decisions and priorites.…

    • 1435 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Case Study MBA 615

    • 3326 Words
    • 4 Pages

    GMCT had originally been targeted to begin service to subscribers on February 1, but it…

    • 3326 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Anime LIst

    • 11441 Words
    • 52 Pages

    Which of the following defines a relationship in which each occurrence of data in one entity…

    • 11441 Words
    • 52 Pages
    Good Essays
  • Powerful Essays

    Music

    • 1176 Words
    • 5 Pages

    * And the item table,– it will contain at least three items for each vendor.…

    • 1176 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Induction Standard 1

    • 4191 Words
    • 17 Pages

    Contents 1. 2. 3. 4. 5. Responsibilities and limits of your relationship with an individual Working in ways that are agreed with your employer The importance of working in partnership with others Be able to handle information in agreed ways Questions…

    • 4191 Words
    • 17 Pages
    Powerful Essays
  • Powerful Essays

    theories of development

    • 1908 Words
    • 6 Pages

    Davys and Beddoes 2010 supervision model integrate management and development and uses a triangle with each point having a supervisor function.…

    • 1908 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Marketing

    • 888 Words
    • 4 Pages

    1) The belief that a firm should dedicate all of its policies, planning, and operation to create customer…

    • 888 Words
    • 4 Pages
    Good Essays