Background Reliable access to data is vital for all organizations. To ensure thi

Question

Background Reliable access to data is vital for all organizations. To ensure this, data must be captured and stored in a well-organized manner.

Summary Design an initial data model for a small competition. 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.

Task Employees from all 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.29 balance.

Task Rather than record players and scores on paper, a database solution is needed to track these very important proceedings. 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. Task Include a proper primary key attribute in each entity. Also consider how the entities are related by including appropriate foreign key attributes

. Task Organize these entities clearly. However, you are not required to draw an entity-relationship

Explanation / Answer

Employee -----> This is the table which can stores the details of all the employees and their information.

1. Create table employee(eid number UNIQUE, ename varchar2(10),edept number(5),games_play varchar2(10),points number(10),PRIMARY KEY(eid,edept));

Department -----> Records all the different departments information and the points of the departments

2. Create table department(dno number(5) UNIQUE,departmentname varchar2(10),points number(5),games_won number(5),gameslost number(5), FOREIGN KEY(dno) REFERENCES employee(edept));

Scores--->This records all the scores of all the employess and the games information which employee played

3. Create table scores (empid number(5), dept number(5),games_played number(5),points_win number(5),medals_won number(5), FOREIGN KEY(empid) REFERENCES employee(eid));

These will be sufficient for the above scenario.This will records all the games information and the points and the awards which the employees or departments won.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.