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 .

• Cơ sở dữ liệu
• Database System
• Lecture Database Systems
• Relational databases
• Database design
• Data conversion
• Fact finding techniques
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database system architectures
• Relational database design
• Lecture Database System
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Database architecture
• Database approach
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases