Submitted By cyfairbusdvr

Words 524

Pages 3

Words 524

Pages 3

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 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?

Answer: One alternative would be the low-end alternative, low cost, effort, and technology; focusing on the making paper flow more efficient or reducing redundancies in current processes. Requires all…...

...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......

Words: 542 - Pages: 3

...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

...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

...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 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 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

Words: 348 - Pages: 2

...ACC 201 Week 2 Chapter 4 Problems Purchase here http://chosecourses.com/acc-201-week-2-chapter-4-problems Product Description Complete the following problems from Chapter 4 and submit to your instructor. These problems will be graded for accuracy. Problems: 4-20, 4-21 ACC 201 Week 2 Chapter 4 Problems Purchase here http://chosecourses.com/acc-201-week-2-chapter-4-problems Product Description Complete the following problems from Chapter 4 and submit to your instructor. These problems will be graded for accuracy. Problems: 4-20, 4-21 ACC 201 Week 2 Chapter 4 Problems Purchase here http://chosecourses.com/acc-201-week-2-chapter-4-problems Product Description Complete the following problems from Chapter 4 and submit to your instructor. These problems will be graded for accuracy. Problems: 4-20, 4-21 ACC 201 Week 2 Chapter 4 Problems Purchase here http://chosecourses.com/acc-201-week-2-chapter-4-problems Product Description Complete the following problems from Chapter 4 and submit to your instructor. These problems will be graded for accuracy. Problems: 4-20, 4-21 ACC 201 Week 2 Chapter 4 Problems Purchase here http://chosecourses.com/acc-201-week-2-chapter-4-problems Product Description Complete the following problems from Chapter 4 and submit to your instructor. These problems will be graded for accuracy. Problems: 4-20, 4-21 ACC 201 Week 2 Chapter 4 Problems Purchase......

Words: 270 - Pages: 2

Words: 348 - Pages: 2

...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 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

...ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST To purchase this visit here: http://www.activitymode.com/product/acc-403-week-4-chapter-7-problems-strayer-latest/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST ACC 403 Week 4 Chapter 7 Problems Strayer Latest Activity mode aims to provide quality study notes and tutorials to the students of ACC 403 Week 4 Chapter 7 Problems Strayer Latest in order to ace their studies. ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST To purchase this visit here: http://www.activitymode.com/product/acc-403-week-4-chapter-7-problems-strayer-latest/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST ACC 403 Week 4 Chapter 7 Problems Strayer Latest Activity mode aims to provide quality study notes and tutorials to the students of ACC 403 Week 4 Chapter 7 Problems Strayer Latest in order to ace their studies. ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST To purchase this visit here: http://www.activitymode.com/product/acc-403-week-4-chapter-7-problems-strayer-latest/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST ACC 403 Week 4 Chapter 7 Problems Strayer Latest Activity mode aims to provide quality study notes and tutorials to the students of ACC 403 Week 4 Chapter 7 Problems Strayer Latest in order to ace their studies. ACC 403 WEEK 4 CHAPTER 7 PROBLEMS STRAYER LATEST To purchase......

Words: 487 - Pages: 2

...ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH To purchase this visit here: http://www.nerdypupil.com/product/acc-201-week-4-chapter-7-problems-ash/ Contact us at: nerdypupil@gmail.com ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 201 Week 4 Chapter 7 Problems Ash in order to ace their studies. ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH To purchase this visit here: http://www.nerdypupil.com/product/acc-201-week-4-chapter-7-problems-ash/ Contact us at: nerdypupil@gmail.com ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 201 Week 4 Chapter 7 Problems Ash in order to ace their studies. ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH To purchase this visit here: http://www.nerdypupil.com/product/acc-201-week-4-chapter-7-problems-ash/ Contact us at: nerdypupil@gmail.com ACC 201 WEEK 4 CHAPTER 7 PROBLEMS ASH Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 Home Work Hour aims to provide quality study notes and tutorials to the......

Words: 571 - Pages: 3

...ACC 201 Week 4 Chapter 7 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapter-7-problems Product Description Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 ACC 201 Week 4 Chapter 7 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapter-7-problems Product Description Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 ACC 201 Week 4 Chapter 7 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapter-7-problems Product Description Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 ACC 201 Week 4 Chapter 7 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapter-7-problems Product Description Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 ACC 201 Week 4 Chapter 7 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapter-7-problems Product Description Complete the following problems from Chapter 7 and submit to your instructor. These problems will be graded for accuracy. Problems: 7-26, 7-27, 7-28 ACC 201 Week 4 Chapter 7......

Words: 1316 - Pages: 6

...ACC 201 Week 4 Chapters 8 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapters-8-problems Product Description Complete the following problems from Chapter 8 and submit to your instructor. These problems will be graded for accuracy. Problems: 8-18, 8-23 ACC 201 Week 4 Chapters 8 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapters-8-problems Product Description Complete the following problems from Chapter 8 and submit to your instructor. These problems will be graded for accuracy. Problems: 8-18, 8-23 ACC 201 Week 4 Chapters 8 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapters-8-problems Product Description Complete the following problems from Chapter 8 and submit to your instructor. These problems will be graded for accuracy. Problems: 8-18, 8-23 ACC 201 Week 4 Chapters 8 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapters-8-problems Product Description Complete the following problems from Chapter 8 and submit to your instructor. These problems will be graded for accuracy. Problems: 8-18, 8-23 ACC 201 Week 4 Chapters 8 Problems Purchase here http://chosecourses.com/acc-201-week-4-chapters-8-problems Product Description Complete the following problems from Chapter 8 and submit to your instructor. These problems will be graded for accuracy. Problems: 8-18, 8-23 ACC 201 Week 4 Chapters 8 Problems Purchase......

Words: 1440 - Pages: 6