Reference no: EM1318540

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

Explain why all this normalization stuff is so significant?" he asks. "The old system worked “OK” most of time, and now you're telling me we require all these special rules. Why is this essential?"

1) How must you respond to the C. T.? Write him a brief memo along with your views.

2) Suppose that the Pick and Shovel's main entities are it is customers, employees, projects, and equipment. A customer may hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is allocated only to one project. Design an ERD showing those entities.

a) Develop the ERD in MS Visio.