Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. 1[COMPANY] --- <has> --- *[ACCOUNTS]1 --- <has> --- *[PAYMENTS]
  2.  
  3. Table COMPANY has columns: CompID | CompanyName |
  4. Table ACCOUNTS has columns: AccID | Name | Company |
  5. Table PAYMENTS has columns: PayID | GroupID | PaymentDue | DateDue
  6.  
  7. COMPANY | No. of ACCOUNTS | TOTAL DUE | DATE DUE
  8. 'Comp 1' | 3 | 10000 | 4/30/2015
  9. 'Comp 2' | 2 | 8000 | 4/30/2015
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement