Pick and Shovel Construction Company

Situation:
Pick and Shovel Construction Company is a multistate 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?”

Questions:

 1. How should you respond to C. T.? Write him a brief memo with your views.
Ans:
Normalization is the approach of organizing the contents of a desk within the database. Normalization is vital to expand device normal overall performance and accuracy. Normalization splits massive quantity of facts in to smaller groupings a good way to get admission to the statistics speedy and correctly. The principle importance of Normalization is to cast off duplication of information. Statistics integrity additionally may be maintained. Select and Shovel creation corporation could must preserve massive amount of database. Normalization approach helps to emerge as privy to and correct in-built troubles in a database. Normalization is beneficial for the cause that pick out and Shovel manufacturing corporation might provide transaction processing in which information adjustments stand up often in a database.
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

Puppy Palace

Image
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 will
Read more
Image
New Century Health Clinic 1. Create an initial entity-relationship diagram for the New Century Health Clinic system Answers will vary depending on the logical design that students prepared during thes ystems analysis phase of the SDLC. Students should understand and apply the guidelines on ERDs and cardinality described in this chapter. The form of the diagram is not important  — systems analysts use various styles, and each CASE tool has its own way of displaying the information. The main objective is to represent the entities and the relationships among them. A sample diagram follows: 2. Normalize your table designs PATIENT  ( PATIENT_NUMBER , PATIENT FIRST NAME, PATIENT LAST NAME, DATE  OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE)   APPOIN TMENT  ( APPT NUMBER , PATIENT NUMBER, APPOINTMENT DATE,  APPOIN TMENT TIME, PROVIDER NUMBER) APPT_SERVICE  ( APPT_SERVICE_NUMBER , APPT NUMBER, CPT CODE, STATUS, FEE, EXPLANATION) PROVIDER  ( PROVIDER_NUMBER ,
Read more