Home

The Project Case

You can view the project assignment here

To view the database skeleton follow these steps:

1. Go to http://dbdesigner.holycrap.ws/
2. Click on ‘Save / Load’ button in the top-right corner
3. In the new overlay, click the ‘Load’ button
4. In the popup dialogue, type in ‘itc’ and click ‘OK’

Tables (bodies of information being tracked)

• Comments
• Languages (updated by admins)
• Points (used by system)
• Point Events (used by system) (updated by admins)
• Ranks (used by system) (updated by admins)
• Reviews
• Sources (the word ‘File’ was already in use, so I had to change the name)
• Subscriptions (used by system)
• Tags
• Users
• Votes (used by system)

The tables that are “used by system” are interacted with through secondary measures such as keeping track of how many points / votes you have or for system information like what ranks people can have. This is instead of your standard creation/editing form and deletion pages that general users would normally be admitted access to.