Geeks With Blogs
Mike Kenyon Hoarked

So I’m a firm believer that once you have business requirements its a good idea to have the data right.  You may have to expand on it later, but it’s good to know what you’re dealing with in a problem space.  In a larger, green-fields application, I might well do a part at a time to keep in good Agile methodology, but this is neither large nor green fields (I’ve build the application several time so far for different years in different tech stacks, though this hopes to be the prettiest).  So, here we go …

OscarsERD

Hollywood Types

Types in this schema are those needed to model the actual Oscars.

Category: The 24 different categories that represent the Oscars night balloting.

Movie: The different movies up for awards.

Person:  The people up for nominations or involved in movies up for nominations, with photos (from IMDB).

Actor: The list of all people involved in the movie.  This would support giving an actor list for all nominated films, but will probably be the last table I bother to populate.

Nominee: The relationship between categories, movies and people.  The 3-way join it necessary to support cases where two people are up for the same movie. 

 

Game Types

Types in this schema are those needed to play the Oscars as a game.

Player: A record of the players of the game.

Guess: That player’s choices.

Posted on Monday, January 26, 2009 10:16 PM | Back to top


Comments on this post: Creating a WPF Application With Prism v2 – Data Design

# re: Creating a WPF Application With Prism v2 – Data Design
Requesting Gravatar...
Can you provide the scripts to create Oscars db and its content. Thanks!
Left by Prism_Beginner on Jun 10, 2010 11:37 AM

Your comment:
 (will show your gravatar)


Copyright © hoarked | Powered by: GeeksWithBlogs.net