TAILIEUCHUNG - Instructor Notes Module 6: Deriving a Physical Data Design

Students should fill in the blank grids in the activity manual with the tables, fields, and data types they identify. More grids are available than students will probably need, and each grid has more rows than they will probably need. Tell students that they should not feel obliged to fill in all the rows of all the grids. | Instructor Notes Module 6 Deriving a Physical Data Design Introduction Presentation This module describes how data is stored the relational model and how to 75 Minutes optimize database systems. Activities After completing this module students will be able to 55 Minutes Derive a physical data design for tables and fields from a logical data design. Analyze data usage characteristics to optimize a physical data design. Determine methods for implementing relationships in a physical data design. Identify different optimization techniques. Determine the proper criteria for optimizing a physical data design. Materials and Preparation This section provides you with the materials and preparation needed to teach this module. Materials To teach this module you will need the following materials Microsoft PowerPoint file Module 6 Deriving a Physical Data Design Activity Translating the Logical Data Design Activity Optimizing a Physical Data Design Preparation To prepare for this module you should Read all materials for this module. Complete the activities. 2 Instructor Notes Module 6 Deriving a Physical Data Design Activities Activity Translating the Logical Data Design In this activity students will evaluate the logical design for a portion of the Ferguson and Bardell Inc. case study. From this design students will determine the appropriate tables fields and data types. Students should fill in the blank grids in the activity manual with the tables fields and data types they identify. More grids are available than students will probably need and each grid has more rows than they will probably need. Tell students that they should not feel obliged to fill in all the rows of all the grids. After the activity lead a class discussion so that students can compare results. After completing this activity students will be able to Evaluate a logical data design. Determine the appropriate data types for columns in a table. Produce a physical data design. To .

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.