Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- One company has many projects.
- One project belongs to one company.
- One project has one or more activities.
- One activity has exactly one activity type (prototyping, design).
- One activity belongs to exactly one project.
- COMPANY
- CompanyID
- ....
- PROJECT
- ProjectID
- ....
- ACTIVITY_TYPE
- ActivityTypeID
- Name (e.g. "Prototyping", "Design")
- ACTIVITY
- ActivityID
- ProjectID
- ActivityTypeID
- StartDate
- EndDate
- ...
- ProjectID | ProjectName | ...
- ActivityID | ActivityName | ...
- ProjectID | ActivityID | ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement