Week 4: Problems and Exercises

In: Computers and Technology

Submitted By skumberg
Words 542
Pages 3
Week 4: Problems and Exercises

5. Consider the E-R diagram in Figure 7-20. Based on this E-R diagram, answer the following questions:
a. According do E-R diagram Figure 7-20 the degree shows many to many which indicates there are several projects with several employees working on them.
b. The degree of the Used on shows “many” (maximum cardinality) coming from Tool and “minimum” (cardinality of zero) to Task.
c. There is one associative entity that appear in this diagram: Work on
d. How else could the attribute Skill be modeled?
e. There are no attributes that can be assigned to Work on as it is not an entity. We represent an attribute by placing its name inside the rectangle that represents the associated entity
f. Yes, Tool could be modeled as an associative entity because there could be many tools that are needed for the project that the team is working on.

16. CRITERIA | ALTERNATIVE A | ALTERNATIVE B | ALTERNATIVE C | Requirements | | | | 1. Easy to use (Fast) | Off the shelf Product | Off the shelf (fully customized) | Fully customized | 2. Linked to each other | Yes | Yes | Yes | 3. Point-of-sale component | Yes | Yes | Yes | | | | | Constraints | | | | 1. Cost to software | 10,000.00 | 20,000.00 | 25,000.00 | 2. Cost of hardware | 20,000.00 | 40,000.00 | 40,000.00 | 3. Time to operation | Two months | Three months | Four months | 4. Ease of training | One week of training | Two weeks of training | One week of training |

For Alternative A, you would fore go all the customization of "off-the-shelf" software, and that may not give you all the functions desired for reports and the particular business. To get a fully customerized it would take a bit longer than the time allowed and cost a bit more than the budget allows. If you pick Alternative B, you would get customization and be within budget and expected time…...

Similar Documents

Week 4 Exercises

...Week Four Exercises The assigned exercises for week four of Business Research (BUS642) at Ashford University are as follows: Terms in Review, 1-4, on page 204 and answering questions 1-3 over the case study: Ramada Demonstrates its Personal Best. Terms in Review, #1-4, p 204 1. Compare the advantages and disadvantages of the survey to those of observation. Each method has its own set of advantages. Surveys allow the researcher to use the largest possible sample sizes while at the same time making the data quantifiable and easily sorted. Survey results are more reliable than personal observations and therefore are less biased when the survey questions are worded and asked correctly. Surveys are time consuming for both the participant and the researcher. It may be difficult to find a time that is convenient for both parties. Surveys also seek to answer specific questions whereas observation may be taken to mean any number of things and the data may be used in a random and haphazard manner. By using observation, the researcher is able to carry out research without interfering with the subject’s daily life and activities. Observation is also able to be carried out in an unobtrusive manner that allows the researcher to gather the needed information without having to ask a lengthy series of questions. Observation is quicker and less expensive than conducting research. Observation is conducted in the subject’s natural environment allowing for a true representation of action......

Words: 2700 - Pages: 11

Week 4 Problems and Exercises Chapter 7

...Problems and Exercises 5. Consider the E-R diagram in Figure 7-20. Based on this E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? Answer: As many as needed. b. What is the degree of the Used on relationship? Answer: The degree is binary relationship, two degrees * c. Do any associative entities appear in this diagram? If so, name them. Answer: Yes, Tasks; d. How else could the attribute Skill be modeled? Answer: I think it could be as part of Task. * e. What attributes might be attached to the Works on relationship? Answer: Experience, Type, Job. * f. Could TOOL be modeled as an associative entity? Why or why not? Answer: No, because tools would be used for different tasks 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......

Words: 524 - Pages: 3

Problems and Exercise Questions for Week 4

...Problems and Exercise Questions for Week 4 1. Chapter 7, Problems/Exercises, Questions 5, 16, and 17 (post in the “Week4: Problems and Exercise” DropBox). 5. Study the E-R diagram of Figure 7–20. Based on this E-R diagram, answer the following questions: (5 points) a. How many PROJECTs can an employee work on? As we see the sign for mandatory many there are 2 entity with 2 entity type b. What is the degree of the includes relationship? Between Tool and Task we got Binary Relationship Many to many if say” tools”, otherwise it will be one to many. c. Are there any associative entities on this diagram? If so, name them. No. between tools and city we do not need to have any associative entities. An associative entity is a relationship that the data modeler chooses to model as an entity type d. How else could the attribute Skill be modeled? We can use a multivalued attribute may take on more than one value for each entity Project _ID-Employee_ID Task_ID all in one box e. Is it possible to attach any attributes to the Includes relationship? Tasks require Time and Skill, and have to be done in the city by an employee who has an ID and carries tools. f. Could TASK be modeled as an associative entity? Yes it can as our book explain: An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. 16. The owner of two pizza......

Words: 594 - Pages: 3

Week 1 Problems and Exercises

...Problems and Exercises Week 1 Chapter 1 1. Why is it important to use systems analysis and design methodologies when building a system? Why not just build the system in whatever way seems to be “quick and easy?” What value is provided by using an “engineering” approach? It is important to use system analysis and design methodologies when building a system because it helps identify the problem to be solved and what the goal of the system should be. If you just started the fastest way you would most likely miss the reason for building it plus you may only create more problems. The value added is utilizing the time and resources you have most efficiently. By not using an engineering approach you risk too much waste. 8. How might prototyping be used as part of the SDLC? Prototyping can be used as a tool to help identify what users want from the system being designed. It aids the analyst in the SDLC process to help provide answers as to what users may want. Chapter 2 3. In the section on choosing off-the-shelf software, eight criteria are proposed for evaluating alternative packages. Suppose the choice is between alternative custom software developers rather than prewritten packages. What criteria would be appropriate to select and compare among competing bidders for custom development of an application? Define each of these criteria. Cost – the total cost of the application which includes all aspects from development to installation......

Words: 426 - Pages: 2

Exercises & Problems Week 4

...Exercises & Problems Week 4 Exercise E10-6 Payroll Tax Expense 352.16 FICA Payable 198.40 Federal Unemployment Taxes Payable 19.84 State Unemployment Taxes Payable 133.92 (To record Payable Taxes for the week) Exercise E 10-8 1. True 2. True 3. False 4. True 5. False 6. False 7. True 8. True 9. True 10. True Exercise E10-18 A. Jan.1, 2011 Cash 562,613 Discount on Bonds Payable 37,387 Bonds Payable 600,000 (To record sale of bonds at discount) B. Jul.1, 2011 Bond Interest Expense 28,131 Discount on Bonds Payable 1,131 Cash 27,000 (To record payment of bond interest and amortization of bond discount) C. Dec.31, 2011 Bond Interest Expense 28,187 Discount on Bonds Payable 1,187 Bonds Interest Payable 27,000 (To record account bond interest and amortization on bond discount) Problem......

Words: 460 - Pages: 2

Exercises & Problems Week 6

...Exercises & Problems Week 6 Complete Exercises E11-15, E12-1, & E12-2 and Problem 11-6 Exercise E11-15 Before After After Action Dividend Stock Split Stockholders’ equity Paid in capital Common stock, $10 par 600,000 630,000 600,000 Paid in capital in excess par value 0 12,000 0 Total paid in capital 600,000 642,000 600,000 Return earnings 900,000 858,000 900,000 Total stock holders’ equity 1,500,000 1,500,000 1,500,000 Outstanding shares 60,000 66,000 120,000 Exercise E12-1 1. Companies purchase investments in debt or stock securities because they have excess cash, earnings from investment income, and strategic reasons. 2. A company will have excess cash it does not need for operations because of seasonal fluctuates it sales. The company will use excess funds for a bigger return than holding in the bank. 3. A typical investment when investing cash for a short period of time would be a short term government security. 4. A typical investment when investing in cash to generate earnings would be investing in debt. 5. A company would invest in securities that provide zero cash flow for strategic reasons such as influence over customers or make presence known by a related company in the industry. 6. A typical stock investment when investing cash for strategic reasons would be in a related or no related company. This will allow......

Words: 513 - Pages: 3

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://homeworklance.com/downloads/mgmt-340-business-analysis-system-week-4-problems-and-exercises/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Lancehomework@gmail.com Visit our Site for More Tutorials: ( http://homeworklance.com/ ) MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 1389 - Pages: 6

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://homeworklance.com/downloads/mgmt-340-business-analysis-system-week-4-problems-and-exercises/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Lancehomework@gmail.com Visit our Site for More Tutorials: ( http://homeworklance.com/ ) MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 3124 - Pages: 13

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://homeworklance.com/downloads/mgmt-340-business-analysis-system-week-4-problems-and-exercises/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Lancehomework@gmail.com Visit our Site for More Tutorials: ( http://homeworklance.com/ ) MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 3124 - Pages: 13

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://homeworklance.com/downloads/mgmt-340-business-analysis-system-week-4-problems-and-exercises/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Lancehomework@gmail.com Visit our Site for More Tutorials: ( http://homeworklance.com/ ) MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 348 - Pages: 2

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://homeworklance.com/downloads/mgmt-340-business-analysis-system-week-4-problems-and-exercises/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Lancehomework@gmail.com Visit our Site for More Tutorials: ( http://homeworklance.com/ ) MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 348 - Pages: 2

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://hwguiders.com/downloads/mgmt-340-business-analysis-system-week-4-problems-exercises MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 317 - Pages: 2

Mgmt 340 Business Analysis System Week 4 Problems and Exercises

...MGMT 340 Business Analysis System Week 4 Problems and Exercises http://hwguiders.com/downloads/mgmt-340-business-analysis-system-week-4-problems-exercises MGMT 340 Business Analysis System Week 4 Problems and Exercises Chapter 7 5. Consider the E-R diagram in Figure 7-20. Based onthis E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associativeentity? Why or why not? 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...

Words: 317 - Pages: 2

Week 5 Problems & Exercise

...Problem & Exercise Chapter 8 3. A report is meant for reading and information, so if a report is not properly put together then these things can happen: * listed with no page numbers then they can be shuffled and get out of order * putting the headings of the columns on every page (if not it is information overload & you will lose you place) * having incorrect information/data * missing one of the who, what, when, or where (software error) * data errors The consequences to these errors are: * the wrong decisions can be made * the data can given or received can be wrong * the outputs are wrong If the analyst can notice most of the errors as he is working on them so that it may be corrected then this can help keep the project of the report going without too many complications. Prototyping is very helpful when working on reports because the analyst is able to structure and refine the report before it is viewed by the mass majority without the consequences of errors. 4. The date does not specify when the report was generated; it does not give a revision date or code for any prior report versions, does not provide any meaningful information, there is not any page number listed, the spacing of the report information does not seem to be in place. This report is done poorly and is not clear on its intended purpose. ABC Company Page: 1 of 1 Detail Employee Information Today: 02-Jan-08 Employee Number: ......

Words: 326 - Pages: 2

Exercises and Problems Week 6

...Exercises and Problems-Week 6 Jessica Warner XACC/291 Principles of Accounting II 01/17/2016 Instructor Jaclyn Strauss Exercises and Problems-Week 6 E11-15 Stockholders’ equity paid in capital | Before Action | After Stock Dividend | After Stock Split | Common stock, $10 par | $600,000 | $630.000 | $600,000 | Paid-in capital in excess par value | $0 | $12,000 | $0 | Total paid-in capital | $600,000 | $642,000 | $600,000 | Return earnings | $900,000 | $858,000 | $900,000 | Total stockholders’ equity | $1,500,000 | $1,500,000 | $1,500,000 | Outstanding Shares | $60,000 | $66,000 | $120,000 | E12-1 1. Companies purchase investments in debt or stock securities for three reasons: they have excess cash, they view them as a significant revenue source, and they have strategic goals of either gaining control of competitors or moving to a new line of business according to Weygandt (2008). 2. A corporation would have excess cash that is not needed for operations in events such as “seasonal fluctuation in sales” (Weygandt, 2008). 3. The typical investment when investing cash for short periods of time would be “low-risk, highly liquid securities—most often short-term government securities” (Weygandt, 2008). 4. The typical investments when investing cash to generate earnings are lending money and investing in debt. 5. Companies would invest in securities that provide no current cash flows for strategic reasons such as influence over customers......

Words: 561 - Pages: 3

1 rponse | HidupMusik | 37 Nap- Út az első világháborúig