{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This preview shows pages 1–19. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Creating a database can belike creating a universe, only more complicated. At least when theuniversewas created, therewas no one around to complain. Michael J. Hernandez Database Design for Mere Mortals Addison Wesley, Boston, 1997
Image of page 2
Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 An Out-of-the-Text Experience!
Image of page 3

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

View Full Document Right Arrow Icon
Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Types of Databases 4 Chapter
Image of page 4
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).
Image of page 5

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

View Full Document Right Arrow Icon
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.
Image of page 6
Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Acct 316 Early Database Models 4 Chapter
Image of page 7

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

View Full Document Right Arrow Icon
Acct 316 Acct 316 Acct 316 Hierarchical Database Model Data is structured hierarchically. Visualizeas an inverted tree. A single table acts as the “root” of the tree. Other tables act as branches flowing from the root.
Image of page 8
Hierarchical Database Model Agents Entertainers Clients Schedule Payments Engagements
Image of page 9

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

View Full Document Right Arrow Icon
Acct 316 Acct 316 Acct 316 Network Database Model Visualizeas an inverted tree. Several inverted trees may share branches, All of which are part of thesame database structure.
Image of page 10
The Network Database Model Agents Clients Entertainers Payments Musical Styles Engagements Represent Manage Schedule Perform Play Make
Image of page 11

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

View Full Document Right Arrow Icon
A Basic Set Structure Relationship Owner Table Member Table Agents Clients Set Structure Represent
Image of page 12
Acct 316 Acct 316 Acct 316 Enter . . . The Relational Database Model Relational Database Relational Databases Relational Databases
Image of page 13

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

View Full Document Right Arrow Icon
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).
Image of page 14
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
Image of page 15

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

View Full Document Right Arrow Icon
Acct 316 Acct 316 Acct 316 Relational Database Model The physical order of the records of fields in a table is completely immaterial. Each record in the table is identified by a field that contains a unique value.
Image of page 16
A Relational Database Model Agents Clients Entertainers Musical Styles Entertainer Styles Engagements
Image of page 17

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

View Full Document Right Arrow Icon
Agent ID First Name Last Name Hire Date Phone 100 Mike Hernandez 05/16/02 333-4444 101 Greg Piercy 10/15/02 444-3333 Client ID Agent ID First Name Last Name …..
Image of page 18
Image of page 19
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern