Chapter 9



Apply Your Knowledge


April 8,2018

A. 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?”

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

Answer:
            Normalization is very important for it is a process of avoiding problems in data design. Also, it is a process of reducing redundancy and multivalued fields. Pick and Shovel Construction Company would provide online transaction processing where data modification occur frequently 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.

Answer:

















3. Add cardinality notation to your ERD.

Answer:


4. Create 3NF table designs.

Answer:


CustomerID
CustomerName
EmployeeID
ProjectCode
EquipmentCode

EmployeeID
EmployeeName

ProjectCode
ProjectName

EquipmentCode
EquipmentName






Comments

Post a Comment

Popular posts from this blog

Reflection Paper

REFLECTION PAPER IN Commencement Address of Steve Jobs First story is about connecting the dots. Steve jobs says that it is impossible to connect the dots when looking forward, yet it is possible to connect when looking backward. So he reminisce his past and connect all the event happened because it is the answer on who he is right now. Second story is about love and loss. Steve found his self loving what he is doing. In his early age he find love in building his own name and company. He and Woz started Apple without having any knowledge in a business world and became bigger. When Apple became bigger Steve and Woz hire someone that has the knowledge in the business but the business is falling out, so Steve got fired on his own business. Steve never doubt his capability in discovering new things. In years later he build the company name NeXt and Pixar and eventually he met his lovely wife Laurence. Third story is about death. In successful years of Steve Jobs a painful event
Read more

Acticity 1

Image
I agree with the result given by the 16Personalities Test, it stated that I am a defender. Though I am a conservative type of person I can protect myself and others. Sometimes I am more self centered but I care to others. And I am helpful when someone needed my help.
Read more