[meteor_slideshow slideshow=”arp1″]
The only reference that i want you to use is my book Essentials of systems analysis & design by Valacich, George and Hoffer
Read the Petrie’s Electronic Case at the end of Chapter 8, pages 270?271.
Read the Petrie’s Electronic Case at the end of Chapter 9, pages 315?317 ( You only have to pick two questions out of the 5)
Petrie’s Electronics needs to improve its marketing and customer retention by increasing customer loyalty. The marketing department is in need of a Customer Relationship Management (CRM) system. Upper management has selected No Customer Escapes as the top Information Technology project this year.
1. In Week 5, we move into the third phase of the system development life cycle (SDLC), System Design. In the System Design phase, we must complete two important activities: designing the human interface and designing databases. Once we have our design complete, we can move to the final phase of the SDLC, Implementation and Operation, which will be covered in Week 6.
2. In order to finalize our design, we need to understand the process and formatting guidelines for creating forms, reports, web pages, and dialogue diagrams.
3. We will answer the Petrie’s Electronics Case Questions on pages 270?271. The main deliverable is to evaluate and redesign the usability of the customer account area web page (PE Figure 8-1, page 271), and create the Order History Page following the guidelines from the chapter.
4. For Chapter 9, only answer Petrie’s Electronics Case Questions 4. For Chapter 9, only answer Petrie’s Electronics Case Questions 1, 2, 3, 4, and 6. ( You only have to pick two questions out of the 5)
5. To succeed this week, you will need to do the following.
a. Continue reading in our book. Last week, we read Chapter 7; this week, we must understand all of the concepts in Chapters 8 and 9.
b. Read the Petrie’s case study at the end of Chapters 8 and 9 to add to what we learned in previous weeks.
c. Be sure to update the customer accounts area web page and Order History web page using Visio or any other MS Office product.
6. We will validate the preliminary ERD described in PE Table 7-1 on page 230. The Petrie’s Electronics Case in Chapter 7 on page 229?231, describes how you will validate requirements for the CRM project and update the ERD.
Petrie’s Electronics Case, Chapter 8, Questions 1?5. You will need to update the customer account area page and create the Order History Page using Visio or any MS Office product.
Petrie’s Electronics Case, Chapter 9, Questions 1?4, and 6.
Systems Design SDLC Phase 3 Package
Petrie?s Electronics Case Questions Solutions (Chapter 8) Points
Using the guidelines from this chapter and other sources, evaluate the usability of the page design depicted in Figure 8-1.
Chapter 8 encourages the design of a help system early in the design of the human interface. How would you incorporate help into the interface as shown in Figure 8-1?
Describe how cookie crumbs could be used in this system. Are cookie crumbs a desirable navigation aid for this system? Why or why not?
Using the Web, find three customizable customer loyalty program systems being sold by vendors. Create a table like Table 8-2 that compares them.
Describe how the use of template-based HTML might be leveraged in the design of the No Customer Escapes system.
Petrie?s Electronics Case Questions Solutions (Chapter 9)
In the questions associated with the Petrie’s Electronics Case at the end of Chapter 7, you were asked to modify the E-R diagram given in Figure 7-1 to include any other entities and the attributes you identified from the Petrie’s cases. Review your answers to these questions, and add any additional needed relations to the document in Figure 9-1.
Study your answer to Question 1. Verify that the relations you say represent the Petrie’s Electronics database are in third normal form. If they are, explain why. If they are not, change them so that they are.
The E-R diagram you developed in questions in the Petrie’s Electronics Case at the end of Chapter 7 should have shown minimum cardinalities on both ends of each relationship. Are minimum cardinalities represented in some way in the relations in your answer to Question 2? If not, how are minimum cardinalities enforced in the database?
Using your answer to Question 2, select data types, formats, and lengths for each attribute of each relation. Use the data types and formats supported by Microsoft Access. What data type should be used for nonintelligent primary keys?
The one decision for a relational database that usually influences efficiency the most is index definition. What indexes do you recommend for this database? Justify your selection of each index.
Place your order of custom research paper With us NOW. The assignment will be written from scratch by our qualified and experienced writers.
[meteor_slideshow slideshow=”arp2″]
A-Research-Paper.com is committed to deliver a custom paper/essay which is 100% original and deliver it within the deadline. Place your custom order with us and experience the different; You are guaranteed; value for your money and a premium paper which meets your expectations, 24/7 customer support and communication with your writer. Order Now
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]