Homework

Design a entity relationship diagram (ERD) using MySQL workbench for our Twitter dataset. Specifically, here is what we want our database to be able to store:


 * 1) Tweets returned for a given query. Specifically, we want to be able to store:
 * 2) created_at
 * 3) from_user
 * 4) from_user_id
 * 5) to_user_id
 * 6) text
 * 7) id - twitter id
 * 8) Information about the users. Specifically, we want to be able to store:
 * 9) name
 * 10) id
 * 11) their followers
 * 12) their friends
 * 13) location
 * 14) created_at
 * 15) time zone
 * 16) their profile picture
 * 17) Subscribed lists for each user. Specifically:
 * 18) id
 * 19) uri
 * 20) member_count
 * 21) created_at
 * 22) date added to database
 * 23) member_count
 * 24) subscriber_count
 * 25) Trends for a given woeid (http://developer.yahoo.com/geo/geoplanet/). Specifically:
 * 26) woeid
 * 27) created_at
 * 28) name
 * 29) Daily trends
 * 30) date
 * 31) name
 * 32) Weekly trends
 * 33) date
 * 34) name

What you need to turn in:
 * 1) An EER model in MySQL workbench
 * 2) It should have the correct primary, foreign keys, fields, data types, relationships, etc
 * 3) Where appropriate you must name your relationships
 * 4) There isn't a single correct model, but there are incorrect models