tailieunhanh - Activity 9.4: Identifying Data Access Requirements

Tham khảo tài liệu 'activity : identifying data access requirements', công nghệ thông tin, tin học văn phòng phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Activity Identifying Data Access Requirements In this activity you will first identify the optimal data access method to use in a given situation. Next you will analyze the data access method selection in a scenario. Objectives After completing this activity you will be able to Identify the appropriate data access method for a given set of requirements and constraints. Before You Begin This activity includes both small group tasks and class discussion. Prerequisites There are no prerequisites for this activity. Materials There are no materials for this activity. Time to complete this activity 15 minutes followed by a 10 minute discussion. 74 Activity Identifying Data Access Requirements Exercise 1 Identifying a Data Access Method for a Scenario 10 minutes Identify data access requirements 1. Participate in small groups as assigned by the instructor. 2. Read each scenario below. 3. Identify which data access method best meets the needs of the scenario. 4. Write your answers below. After completing the above steps you will discuss your responses with the class. The instructor will write the class consensus on a flip chart. Scenarios A All data for a new order entry system is going to be stored in Microsoft SQL Server and accessed by Microsoft Excel for querying and by the Web system for additional lookups. All data is entered through the Web. New orders are also sent by sending e-mail to the appropriate sales representatives. B A custom application that requires e-mail to be generated and copies to be stored in a repository for easy access in the future. Solution A B Activity Identifying Data Access Requirements 75 Exercise 2 Analyzing Technology Selection 5 minutes Analyze technology selection 1. Participate in small groups as assigned by the instructor. 2. Validate the feasibility of the solution given in the scenario. 3. Make any comments in the space below. After completing the above steps you will discuss your responses with the class. The instructor