INT306: Designing E-R Diagram - Relational Schema - Engineering Assignment Help

Assignment Task :

Ql. Consider the following scenario that modelsthe teams who play soccer, the matches they play, and the players in each team. Take into consideration the following points while designing E-R Diagram

1. There will be set of teams, each team has an ID (unique identifier), name, and to which city this team belongs.

2. Each team has many players, and each player belongs to one team.

3. Each player is identified by their number (unique identifier), name, DoB, career start year, and jersey number.

4. Teams play matches and, in each match, there is a host team and a guest team.

5. For each match we need to keep track of the following:

a. The date on which the match is played.

b. The final result of the match

c. The players participated in the match.

d. For each player, how many goals he scored, whether yellow cardred card is shown to the player by the referee.

e. While the match is being played, one player may substitute another player. Show this substitution in the diagram with the time at which substitution takes place.

f. Each match has exactly three referees. For each referee we have an ID (unique identifier), name, DoB, years of experience. Design an ER diagram by considering the above-mentioned requirements. State any assumptions you have that affects your design (mention explicitly).Make sure cardinalities and primary keys are clearly mentioned. 
 

Q3. Answer each of the following questions briefly. The questions are based on the following relational schema: Emp(eid: integer, ename:string, age:integer, salary: float) Inn 
 

This Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

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 that 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.