TAILIEUCHUNG - Lecture Accounting information systems - Chapter 4: Relational databases

This chapter explain the importance and advantages of databases, as well as the difference between database systems and file-based legacy systems; explain the difference between logical and physical views of a database; explain fundamental concepts of database systems such as DBMS, schemas, the data dictionary, and DBMS languages;. | Chapter 4 Relational Databases Copyright © 2012 Pearson Education 4-1 Learning Objectives Explain the importance and advantages of databases. Describe the difference between database systems and file-based legacy systems. Explain the difference between logical and physical views of a database. Explain fundamental concepts of database systems such as DBMS, schemas, the data dictionary, and DBMS languages. Describe what a relational database is and how it organizes data. Create a set of well-structured tables to store data in a relational database. Perform simple queries using the Microsoft Access database. Copyright © 2012 Pearson Education 4-2 Data Hierarchy Field Attributes about an entity Record Related group of fields File Related group of records Database Related group of files Copyright © 2012 Pearson Education 4-3 Advantages of Database Systems Data Integration Files are logically combined and made accessible to various systems. Data Sharing With data in one place it is more .

• Kế toán - Kiểm toán
• Accounting information systems
• Hệ thống thông tin kế toán
• Lecture Accounting information systems
• Relational databases
• Data hierarchy
• Database systems
• Accounting information systems
• Lecture Accounting information systems
• Accounting information
• Control information
• Information systems controls
• Information security
• System reliability
• Accounting system
• Systems development life cycle
• Systems design
• Value of information
• Business process
• Business process cycles
• Systems development
• Systems analysis
• Information systems
• Auditing computer
• Auditing process
• Privacy controls
• Processing integrity
• Availability controls
• Financial Accounting
• Principles of financial accounting
• Fundamental system principles
• Accounting systems
• Production cycle
• Human resources management
• General ledger
• AIS development strategies
• Reporting Systems
• Accounting information system
• AIS super system
• Computer accounting
• System security
• The accountant
• Information technology
• Documenting accounting information systems
• Data modeling
• Enterprise resource planning systems
• ERP systems
• Value chain
• Supply chain
• Decision structure
• Control frameworks
• Internal controls
• COBIT framework
• Accounting cycle
• Transaction processing
• Internal control
• Control environment