ER Schema for a Sport League Database Assignment

Assignment Task

1.(a) Consider the ER diagram of Figure 3.16 (found on my home page. Click on “figures on Chapter 3), which shows a simplified schema for an airline reservation system. Extract from the ER diagram the requirements and constraints that produced this schema. Try to be as precise as possible in your requirement and constraint specification.

(b)  A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Try to design an ER schema diagram for this application, stating any assumption you make. Choose your favorite sport (soccer, baseball, football, …).

• Specify the following queries in SQL (see Fig. 7.5 on my home page).

1. Retrieve the name of all employees in department 5 who work more than 10 hours per week on the ‘Product X’ project.
2. List the names of all employees who have a dependent with the same first name as themselves.
3. Find the names of all employees who are directly supervised by ‘Franklin Wong’.
4. For each project, list the project name and the total hours per week (by all employees) spent on that project.
5. Retrieve the names of all employees who work on every project.
6. Retrieve the names of all employees who do not work on any project

This It Computer Science have been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.