TAILIEUCHUNG - Lecture Accounting information systems (13/e) – Chapter 4: Relational databases

After studying this chapter, you should be able to: 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;. | Relational Databases Chapter 4 4-1 Learning Objectives Explain the importance and advantages of databases, as well as the difference between database 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 properly store data in a relational database. Perform simple queries using the Microsoft Access database. 4-2 What Is a Database? Efficiently and centrally coordinates information for a related group of files A file is a related group of records A record is a related group of fields A field is a specific attribute of interest for the entity (record) 4-3 Advantages of Databases Data is integrated and easy to share Minimize data redundancy Data is independent of the programs that use the data Data is easily accessed for

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.