Activity 6.2: Optimizing a Physical Data Design

This activity requires the use of the optimization techniques discussed in this module. You will consider ways to optimize a physical data design for insertions, updates, and deletions, as well as any nonfunctional requirements specified by the activity s scenario. | Activity Optimizing a Physical Data Design This activity requires the use of the optimization techniques discussed in this module. You will consider ways to optimize a physical data design for insertions updates and deletions as well as any nonfunctional requirements specified by the activity s scenario. Objectives After completing this activity you will be able to Identify where data designs can potentially be optimized. Determine the appropriate optimization technique. Before You Begin This activity is completed individually with a class discussion to follow. Time to complete this activity 25 minutes 36 Activity Optimizing a Physical Data Design Exercise 1 Determining Areas for Optimization In this exercise you will evaluate the logical data design presented in the following illustration and determine areas in which the physical data design could potentially be optimized. Bitmap found in file or .bmp Contracts With Employee EmployeelD PK Int TypelD FK N Int FirstName VChar 25 Middlelnitial VChar 2 LastName VChar 25 Addressl VChar 40 Address2 VChar 40 City VChar 30 State VChar 20 Zip VChar 10 SSN VChar 9 E-Mail VChar 50 Salary Currency BillableRate Currency 1 Timesheet 0--TO -Completes- 1 TimesheetID PK Dlnt ClientID FK N DInt EmployeeID FK N lnt JobID FK N Dlnt TaskID FK N Dlnt Date Date Expenses Currency TotalHours Float BillableHours Float Description VChar 255 Contract ContractID PK DInt ClientID FK DInt EmployeeID FK Int StartDate Date EndDate Date Description VChar 255 Invoice InvoiceID PK DInt ClientID FK N DInt TimesheetID FK N DInt Date Date Amount Currency Work Description VChar 255 1 1 EmployeeType TypelD PK Int Is Issued 1 1 Is Made From Is Sent To Is Classified As TypeDesc VChar 255 11 -------------------- Bills Time To -----Bills Time To Task TO Purchases 1 Client ClientID PK DInt Name VChar 60 Address1 VChar 40 Address2 VChar 40 City VChar 30 State VChar 20 Zip VChar 10 1 VehicleLink VehicleID .