Question: 1. How should you respond to C. T.? Write him a brief memo with your views. 2. Assume that the Pick and Shovels main entities
1. How should you respond to C. T.? Write him a brief memo with your views.
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. Create 3NF table designs.
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.
Step by Step Solution
3.23 Rating (161 Votes )
There are 3 Steps involved in it
1 People should provide a brief description of normalization that managers and other nonIT staff can understand They should point out that flaws in th... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
200-B-M-A-C-S-D (491).docx
120 KBs Word File
Study Help