Assume you are in charge of establishing the table structures for a sports news website. Youve already identified the list of subjects and characteristics (Figure 1), have interviewed the manager and collected a sample for current website (Figure 2), as follows.

Interview:

You: As of now, your website shows a marquee which shows the headlines of the news. When the reader clicks on a headline, the system shows the story. Whats your vision for the new website? Any changes?

Participant: Yes, a lot of changes. We would like the website to allow readers to comment on news stories. For each comment, we would like to show the user name, date/time, and comment. This pretty much is like Facebooks style of reader comments. Readers can comment on each others comments as well.

You: Sounds good. What other features would you like to have?

Participant: We would like to keep track of the views for each story. Each view should have a date/time and IP address/user name associated with it. Further, this is a sports website for different kinds of sports (e.g. basketball, baseball). We want to categorize our news stories based on the sport type.

Figure 1: List of Subjects and List of Characteristics

Figure 2: Sample showing the details of a news story.

Please answer the following questions. You should explain how youve refined your preliminary table list using the techniques we learned in class. Make sure you choose good names for your tables and fields as well.

1- Identify Preliminary List of Fields

2- Construct Preliminary Table List

3- Construct Final list of Tables (with type and description for each table).

4- Construct the Table structures (with fields assigned to each table).

List of Characteristics Story Title Story Description Reader Name View Date Time View IP Address List of Subjects Story Reader View