Answered You can hire a professional tutor to get the answer.
Devry 340 mgmt petrie electronics Using the guidelines from this chapter and other sources, evaluate the usability of the page design depicted in PE...
Devry 340 mgmt petrie electronicsUsing the guidelines from this chapter and othersources, evaluate the usability of the page designdepicted in PE Figure 8-1.2. Chapter 8 encourages the design of a help systemearly in the design of the human interface. Howwould you incorporate help into the interface asshown in PE Figure 8-1?3. Describe how cookie crumbs could be used inthis system. Are cookie crumbs a desirable navigationaid for this system? Why or why not?4. The page design depicted in PE Figure 8-1 links toan Order History page. Sketch a similar layout forthe Order History page, following guidelines fromChapter 8.5. Describe how the use of template-based HTMLmight be leveraged in the design of the “No CustomerEscapes” system.In the questions associated with the Petrie’s Electronicscase at the end of Chapter 7, you were askedto modify the E-R diagram given in PE Figure 7-1 toinclude any other entities and the attributes youidentified from the Petrie’s case. Review your answersto these questions, and add any additionalneeded relations to the document in PE Figure 9-1.2. Study your answer to Question 1. Verify that therelations you say represent the Petrie’s Electronicsdatabase are in third normal form. If they are,explain why. If they are not, change them so thatthey are.3. The E-R diagram you developed in questions inthe Petrie’s Electronics case at the end ofChapter 7 should have shown minimum cardinalitieson both ends of each relationship. Are minimumcardinalities represented in some way inthe relations in your answer to Question 2? If not,how are minimum cardinalities enforced in thedatabase?4. Using your answer to Question 2, select datatypes, formats, and lengths for each attribute ofeach relation. Use the data types and formats supportedby Microsoft Access. What data typeshould be used for nonintelligent primary keys?5. Complete all table and field definitions forthe Petrie’s Electronics case database usingMicrosoft Access. Besides the decisions you havemade in answers to the preceding questions, fill inall other field definition parameters for each fieldof each table.6. The one decision for a relational database thatusually influences efficiency the most is indexdefinition. What indexes do you recommend forthis database? Justify your selection of each index.
