intTypePromotion=1
zunia.vn Tuyển sinh 2024 dành cho Gen-Z zunia.vn zunia.vn
ADSENSE
 » 
 » 

Bài giảng Hệ thống thông tin kế toán: Chapter 5 - ThS. Vũ Quốc Thông

Chia sẻ: Gió Biển | Ngày: | Loại File: PDF | Số trang:15

Thêm vào BST
Báo xấu
59
lượt xem 4
download
 
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

Bài giảng "Hệ thống thông tin kế toán - Chapter 5: Relational databases" presentation of content: Describe the basic of database, explain what a relational database is and how it organizes data, perform simple queries using the Microsoft Access database,... Invite you to reference.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Bài giảng Hệ thống thông tin kế toán: Chapter 5 - ThS. Vũ Quốc Thông

  1. Vũ Quốc Thông 2/27/2015 HO CHI MINH CITY OPEN UNIVERSITY ACCOUNTING – AUDITING FACULTY ACCOUNTING INFORMATION SYSTEM RELATIONAL DATABASES Lecturer: Vũ Quốc Thông Chapter 5 Learning Objectives  Describe the basic of database  Explain what a relational database is and how it organizes data  Perform simple queries using the Microsoft Access database  Describe database systems and the future of accounting 5-2 1
  2. Vũ Quốc Thông 2/27/2015 The Basic of Database 5-3 Data Hierarchy  Field (column)  Attributes about an entity  Record (row / tuple)  Related group of fields  File (table)  Related group of records  Database Picture?  Related group of files 5-4 2
  3. Vũ Quốc Thông 2/27/2015 In short… ? ? ? 5 File-system v.s Database system 5-6 3
  4. Vũ Quốc Thông 2/27/2015 Limitations of File-based Systems  Separation and isolation of data  Each program maintains its own set of data.  Users of one program may be unaware of potentially useful data held by other programs.  Duplication of data  Same data is held by different programs.  Wasted space and potentially different values and/or different formats for the same item. 5-7 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 easily accessed by authorized users.  Minimizing Data Redundancy and Data Inconsistency  Eliminates the same data being stored in multiple files, thus reducing inconsistency in multiple versions of the same data.  Cross-Functional Analysis  Relationships between data from various organizational departments can be more easily combined. 5-8 4
  5. Vũ Quốc Thông 2/27/2015 Example of Database system 4-9 Relational Database 5-10 5
  6. Vũ Quốc Thông 2/27/2015 Relational Database  Relational data model represents the conceptual and external level schemas as if data are stored in tables.  Table (a File)  Each row (or a tuple) contains data about one instance of an entity.  This is equivalent to a record  Each column contains data about one attribute of an entity.  This is equivalent to a field 5-11 A Relational Table Row (Record) Each row contains multiple attributes describing an instance Column (Field) of the entity. In this case, inventory. 5-12 6
  7. Vũ Quốc Thông 2/27/2015 Attributes / Keys  Primary Key  An attribute or combination of attributes that can be used to uniquely identify a specific row (record) in a table.  Foreign Key  An attribute in one table that is a primary key in another table. Used to link the two tables 5-13 A Relational Table with KEYS Examine: Chap05_AcctSalesRDB.accdb 5-14 7
  8. Vũ Quốc Thông 2/27/2015 Design Requirements for Relational Database 1. Every column must be single valued. 2. Primary keys must contain data (not null). 3. Foreign keys must contain the same data as the primary key in another table. 4. All other attributes must identify a characteristic of the table identified by the primary key. 5-15 Queries with MS relational database 5-16 8
  9. Vũ Quốc Thông 2/27/2015 DBMS Languages  Data Definition Language (DDL)  Builds the data dictionary  Creates the database  Describes the subschema  Specifies record or field security constraints  Data Manipulation Language (DML)  Changes the content in the database  Updates, insertions, and deletions  Structure (Data) Query Language (SQL / DQL)  Enables the retrieval, sorting, and display of data from the database Practice with Chap05_AcctSalesRDB.accdb 5-17 Microsoft Access Query #1 5-18 9
  10. Vũ Quốc Thông 2/27/2015 Microsoft Access Query #2 5-19 Microsoft Access Query #3 5-20 10
  11. Vũ Quốc Thông 2/27/2015 Microsoft Access Query #4 5-21 Microsoft Access Query #5 5-22 11
  12. Vũ Quốc Thông 2/27/2015 Database systems and the future of Accounting 5-23 Database and the future of Accounting  Ad-hoc queries to provide information for decision-making  Financial information is no longer available only in predefined format  Multiple views of the same underlying phenomenon (e.g. managers will no longer be forced to look at data in the ways predefined by accountants)  Capable of integrating financial and operational data (e.g. customer satisfaction data could be retrieved from DB giving managers more information for decision making) Relational database increase the use and value of accounting information. Accountant must understand database system to use AIS effectively! 5-24 12
  13. Vũ Quốc Thông 2/27/2015 Transform Raw Data into Information 5-25 Transform Raw Data into Information 5-26 13
  14. Vũ Quốc Thông 2/27/2015 Transform Raw Data into Information Table format 5-27 Transform Raw Data into Information Graphic format 5-28 14
  15. Vũ Quốc Thông 2/27/2015 More on reading and practice  Reading on textbook  Chapter 4 (p. 107 – 109, p. 112 - 125) Doing homework on paper  Discussion questions  Question 4.2, 4.3 and 4.7 (p. 128)  Chapter quiz (focus on relevant parts of the lecture)  Quiz of chapter 4 (p. 126, 127) 5-29 15
ADSENSE

CÓ THỂ BẠN MUỐN DOWNLOAD

THÔNG TIN
TRỢ GIÚP
HỖ TRỢ KHÁCH HÀNG
Theo dõi chúng tôi

Chịu trách nhiệm nội dung:

Nguyễn Công Hà - Giám đốc Công ty TNHH TÀI LIỆU TRỰC TUYẾN VI NA

LIÊN HỆ

Địa chỉ: P402, 54A Nơ Trang Long, Phường 14, Q.Bình Thạnh, TP.HCM

Hotline: 093 303 0098

Email: support@tailieu.vn

Giấy phép Mạng Xã Hội số: 670/GP-BTTTT cấp ngày 30/11/2015 Copyright © 2022-2032 TaiLieu.VN. All rights reserved.

 

Đồng bộ tài khoản
2=>2