Đang chuẩn bị liên kết để tải về tài liệu:
Activity 6.1: Translating the Logical Data Design

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

In this activity, you will evaluate the logical design for part of the solution developed for the Ferguson and Bardell, Inc. case study. From this design, you will determine the tables, columns, data types, and keys that are appropriate for the solution | Activity 6.1 Translating the Logical Data Design In this activity you will evaluate the logical design for part of the solution developed for the Ferguson and Bardell Inc. case study. From this design you will determine the tables columns data types and keys that are appropriate for the solution. Objectives After completing this activity you will be able to Evaluate a logical data design. Determine the appropriate data types for columns in a table. Produce a physical data design. Before You Begin This activity is completed individually with a class discussion to follow. Time to complete this activity 30 minutes 30 Activity 6.1 Translating the Logical Data Design Exercise 1 Deriving a Physical Data Design from a Logical Data Design In this exercise you will use the logical data design presented below and derive a physical data design. This picture is file v05_1609a_act52-answer.vsd or .bmp Contracts With Employee Timesheet Invoice EmployeeID PK TimesheetID PK InvoiceID PK TypeID FK FirstName MiddleInitial LastName Address1 Address2 City State Zip SSN E-Mail Salary BillableRate 1 ClientID FK EmployeeID FK JobID FK TaskID FK Date - Expenses TotalHours BillableHours Description 0. 1 Is Issued Vehicle 0. ClientID FK TimesheetID FK Date Amount Work Description 0.rc 1.rc TypeDesc Is Classified As 1 0. -----Completes EmployeeType TypeID PK 1 Contract VehicleID PK EmployeeID FK Make Model VIN Year BeginMileage EndMileage 1 Can Have VehicleMaint MaintID PK VehicleID FK MaintenanceCost __ MaintenanceDesc _ MaintenanceDate 0-- MaintenanceMiles Activity 6.1 Translating the Logical Data Design 31 Derive the physical data design 1. Using the following table templates translate each entity into a table. You can have more tables than entities and you might not need all the templates. 2. For each table translate each attribute into a field. You can have more fields than attributes and you might not need all the rows in the templates. 3. Select a data type for each field. 4. Label