SHARE
TWEET

Untitled

a guest Feb 20th, 2019 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. One company has many projects.
  2. One project belongs to one company.
  3. One project has one or more activities.
  4. One activity has exactly one activity type (prototyping, design).
  5. One activity belongs to exactly one project.
  6.    
  7. COMPANY
  8. CompanyID
  9. ....
  10.  
  11. PROJECT
  12. ProjectID
  13. ....
  14.  
  15. ACTIVITY_TYPE
  16. ActivityTypeID
  17. Name (e.g. "Prototyping", "Design")
  18.  
  19. ACTIVITY
  20. ActivityID
  21. ProjectID
  22. ActivityTypeID
  23. StartDate
  24. EndDate
  25. ...
  26.    
  27. ProjectID | ProjectName | ...
  28.    
  29. ActivityID | ActivityName | ...
  30.    
  31. ProjectID | ActivityID | ...
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top