Happy Thoughts Gift Shop RELATIONAL TABLES

Happy Thoughts Gift Shop RELATIONAL TABLES - Chapter 6...

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

View Full Document Right Arrow Icon
Chapter 6 Relational Database Design: Converting Conceptual REA Models to Relational Databases RELATIONAL TABLES Cash CashAcc t# AcctTy pe Locati on _____ Primary key identified _____(0, ) Cash – Cash Disb = at least one CashAcct# in this table not in CashDisb Cash Disbursement Disburseme ntID Dat e Total Amount DistributorI D** CashAcct #** _____ Primary key identified _____(0, ) Cash Disb – Distributor = at least one DistributorID should be null ( ,1) Cash Disb – Distributor = max one DistributorID per disbursement (no action needed) _____( ,N) Distributor – Cash Disb = at least one DistributorID in this table multiple times _____( ,N) Cash – Cash Disb = at least one CashAcct# in this table multiple times _____(1, ) Cash Disb – Cash = CashAcct# set to required data entry ( ,1) Cash Disb – Cash = max one CashAcct per disbursement (no action needed) _____(0, ) Cash Disb – Purchase = at least one DisbursementID in this table not in Purchase Distributor Distribut orID Nam
Background image of page 1

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

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

This note was uploaded on 05/20/2008 for the course ACCOUNTING 305 taught by Professor Rosemartin during the Fall '07 term at Cal Poly Pomona.

Page1 / 2

Happy Thoughts Gift Shop RELATIONAL TABLES - Chapter 6...

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

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