TAILIEUCHUNG - Lecture Accounting information systems (13/e) – Chapter 17: Database design using the REA data model

After studying this chapter, you should be able to: Discuss the steps for designing and implementing a database system, use the REA data model to design an AIS database, draw an REA diagram of an AIS database, read an REA diagram and explain what it reveals about the business activities and policies of the organization being modeled. | Database Design Using the REA Data Model Chapter 17 17-1 Learning Objectives Discuss the steps for designing and implementing a database system. Use the REA data model to design an AIS database. Draw an REA diagram of an AIS database. Read an REA diagram and explain what it reveals about the business activities and policies of the organization being modeled. 17-2 Database Design Process 17-3 Data Modeling Process of defining a database so that it faithfully represents all aspects of the organization, including its interactions with the external environment. Entity-relationship (E-R) diagrams REA data model 17-4 REA Modeling Resources Things that have economic value to the organization (., inventory, cash) Events Various business activities that management wants to collect information on Agents People and organizations that participate in events (both internal (., employees) and external (., customers/vendors) to the organization) 17-5 REA Basic Template 17-6 Creating an REA Model Identify relevant events Give-get exchange (economic duality) Identify resources and agents Resource reduced in give event Resource acquired in get event Determine cardinalities of relationships Nature of the relationship between the two entities 17-7 Cardinality Notation Methods Graphical symbols Graphical symbols represent minimum–maximum cardinalities (Min, Max) notation Pairs representing the minimum–maximum cardinalities UML notation Pairs representing the minimum–maximum cardinalities Maximums only (Microsoft Access) 17-8 Key Terms Data modeling Entity-relationship (E-R) diagram REA data model Resources Events Agents Cardinalities Minimum cardinality Maximum cardinality One-to-One (1:1) relationship One-to-Many (1:N) relationship Many-Many (M:N) relationship 17-9

• Kế toán - Kiểm toán
• The REA data model
• Accounting information systems
• Lecture Accounting information systems
• Hệ thống thông tin kế toán
• Database design
• Database design process
• Accounting information systems
• Lecture Accounting information systems
• REA data model
• System analysis process
• Database system
• Lecture Database system
• Relational databases
• Relational database design
• Database Systems
• Overview of Database Design Process
• Indexing Structures for Files
• Data Storage
• Disk Storage Devices
• Lecture Database Systems
• ER model
• Fundamentals of database systems
• ER model concepts
• ER diagrams
• Database application
• Entity Relationship Model
• ER Model Concepts
• Alternative diagrammatic notations
• Lecture Database management systems
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Database management systems
• Database application development process
• Data flow diagrams
• Example COMPANY Database
• ER Diagram
• Lecture Distributed Database Management Systems
• Distributed Database Management Systems
• Bài giảng Hệ quản trị cơ sở dữ liệu phân tán
• Global schema architecture
• Global data dictionary
• Top down design process
• Enterprise information systems
• Lecture Enterprise information systems
• Business process
• REA enterprise ontology