Skip to main content

PICK and SHOVEL CONSTRUCTION

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.

To: C. T. Scott
From: Cirnin Jay
CC: Pick and Shovel Construction Company
Date: April 8, 2018
Subject: Employee Respond

Normalization is the process of reorganizing data structure in an efficient way in designing relational database. It is important to perform the processes of normalization because it eliminates duplicate records, data redundancy and making data consistent across all tables. The advantages gained from using normalization is quite significant while the disadvantages are unavoidable for some cases.

Sincerely yours,
Cirnin Jay

2.) Assume that the Pick and Shovel's main entities are its customer, 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 tbale designs.







Comments

Post a Comment

Popular posts from this blog

PUPPY PALACE

Puppy Palace Situation: Puppy Palace works with TV and movie producers who need dogs that can perform special tricks, such as headstands, somersaults, ladder climbs, and various dog-andpony tricks. Puppy Palace has about 16 dogs and a list of 50 tricks from which to choose. Each dog can perform one or more tricks, and many tricks can be performed by more than one dog. When a dog learns a new trick, the trainer assigns a skill level. Some customers insist on using dogs that score a 10, which is the highest skill level. As an IT consultant, you have been asked to suggest 3NF table designs. You are fairly certain that a M:N relationship exists between dogs and tricks. 1. Draw an ERD for the Puppy Palace information system. 2. Indicate Cardinality 3. Identify all fields you plan to include in the dogs and tricks tables. For example, in the dogs table, you might want breed, size, age, name, and so on. In the tricks table, you might want the trick name and description. You w...
Post a Comment
Read more