Class 4 - Lecture Handou

Class 4 Lecture - ACCT361 Click to edit Master subtitle style Class#5 and Class#6 Begin Business Processes Modeling How does this differ from the

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style ACCT 361: Accounting Information Systems Class #5 and Class #6 Begin Business Processes Modeling
Background image of page 1

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

View Full DocumentRight Arrow Icon
REA MODEL with Cardinalities Sell Merchandise to Customer Customer Cashier Inventory (1,1) (1,1) (0,*) (0,*) (1,*) (0,*) Receive Payment Salesperson Cash (1,1) (0,*) (1,1) (0,*) (1,1) (0,*) (1,1) (0,1) Audit Trail Exercise How does this differ from the model we prepared for McKell’s Retail Store? Sale-Inventory
Background image of page 2
SALES table (without a separate table for the sale-inventory *:* relationship): Sales Event # Date Terms of Sale Salesperson ID Customer ID Inventory Item # Quantity Price each 1 2/5 2 10, net 30 4 3654 987 5 2.50 4 3654 785 4 1.75 4 3654 562 15 1.99 2 2/5 2 10, 6 746 998 27 2.95 6 746 624 94 1.05 3 2/5 COD 8 2956 847 18 9.99 3 2/5 COD 8 2956 112 29 5.75 3 2/5 COD 8 2956 413 8 3.00 3 2/5 COD 8 2956 335 57 7.50 Sales table without incorporating the N:N relationship
Background image of page 3

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

View Full DocumentRight Arrow Icon
Sales Event Table Sales Event # Date Terms Salesperson ID Customer 1 2/5 2 10, net 30 4 3654 2 6 746 3 COD 8 2956 ( * : * ) S a l e - I n v e n t o r y T a b l e S a l e s E v e n t # I n v e n t o r y I t e m # I n v e n t o r y Q u a n t i t y P r i c e e a c h 1 9 8 7 5 2 . 5 0 1 7 8 5 4 1 . 7 5 1 5 6 2 1 5 1 . 9 9 2 9 9 8 2 7 2 . 9 5 2 6 2 4 9 4 1 . 0 5 3 8 4 7 1 8 4 9 . 9 9 3 1 1 2 2 9 1 5 . 7 5 3 4 1 3 8 1 6 . 0 0 3 3 3 5 5 7 1 7 . 5 0 Sales event tables that incorporate the N:N relationship
Background image of page 4
Conceptual Modeling Notations (as covered in Chapter 4) n Multiple notations are used to communicate the same conceptual modeling concepts q Similar to people speaking multiple languages n ER Diagram Notation q Portrays entities as rectangles and relationship as diamonds attached by straight lines to the related entities Customer ID # Na me Phon e
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example: Sale IS-MADE-TO Customer n ER Diagram format Customer Sale is made to (0,*) (1,1) Department Employee Assigned to (1,*) (1,1)
Background image of page 6
Different Notations to Represent  Relationships (1,1) (1,*) (0,1) (0,*) = = = =
Background image of page 7

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

View Full DocumentRight Arrow Icon
This is how I want you to complete your  models with notation Master (or Maintenance) Entities: SALESPERSON: SSN , First Name, Last Name, Address . . . CUSTOMER: Customer # , First Name, Last Name, Address . . . ITEM: Item # , Description, BQOH, Unit Price, Unit Cost . . . Event (or Transaction) Entities: SALE: Invoice # , [Customer #], [SSN], date . . . SALE-ITEM: [Invoice # ], [Item # ], quantity sold . . .
Background image of page 8
Let’s practice again with Christopher,  Inc.
Background image of page 9

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

View Full DocumentRight Arrow Icon
Christopher Inc. REA Model Resources Events Agents Sales personnel Customer Inventory Receive customer order Cashier Collect payment Cash Shipping personnel Shipping firm Ship Order (1,*) (1,*) (1,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1)
Background image of page 10
Christopher Inc.  Event Logical Structures - Order Taking CUSTOMER Customer #, Name, Street Address, City, State, Zip, Telephone# Credit Rating, Credit Limit RECEIVE CUSTOMER ORDER Sales Order #, [Customer #], [Customer Order Date, Time, Instructions, order EMPLOYEE , Employee #, Name, Address Telephone #, BirthDate Start date, Salary, ORDER/INVENTORY [Sales Order #], [Inventory item #],
Background image of page 11

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

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

This note was uploaded on 02/05/2011 for the course SOM 492 taught by Professor Minecar during the Spring '11 term at George Mason.

Page1 / 31

Class 4 Lecture - ACCT361 Click to edit Master subtitle style Class#5 and Class#6 Begin Business Processes Modeling How does this differ from the

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

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