Exam 3 Flashcards
(102 cards)
Which type, view-driven or event-driven, is described as a traditional accounting system that may incorporate some forms of IT (information technology), but its defining characteristic is its focus on the general purpose financial statements?
View-Driven
Which type, view-driven or event-driven, is described as being more complex and defined by its focus on business processes?
Event-Driven
What are 5 key problems with view-driven systems?
Focus on a very small group of important, recordable in AIS with DR and CR, business events; Periodic, outdated; Only captures limited data from transactions; Limit decision making information; Internal Controls often protective and expensive.
What do Event-driven systems do that view-driven do not?
Capture more data from individual transactions, Organize data to be accessible and understood by variety of people; Can answer questions about inventory transactions
What is the name of the documentation technique designed to facilitate the design and implementation of event-driven AIS?
REA Modeling
What does the REA in REA Modeling stand for?
Resources, Events, and Agents
Name the 3 categories of “events”
Operating, Information and Decision/Management Events
Which type of “events” focus on activities involved with providing goods and services to customers?
Operating Events
Which type of “events” deal with preparing financial statements or updating accounting records?
Information Events
Which type of “events” involve human decision making?
Decision/Management Events
What types of events are captured in the REA Model?
Operating and Information Events
Which of the 3 elements of an REA model have people involved in the information system and where are they located on an REA Model?
Agents, Right
What type of agent includes employees in all departments?
Internal Agent
What type of agent includes customers, vendors, and other stakeholders?
External Agent
Which of the 3 elements of an REA model include things agents need to complete the events and where are they located on an REA Model?
Resources, Left
Which of the 3 elements of an REA model appear in the middle?
Events
In an REA Model, what tells an accounting professional about the relationship between its elements?
Cardinalities
When Establishing cardinalities, what ?’s must be asked?
For each inventory item, what is the minimum/maximum number of Order events involved? For each Order event, what is the minimum/maximum number of inventory items involved?
Which normal form eliminate repeating groups; each field contains single value, and no dupes exist
1st Normal Form - 1NF
Which normal form eliminates redundant data; accomplished by creating junction tables to establish data relationships
2nd Normal Form - 2NF
Which normal form eliminates columns not dependant on primary key
3rd Normal Form - 3NF
What is Referential Integrity?
ensures relationships are maintained; any value in a foreign key column must be present in a primary key column of related table
For REA modeling, when the maximum cardinalities between two elements are one and many, what must we include?
the primary key from the “one side” in the table on the “many side.”
When the maximum cardinalities are many and many, what do we need to do?
we need a separate table (junction) to store the relationship