tailieunhanh - Lecture Systems analysis and design methods (7/e): Chapter 14 – Whitten, Bentley

Data storage is a critical component of most information systems. This chapter teaches the design and construction of physical databases. You will know that you have mastered the tools and techniques of database design when you can: Compare and contrast conventional files and modern, relational databases; define and give examples of fields, records, files, and databases; describe a modern data architecture that includes files, operational databases, data warehouses, personal databases, and work group databases;. | Chapter 14 Database Design Chapter 14 – Database Design Objectives Compare and contrast conventional files and modern, relational databases. Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, personal databases, and work group databases. Compare roles of systems analyst, database administrator, and data administrator. Describe architecture of database management system Describe how a relational database implements entities, attributes, and relationships from a logical data model. Transform a logical data model into a physical, relational database schema. Generate SQL to create the database structure in a schema. 14- Chapter 14 – Database Design 14- Chapter 14 – Database Design Conventional Files versus the Database File – a collection of similar records. Files are unrelated to each other except in the code of an application program. Data storage is built around the applications | Chapter 14 Database Design Chapter 14 – Database Design Objectives Compare and contrast conventional files and modern, relational databases. Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, personal databases, and work group databases. Compare roles of systems analyst, database administrator, and data administrator. Describe architecture of database management system Describe how a relational database implements entities, attributes, and relationships from a logical data model. Transform a logical data model into a physical, relational database schema. Generate SQL to create the database structure in a schema. 14- Chapter 14 – Database Design 14- Chapter 14 – Database Design Conventional Files versus the Database File – a collection of similar records. Files are unrelated to each other except in the code of an application program. Data storage is built around the applications that use the files. Database – a collection of interrelated files Records in one file (or table) are physically related to records in another file (or table). Applications are built around the integrated database 14- Chapter 14 – Database Design Files versus Database 14- Chapter 14 – Database Design Pros and Cons of Conventional Files Pros Easy to design because of their single-application focus Excellent performance due to optimized organization for a single application Cons Harder to adapt to sharing across applications Harder to adapt to new requirements Need to duplicate attributes in several files. 14- Chapter 14 – Database Design Pros and Cons of Databases Pros Data independence from applications increases adaptability and flexibility Superior scalability Ability to share data across applications Less, and controlled redundancy (total non-redundancy is not achievable) Cons More complex than file technology Somewhat slower performance Investment in DBMS and database

• Kỹ thuật lập trình
• Systems analysis
• Design methods
• Database design
• Phân tích hệ thống
• Thiết kế hệ thống
• Conventional files
• Information systems
• Systems design
• Introduction to systems analysis and design
• Model driven analysis
• Accounting information systems
• Hệ thống thông tin kế toán
• Lecture Accounting information systems
• Systems development
• Systems development life cycle
• Analysis modeling
• Design modeling
• Systems development methodologies
• Unified process
• Object oriented analysis
• Object modeling
• Feasibility analysis
• The system proposal
• System development
• Information systems development
• Model driven strategy
• Systems construction
• Implementation phase
• Accounting information systems
• Lecture Accounting information systems
• Systems Analysis and Design
• Assuming the Role of the Systems Analyst
• Integrating New Technologies into Traditional Systems
• Web Systems
• Wireless Systems
• Open Source Software
• Design in a Changing World
• Types of information systems
• Internal system users
• Business process redesign
• Project management
• Process management
• Fact finding techniques
• Requirements discovery
• Modeling system requirements
• Use case modeling
• Data modeling
• Entity relationship diagram
• Process modeling
• Application architecture
• Physical data flow diagram
• Data architecture
• Output design
• Internal outputs
• Input design
• Input implementation methods
• User interface design
• Human engineering guidelines
• Object oriented design
• Design classes