chap5 - Studying Accounting Information Systems Business...

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

View Full Document Right Arrow Icon
1 Studying Accounting Information Systems Business Strategy AIS Applications IT Environment Business Processes  Understanding and designing  • Data • Queries and reports • Input forms Part 2
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Databases Comprehensive collection of related data o Database Management System (DBMS) Enables storage and retrieval of data o In a relational database, data stored in tables Relationships = matching attributes Equipment# Rental_Date Customer# 1235 05/11/06 5501 1530 05/17/06 5501 1235 05/22/06 5502 Customer Customer# Customer Name Customer Address Customer Phone# Rental_Agreement Equipment# Rental_Date Customer# 1 m
Background image of page 2
3 Data Base Design Options:     One Uniform Table Student ID# 999999999 999999999 999999999 123456789 123456789 Course Unique # 00071 00150 00179 00071 00153 Student Name Bill Bixby Bill Bixby Bill Bixby Lana Turner Lana Turner Course Description AMIS 531 ENGL 100 HIST 203 AMIS 531 MATH 102
Background image of page 3

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

View Full DocumentRight Arrow Icon
4   Data Base Design Options:     Vary the Number of Columns Student ID# 999999999 123456789 Student Name Bill Bixby Lana Turner Course  Unique# 00071 00071 Course  Unique# 00150 00153 Course  Unique# 00179
Background image of page 4
5 Data Base Design Options:   Use Multiple Tables Student ID# 999999999 123456789 Student Name Bill Bixby Lana Turner Course  Unique# 00071 00150 00153 00179 Course  Description AMIS 531 ENGL 100 MATH 102 HIST 203 Student Table Course Table Student  ID# 999999999 999999999 999999999 123456789 123456789 Course  Unique# 00071 00150 00179 00071 00153 Enrollment Table
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Identifying the Need for Transactions Tables 1. Determine the events in the process (again) 2. Exclude events that are not recorded in system 3. Exclude query and reporting events These data have already been recorded; we’re just using them 4. Exclude maintenance events Usually not relevant for transactions tables; for reference fields in master table There are examples where both a transaction record and a master record are created o e.g. open a bank account with initial deposit
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/04/2012 for the course H 531 taught by Professor Dr.johnbutler during the Spring '11 term at Ohio State.

Page1 / 20

chap5 - Studying Accounting Information Systems Business...

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

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