Apply Your Knowledge

Pick and Shovel Construction Company
Situation:

       Pick and Shovel Construction Company is a multi state building contractor specializing in medium-priced town homes. C. T. Scott, the owner, is in your office for the third time today to see how the new relational database project is coming along. Unfortunately, someone mentioned to C. T. that the delay had something to do with achieving normalization.

“Why is all this normalization stuff so important?” he asks. “The old system worked
OK most of the time, and now you are telling me that we need all these special rules.
Why is this necessary?”


1. How should you respond to C. T.? Write him a brief memo with your views.

Normalization:

Normalizing a database reduces its size and prevents data duplication. It ensures that each piece of data is stored only once.Normalization is important to develop system performance and accuracy. 

Normalization splits huge amount of data in to smaller groupings in order to access the data quickly and efficiently. The main significance of Normalization is to eliminate duplication of data. 

Data integrity can also be maintained. Pick and Shovel Construction Company would have to maintain large amount of database. Normalization technique helps to identify and correct inbuilt problems in a database. Normalization is useful since Pick and Shovel Construction Company would provide.


 2. Assume that the Pick and Shovel’s main entities are its customers, employees,projects, and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned only to one project. Draw an ERD showing those entities.





3. Add cardinality notation to your ERD.




4. Create 3NF table designs.





















































Comments

Post a Comment

Popular posts from this blog

Image
Western Wear Outfitters Situation:   Western Wear is a mail-order firm that offers an extensive selection of casual clothing for men and women. Western Wear plans to launch a new Web site, and the company wants to develop a new set of product codes. Currently, 650 different products exist, with the possibility of adding more in the future. Many products come in various sizes, styles, and colors. The marketing manager asked you to develop an individualized product code that can identify a specific item and its characteristics. Your initial reaction is that it can be done, but the code might be fairly complex. Back in your office, you give the matter some thought. 1.        Design a code scheme that will meet the marketing manager’s stated requirements. Some firms use a straight numeric sequence code, because it is simple and can be assigned automatically by the system. Other firms choose a significant digit code that indicat...
Read more
Image
CASE STUDY Personal Trainer, Inc. Personal Trainer, Inc., owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company is planning an international expansion by opening a new “supercenter” in the Toronto area. Personal Trainer’s president, Cassia Umi, hired an IT consultant, Susan Park, to help develop an information system for the new facility. During the project, Susan will work closely with Gray Lewis, who will manage the new operation. Background:   After evaluating various development strategies, Susan prepared a system requirements document and submitted her recommendations to Cassia Umi, Personal Trainer’s president. During her presentation, Susan discussed several development strategies, including in-house development and outsourcing. She did not feel that a commercial software package would meet Personal Trainer’s needs. Based on her research, Susan felt it would be premature to select a development strategy at t...
Read more