Chpt_04 - Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct...

Info iconThis preview shows pages 1–17. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Relational Databases 4 UAA ACCT 316 Accounting Information Systems Dr. Fred Barbee Chapter Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Creating a database can be like creating a universe, only more complicated. At least when the universe was created, there was no one around to complain. Michael J. Hernandez Database Design for Mere Mortals Addison Wesley, Boston, 1997 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 An Out-of-the-Text Experience! Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Types of Databases 4 Chapter Acct 316 Acct 316 Acct 316 Types of Databases Operational Database Used whenever there is a need to collect, maintain, and modify data. Stores dynamic data (i.e., the data changes constantly and reflects up-to-the-minute information). Acct 316 Acct 316 Acct 316 Types of Databases Analytical Database Used to store and track historical and time- dependent data.. Stores static data that is never (or rarely) modified. Information is applicable to a specific point in time. Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Early Database Models 4 Chapter Acct 316 Acct 316 Acct 316 Hierarchical Database Model Data is structured hierarchically. Visualize as an inverted tree. A single table acts as the root of the tree. Other tables act as branches flowing from the root. Hierarchical Database Model Agents Entertainers Clients Schedule Payments Engagements Acct 316 Acct 316 Acct 316 Network Database Model Visualize as an inverted tree. Several inverted trees may share branches, All of which are part of the same database structure. The Network Database Model Agents Clients Entertainers Payments Musical Styles Engagements Represent Manage Schedule Perform Play Make A Basic Set Structure Relationship Owner Table Member Table Agents Clients Set Structure Represent Acct 316 Acct 316 Acct 316 Enter . . . The Relational Database Model Relational Database R e l a t i o n a l D a t a b a s e s R e l a t i o n a l D a t a b a s e s Acct 316 Acct 316 Acct 316 Relational Database Model Data is stored in relations, which are perceived by the user as tables. Each relation is composed of tuples (records) and attributes (fields). Fundamental Data Storage Concepts and Definitions Accounts Receivable File 2 Entities 2 Records Attributes Customer Customer Credit number name Address limit Balance Data values 301 ABC Co. Box 5 1,000 400 555 XYZ Co. Box 9 6,000 2,000 Individual fields Acct 316 Acct 316 Acct 316 Relational Database Model The physical order of the records of fields in a table is completely immaterial....
View Full Document

This note was uploaded on 11/15/2011 for the course I SYS 201 taught by Professor Meservy during the Winter '11 term at BYU.

Page1 / 103

Chpt_04 - Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct...

This preview shows document pages 1 - 17. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online