Problem 9-17 - Chapter 9 Page 38? 17. a. and b. Rejected...

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Chapter 9 Page 38? 17. a. and b. Rejected Entities Reason Accounts Payable Violates rule 1 and 2——Wording suggests only one Department Clerk clerk (rule 1) and no evidence of attributes unique to this entity (rule 2) Safe Buy Grocery Violates Rule 1—The company is a single Stores occurrence Receiving Report This is a view—It derives entirely from receiving Summary report and thus violates rule 2 Part-Time Employees Violates rule 2—Assumption: no employee specific data need to be captured by this system Unloading Personnel Violates rule 2—Assumption: no employee specific data need to be captured by this system Sales Violates rule 2——Assumption: The company does not Representatives capture Sales Rep data unigue to each transaction. Obsolescence This is a view—Derived from inventory records Reports Violates rule 2 Invoice (physical) This is a view—Used to create Invoice Record Violates rule 2 Check (physical) This is a view—Derived from Check register records. Violates rule 2 Payment Summary This is a view—Derived from Check register records Violates rule 2 Purchase Requisition This is a view—Used to create Purchase Order Violates rule 2 Customers Not relevant to this system Valid Entities Reason Purchase Manager Assumption: all store purchase managers will use the system. This entity will consist of multiple occurrences and provide managertstore-specific data not contained in other entities. Supplier Meets conditions of Rules 1 and 2 Inventory Meets conditions of Rules 1 and 2 Purchase Order Meets conditions of Rules 1 and 2 Receiving Report Meets conditions of Rules 1 and 2 Invoice (record) Meets conditions of Rules 1 and 2 Payment Obligation Meets conditions of Rules 1 and 2 Check (register) Meets conditions of Rules 1 and 2 Problem 9-17, part c — Data Model of Purchases Procedures Updates Contains —|. < Inventory >—I V Supplies /\ Sent To Supplier Submits T Receiving Report Receives _'_ C heck Establish Initiates Payment |—< Obligation Perlains To f N \. J Is Associated 3 Is Associated With With H— A A Purchase Order +0 Is Associated With Problem 9-17, part d — Fully Attributed Data Model Inve ntory Pertains To Part Number 0 Desert tlon - Quant y on Hand cm” A “mam Fleord er Polnt PD item Detall Unlt Cost InvenifSuppller Llnk Item Number gait I‘llumfier b PO Number r t "W er "m er Order Guantlty Contains —V— Ftec Ftept Detall Suppller Part Number Suppller Number _FI‘°° HePt NUMber Suppller Name Guantlt Received SuPP'ler Address Condmgn Suppller Tel Number __ Supp ller Inuelce _ Involce Number Check Suppller Number Check Number ggtglummr [FK] Supplier Number [FK] Amount Contains Amount Payment Date Domains ‘1— mmm Pamentobiigatien ‘ . ié Cash Dlsb Num E51 M h Check Number [FK a '5 as Supplier Number [ K Pei-151m; PD Number qu To lnvolce Num er [FK] Payment Due Date Amount :2 Hecelvlng Report :. is Associated With Q's Assmimdmh _| __ Rec Rept Number Purchase 0rder PD Number [FK] F“ Number Date Flecelved i \ Suppller Number Carrler Code ' is Asmiatadwhh Date 01' Purchase ID’III otl‘liadlng Number Requested Dellveriir Date re a Co ect ...
View Full Document

This document was uploaded on 10/26/2011 for the course COMPUTER S 101 at National Taiwan University.

Page1 / 3

Problem 9-17 - Chapter 9 Page 38? 17. a. and b. Rejected...

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

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