tailieunhanh - Lecture Database Systems - Lecture 21

After completing this chapter, students will be able to: Overview of Relational Data Model, ER and EER-to-Relational mapping, relational algebra. Inviting you to refer lecture for more information. | CSC271 Database Systems Lecture # 21 Summary: Previous Lecture Phases of database SDLC Prototyping (optional) Implementation Data conversion and loading Testing Operational maintenance Fact-finding techniques Examining documentation Interviewing Observing the organization in operation Research Questionnaires DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome: Database Planning Mission statement for DreamHome Interviews with director or appropriate staff Open-ended questions ‘What is the purpose of your company?’ ‘Why do you feel that you need a database?’ ‘How do you know that a database will solve your problem?’ DreamHome: Database Planning Mission objectives for DreamHome Interviews with staff members with different roles Open-ended questions ‘‘What is your job description?’ ‘What kinds of tasks do you perform in a typical day?’ ‘What kinds of data do you work with?’ ‘What types of reports do you use?’ ‘What types of things do you need to keep track of?’ ‘What service does your company provide to your customers?’ DreamHome: Mission Objectives DreamHome: System Definition To define the scope and boundary of the database system and its major user views DreamHome: System Definition DreamHome: Req. Coll. & Analysis Users’ requirements specification The data to be held in the database and how the data is to be used ‘What type of data do you need to hold on X?’ ‘What sorts of things do you do with the data on X?’ DreamHome: Req. Coll. & Analysis Managing User Views How do we decide whether to use the centralized or view integration approach, or a combination of both to manage multiple user views? One way to help make a decision is to examine the overlap in the data used between the user views identified during the system definition stage Based on this analysis, we use the centralized approach to first merge the requirements for the Director and Manager user views | CSC271 Database Systems Lecture # 21 Summary: Previous Lecture Phases of database SDLC Prototyping (optional) Implementation Data conversion and loading Testing Operational maintenance Fact-finding techniques Examining documentation Interviewing Observing the organization in operation Research Questionnaires DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome Case Study DreamHome: Database Planning Mission statement for DreamHome Interviews with director or appropriate staff Open-ended questions ‘What is the purpose of your company?’ ‘Why do you feel that you need a database?’ ‘How do you know that a database will solve your problem?’ DreamHome: Database Planning Mission objectives for DreamHome Interviews with staff members with different roles Open-ended questions ‘‘What is your job description?’ ‘What kinds of tasks do you perform in a typical day?’ ‘What kinds of data do you work with?’ ‘What .