Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

begin{tabular}{l|l|} hline Task: & Employees at Prime Komputer Industries regularly battle each other in what they consider athletic events: Wii bowling, Wii golf, and Wii

image text in transcribed

\begin{tabular}{l|l|} \hline Task: & Employees at Prime Komputer Industries regularly battle each other in what they consider athletic events: Wii bowling, Wii golf, and Wii tennis. Competition among the departments is getting a little heated, and so player scores will need to be more accurately tracked. \\ \hline Task: & Employees from all PKI departments may sign up to compete in any or all of the three events (or "Wii-vents," as they call them). Competitions are held each Saturday morning, with four players simultaneously competing in a single game. At the end of each game, the points for each player need to be recorded. Players may play several different games during the morning. At the end of the month, players with the most points in each event are given a paper medal. The player with the most points overall wins a Starbucks card which when last checked had only a $0.37 balance. \\ \hline Task: & Rather than record players and scores on paper, a database solution is needed to track these very important proceedings. \\ \hline Task: & Develop the initial design of the entities which you believe will be needed for this database. For each entity, provide a proper name, a short description of its purpose, and as complete a list of relevant attributes as you can envision. \\ \hline Task: & Include a proper primary key attribute in each entity. Also consider how the entities are related by including appropriate foreign key attributes. \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions

Question

What is a standardized normal curve?

Answered: 1 week ago