Modeling Data

Activity

Working with the same partner from Week 1 and Week 2, begin to think about database design. For your selected website, make a list of every piece of data collected. Capture everything that you can find on the site. It's okay to guess about the data "behind" a function if it isn't obvious (For example, if you were going to map out the data collected by Google, you would note the search box as one piece of data. You might also guess that Google collects more information than just your search text including perhaps date, time, IP address, etc.)

Once you have a comprehensive list of all the data that makes up the website, decide how you think the data is "grouped". What data is collected together to make up a table in the database? Again, feel free to guess since you don't have access to the database design.

Finally, determine how the data is connected. In other words, what data is related to other data? Use whatever method you like to represent the database "design". You can draw a picture, use text notations, or any other method (as long as I can understand it.)

Submit your completed data "model" to me via Blackboard. Your document must include 3 parts:

  1. A list of all the individual pieces of data
  2. A list of all the "groups" of data (probable tables in the database)
  3. A representation (model, picture, text) of the relationships/connections between the "groups" of data
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License