Preview

Week 4 MGMT340 Assignment

Good Essays
Open Document
Open Document
538 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Week 4 MGMT340 Assignment
Solutions to Week 4 Problems and Exercises
Business Systems Analysis MGMT340

Chapter 7 Problems and Exercises Solutions
Solution to Question 5
a. The figure shows a ‘many to many’ relationship. Therefore, any EMPLOYEE can work on a PROJECT and there can be several PROJECTS with several EMPLOYEES working on them.
b. The degree shown in the used_on relationship is “one to many” with a minimum cardinality of zero. (The zero through the line near the ‘task’ entity means a minimum cardinality of zero, whereas the crow’s-foot notation means a “many” maximum cardinality, (George, Hoffer & Valacich, 2012). This means that one ‘tool’ can be used on many projects and many projects can make use of one tool.
c. TASK is in a binary many to many relationship (associative relationship) between TOOL and CITY.
d. Skill could also be modeled as an attribute of the EMPLOYEE entity.
e. For EMPLOYEE entity, some added attributes could be Address, Date of Birth and Skill. For PROJECT entity, some added attributes could be Scope and Purpose.
f. TOOL could be modeled as an associative entity along with EMPLOYEES and PROJECTS. An associative entity type is one that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. For example, EMPLOYEES can use TOOL and PROJECT will also need TOOL. TOOL can used by EMPLOYEES for PROJECTS.
Solution to Question 16
Table 1.0
Alternative
Description
A
Buy off the shelf Point of Sale (POS) systems software
B
Buy off the shelf partially customized POS system software
C
Build a fully customized POS system software in house
Table 1.1

Alternative A
Alternative B
Alternative C
Requirement
(Scale of 1 to 5, where 5 is easy/flexible/fast and 1 is difficult/inflexible/Slow)

Easy to Use
5
5
5
Flexible
3
5
4
Fast
4
5
4

Table 1.2

Alternative A
Alternative B
Alternative C
Constraints

Short and Easy Training
2 week
1 week
2 weeks
Ease of Installation
(on a



References: George, F. J., Hoffer, A. J. & Valacich, S. J. (2012). Essentials of Systems Analysis and Design. 5th Ed. Upper Saddle River: NJ: Pearson Education Inc.

You May Also Find These Documents Helpful

  • Powerful Essays

    PROJ 586 Final Exam

    • 872 Words
    • 4 Pages

    1. (TCO A) In a _____ organization, the project manager does not have complete authority over the project team.…

    • 872 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    Chapter 4 Quiz Week 2

    • 537 Words
    • 2 Pages

    For each entity, create a list of attributes you think would be useful to describe the…

    • 537 Words
    • 2 Pages
    Better Essays
  • Best Essays

    122 EBP Essay

    • 1473 Words
    • 5 Pages

    3. no part of this assignment has been written by any other person, except to the extent of collaboration and/or group work as defined in the unit outline.…

    • 1473 Words
    • 5 Pages
    Best 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
  • Satisfactory Essays

    Business Systems Analysis

    • 394 Words
    • 2 Pages

    16. The owner of two pizza parlors located in adjacent towns wants to computerize and integrate sales transactions and inventory management within and between both stores. The point-of-sale component must be easy to use and flexible enough to accommodate a variety of pricing strategies and coupons. The inventory management, which will be linked to the point-of-sale component, must also be easy to use and fast. The systems at each store need to be linked so that sales and inventory levels can be determined instantly for each store and for both stores combined. The owner can allocate $40,000 for hardware and $20,000 for software and must have the new system operational in three months. Training must be short and easy. Briefly describe three alternative systems for this situation and explain how each would meet the requirements and…

    • 394 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Project mangement assign

    • 850 Words
    • 5 Pages

    2. Which of the following criterion is key to recognizing that a set of tasks is a project:…

    • 850 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MULTIPLE CHOICE 1. The statement, "Network diagrams illustrate the technical constraints among activities," means the activities are…

    • 17168 Words
    • 69 Pages
    Satisfactory Essays
  • Good Essays

    One theme or topic; something of importance to a user that needs to be represented in a database. In the entity-relationship model, entities are restricted to things that can be represented by a single table. An example of this is in the EMPLOYEE table; data about the entity (the employee) is in the table rows and data about the entity’s attributes are in the rows.…

    • 805 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Project management

    • 1280 Words
    • 7 Pages

    Task 2a provides evidence for grading criterion P2 (describe the roles and interrelationships of the members of the building team involved in resource management, planning and production.) Task 2b provides evidence for grading criteria M1 (produce organisational charts to explain the group dynamics of team working.)…

    • 1280 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    16) The owner of two pizza parlors located in adjacent towns wants to computerize and integrate sales transactions and inventory management within and between both stores. The point-of-sale component must be easy to use and flexible enough to accommodate a variety of pricing strategies and coupons. The inventory management, which will be linked to the point-of-sale component, must also be easy to use and fast. The systems at each store need to be linked so that sales and inventory levels can be determined instantly for each store and for both stores combined. The owner can allocate $40,000 for hardware and $20,000 for software and must have the new system operational in three months. Training must be short and easy. Briefly describe three alternative systems for this situation and explain how each would meet the requirements and constraints. Are the requirements and constraints realistic? Why or why not?…

    • 334 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    2 . You can choose to get directly involved in one of these projects, which would allow…

    • 1583 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    The constraints between the tasks determine the dependencies between them. Single constrain can lead to any…

    • 941 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    PROTOTYPE DBMS

    • 11094 Words
    • 65 Pages

    An employee may have many degree means that each employee may have more than one degree, Bachelor, Master, and PhD. Also, each degree can be earned by many employees. Therefore the relationship will be M:N relationship. However, the we can use the multivalued attribute to combine all the degrees in to one entity, for instance, we can name the entity as DEGREE and put PhD, Master, and Bachelor in it.…

    • 11094 Words
    • 65 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Q.5 A project has 10 activities. The following table shows the information about the activities.…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Project Management Paper

    • 3353 Words
    • 14 Pages

    8. Several application development projects done for the same functional group might best be managed as part of a a) b) c) d) Portfolio Program Investment Collaborative…

    • 3353 Words
    • 14 Pages
    Powerful Essays