TAILIEUCHUNG - Lecture Systems Analysis and Design in a Changing World (3rd Edition) - Chapter 13: Designing databases

Learning objectives in this chapter: Describe the differences and similarities between relational and object-oriented database management systems, design a relational database schema based on an entity-relationship diagram, design an object database schema based on a class diagram,. | Chapter 13: Designing Databases Systems Analysis and Design in a Changing World, 3rd Edition Learning Objectives Describe the differences and similarities between relational and object-oriented database management systems Design a relational database schema based on an entity-relationship diagram Design an object database schema based on a class diagram Learning Objectives (continued) Design a relational schema to implement a hybrid object-relational database Describe the different architectural models for distributed databases Overview This chapter describes design of relational and OO data models Developers transform conceptual data models into detailed database models Entity-relationship diagrams (ERDs) for traditional analysis Class diagrams for object-oriented (OO) analysis Detailed database models are implemented with database management system (DBMS) Databases and Database Management Systems Databases (DB) – integrated collections of stored data that are centrally managed and controlled Database management system (DBMS) – system software that manages and controls access to database Databases described by a schema: description of structure, content, and access controls Components of a DB and DBMS DBMS Important Capabilities Simultaneous access by multiple users and applications Access to data without application programs (via a query language) Managing organizational data with uniform access and content controls Database Models Impacted by technology changes since 1960s Model Types Hierarchical Network Relational Object-oriented Most current systems use relational or object-oriented data models Relational Databases Relational database management system (RDBMS) organizes data into tables or relations Tables are two dimensional data structures Tuples: rows or records Fields: columns or attributes Tables have primary key field(s) which can be used to identify unique records Keys relate tables to each other Partial Display of .

• Kỹ thuật lập trình
• Systems Analysis
• Design in a Changing World
• Designing databases
• OO data models
• Database management system
• Relational databases
• 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
• 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
• Database design
• Data architecture
• Output design
• Internal outputs
• Input design
• Input implementation methods
• User interface design
• Human engineering guidelines
• Object oriented design
• Design classes