Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume you are in charge of establishing the table structures for a sports news website. You've already identified the list of subjects and characteristics (Figure
Assume you are in charge of establishing the table structures for a sports news website. You've already identified the list of subjects and characteristics (Figure 1). You have interviewed the manager and collected a sample for current website. 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. What's 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 Facebook's style of reader comments. Readers can comment on each other's 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. Sample You collected the sample in Figure 2, which is an example of how a news story is presented to the user. Requirements Based on the list of subjects, list of characteristics, interview and the sample, do the following: (2 points) Preliminary List of Fields 2 points) Preliminary Table List (3 points) Final List of Tables (Table names, descriptions, and types) (3 points) Table Structures (Tables with fields associated with them) Your answer should be reasonably detailed. For instance, you should explain how you've 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. List of Characteristics Story Title Story Description Reader Name View Date Time View IP Address List of Subjects Story Reader View Figure 1: List of Subjects and List of Characteristics Latest Rajon Rondo breaks hand in fallLeBron: Patience is key LeBron sets tone at Cavs media day 2014-09-27 INDEPENDENCE, Ohio The satellite trucks started lining up for a spot close to the Cleveland Cavaliers' training facility early Friday morning. A huge tent was erected onsite as a temporary media workroom to accommodate the hundreds of reporters on hand for LeBron James' official return to the Cavs. He never did have a news conference this summer, if you remember. So whatever party the city of Cleveland was going to throw to celebrate therturn of its prodigal son had to be Fn Figure 2: Sample showing the details of a news story
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started