Chapter 4 - Relational databases. This chapter explain the difference between database and file-based legacy systems, describe what a relational database is and how it organizes data, explain the difference between logical and physical views of a database, create a set of well-structured tables to properly store data in a relational database. | Accounting Information Systems 9th Edition Marshall B. Romney Paul John Steinbart ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Relational Databases Chapter 4 ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Learning Objectives Explain the difference between database and file-based legacy systems. Describe what a relational database is and how it organizes data. Explain the difference between logical and physical views of a database. Create a set of well-structured tables to properly store data in a relational database. 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Introduction Ashton Fleming, the accountant for S&S, believes that the best way to provide Susan Gonzalez and Scott Parry with easy access to the information they need to run their business is to build S&S’s new AIS as a database system. 4- ©2003 Prentice Hall Business | Accounting Information Systems 9th Edition Marshall B. Romney Paul John Steinbart ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Relational Databases Chapter 4 ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Learning Objectives Explain the difference between database and file-based legacy systems. Describe what a relational database is and how it organizes data. Explain the difference between logical and physical views of a database. Create a set of well-structured tables to properly store data in a relational database. 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Introduction Ashton Fleming, the accountant for S&S, believes that the best way to provide Susan Gonzalez and Scott Parry with easy access to the information they need to run their business is to build S&S’s new AIS as a database system. 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Introduction Ashton decides to prepare a brief report for them addressing the following questions: What is a database system? What is a relational database system? How do you design a relational database? 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Introduction This chapter explains what a database is and how it differs from a file-oriented system. It also describes the structure of a relational database system. The chapter concludes by discussing the basic steps involved in designing a database. 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Learning Objective 1 Explain the difference between database and file-based legacy systems. 4- ©2003 Prentice Hall Business Publishing, Accounting Information Systems, 9/e, Romney/Steinbart Types of Files Two basic types of files are used to store data. The master .
