Back to Table of Contents

Brain Teasers Database Design

E/R Diagram


The 'Teaser' object holds all information about a particular teaser. The 'Account' object will keep track of all accounts allowed to interact with the system. The lastlogin value will be used to purge old accounts. The 'submitted' relation keeps information about which users submitted which brain teasers to the database, and when they were approved or rejected. The 'Featured' object tracks the date that each teaser was featured on the front page of the web site. Each day one teaser gets featured, but a teaser may be featured more than once. 'Difficulty' and 'Funness' track the votes and ratings that users give each teaser.

E/R Diagram

Back to Table of Contents


by Jake Olefsky - June 2000