Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. Person
  2. PersonID (PK)| {Person Attributes}
  3.  
  4. Employee
  5. EmployeeID(PK)| PersonID (FK)| {Employee Attributes}
  6.  
  7. Customer
  8. CustomerID(PK)| PersonID (FK)| {Customer Attributes}
  9.  
  10. PersonID --> CustomerID
  11. PersonID --> EmployeeID
  12.  
  13. PersonID --> CustomerID --> {Customer Attributes}
  14. PersonID --> EmployeeID --> {Employee Attributes}
  15.  
  16. Person
  17. PersonID (PK)| PersonName
  18.  
  19. Employee
  20. PersonID (PK)| EmployeeID | {Employee Attributes}
  21.  
  22. Customer
  23. PersonID (PK)| CustomerID | {Customer Attributes}
  24.  
  25. PersonID --> CustomerID --> {Customer Attributes}
  26. PersonID --> EmployeeID --> {Employee Attributes}
  27.  
  28. Person
  29. PersonID (PK)| PersonType (Employee/Customer) | {Person Attributes}
  30.  
  31. Employee
  32. PersonID (PK)| {Employee Attributes}
  33.  
  34. Customer
  35. PersonID (PK)| {Customer Attributes}
  36.  
  37. Person
  38. PersonID (PK)| {Person Attributes}
  39.  
  40. Employee
  41. PersonID (PK)| {Employee Attributes}
  42.  
  43. Customer
  44. PersonID (PK)| {Customer Attributes}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement