View the step-by-step solution to: Devry 340 mgmt petrie electronics Using the guidelines from

Devry 340 mgmt petrie electronics

Using the guidelines from this chapter and other
sources, evaluate the usability of the page design
depicted in PE Figure 8-1.
2. 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 PE Figure 8-1?
3. Describe how cookie crumbs could be used in
this system. Are cookie crumbs a desirable navigation
aid for this system? Why or why not?
4. The page design depicted in PE Figure 8-1 links to
an Order History page. Sketch a similar layout for
the Order History page, following guidelines from
Chapter 8.
5. Describe how the use of template-based HTML
might be leveraged in the design of the “No Customer
Escapes” system.

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 PE Figure 7-1 to
include any other entities and the attributes you
identified from the Petrie’s case. Review your answers
to these questions, and add any additional
needed relations to the document in PE Figure 9-1.
2. 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.
3. 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
4. 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?
5. Complete all table and field definitions for
the Petrie’s Electronics case database using
Microsoft Access. Besides the decisions you have
made in answers to the preceding questions, fill in
all other field definition parameters for each field
of each table.
6. 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.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • 890,990,898

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • 890,990,898


    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards