IS 315 Analysis and Design Techniques

Homework Assignment 6

 

 

Note: this assignment consists of 3 parts (Normalized data listing, CRUD diagram, and 12 True/False questions. To complete the assignment successfully, it is necessary that you do all 3 parts. The assignment is due at the beginning of class on Monday, July 14, 2003 and should be turned in as hardcopy or sent to the instructor at jbernste@condor.depaul.edu as an email or attachment to an email provided it is received in time. However, please do NOT turn in a floppy disk or other PC storage media. 

 

Bob’s Books sells books pertaining to the American Civil War to registered customers over the internet. After a customer makes his selections from Bob’s web site and indicates his desire to purchase his or her selections, an order form is created which includes the following information:

ORDER NUMBER

DATE

CUSTOMER NAME

CUSTOMER ADDRESS

CUSTOMER EMAIL ADDRESS

SHIP TO ADDRESS

SHIP VIA INFORMATION

NAMES OF BOOKS ORDERED

BOOK PUBLISHER’S NAMES

PRICE OF EACH BOOK

QUANTITY ORDERED EACH BOOK

LINE TOTAL EACH BOOK

TOTAL ORDER AMOUNT

Using the following ERD of Bob’s operation, normalize the data shown above to third normal form (3NF) and insert it beside the appropriate entities. Add additional fields as necessary. Indicate primary keys (P) and foreign keys (F).

 

Create below a simple CRUD analysis matrix for the BOOKS entity (and its attributes) only. Invent whatever processes you feel you need to achieve all required CRUD entries.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Please put the appropriate answer (True or False) in the box to the left of each question

T/F

 

Normalization is a process by which you identify and correct inherent problems and complexities in your record design.

 

The three normal forms constitute a progression in which a record design in third normal form is better than one that is unnormalized; a record in second normal form is better yet; and a record in first normal form represents the best design.

 

A repeating group is a set of data items that can occur any number of times in a single record.

 

An unnormalized record is one that contains a repeating group.

 

A record design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are dependent on the entire primary key.

 

A record design is in third normal form (3NF) if it is in 2NF and a nonkey field is dependent on another nonkey field.

 

Normal forms beyond 3NF exist and often are used in business-oriented systems.

 

A popular ‘rule of thumb’ is:  a data design is 3NF if every nonkey field depends on the primary key, the whole primary key, and nothing but the primary key.

 

The acronym CRUD, as in a CRUD analysis matrix, stands for Create, Restore, Update, and Delete.

 

In a CRUD analysis matrix, every entity should have at least one C, one R,

one U, and one D entry.

 

If there are not at least one C, one R, one U, and one D entry for an entity in a CRUD analysis matrix, then one of more data stores may have been omitted.

 

A CRUD analysis matrix is also a good tool to allow validation of data completeness.

© 2003 by Joel E. Bernstein
All rights reserved
Last updated July 7, 2003