CASE STUDY for performing normalisation UNF to 3 UNF: (want the table and the expression like in the example below) For

[answerhappygod]

CASE STUDY for performing normalisation UNF to 3 UNF:
(want the table and the expression like in the example
below)
For example -
The unormalised form (UNF): ROUND (round_no, match_date,
(start_time, court_no, team1_id, team1_name, team1_grade, team2_id,
team2_name, team2_grade, umpire_id, umpire_firstname,
umpire_lastname, umpire_acc_level)).
A little league netball organises a competition for under-16
teams. Each team is graded according to its age bracket. Grade A is
for the 15-16 years old and grade B is for the 13-14 years old.
Matches are organised for both grades and a match can have teams
from different grades competing. At the end of the competition, the
winner is determined for each grade. The competition runs for seven
weeks and consists of eight teams. In each round, there are four
matches scheduled on Saturday during the competition weeks. The
following schedule shows some samples of the information about the
matches.
COMPETITION SCHEDULE
Round 1, 12-June-2021
Start Time: 9 AM
Court no: 1
Teams: Firebirds (grade A) vs Phoenix (grade B)
Umpire: Natalie Wood
Umpire accreditation level: 2
Start Time: 9 AM
Court no: 2
Teams: Ladybugs (grade B) vs Pegasus (grade B)
Umpire: Karen Wan
Umpire accreditation level: 1
Start Time: 10 AM
Court no: 1
Teams: Lyrebirds (grade A) vs Butterflies (grade B)
Umpire: Natalie Wood
Umpire accreditation level: 2
Start Time: 10 AM
Court no: 2
Teams: Swifts (grade A) vs Dragonflies (grade A)
Umpire: Karen Wan
Umpire accreditation level: 1
Round 2, 19-June-2021
Start Time: 9 AM
Court no: 1
Teams: Firebirds (grade A) vs Pegasus (grade B)
Umpire: Amy Tan
Umpire accreditation level: 3
Start Time: 9 AM
Court no: 2
Teams: Ladybugs (grade B) vs Butterflies (grade B)
Umpire: Karen Wan
Umpire accreditation level: 1
Start Time: 10 AM
Court no: 1
Teams: Lyrebirds (grade A) vs Dragonflies (grade A)
Umpire: Natalie Wood
Umpire accreditation level: 2
Start Time: 10 AM
Court no: 2
Teams: Swifts (grade A) vs Phoenix (grade B)
Umpire: Amy Tan
Umpire accreditation level: 3
etc
The database designer has included the team_id and umpire_id
attributes in the database to uniquely identify teams and umpires
in the competition.
Perform normalisation to 3NF for the data depicted
above. The normalisation must be carried out form by form,
beginning by representing the document you are working on as a
single UNF relation (given above) and then moving through 1NF, 2NF
and 3NF. During normalisation, you must:
○ Not add surrogate keys.
○ Include all attributes (you must not remove any attribute as
derivable)
○ Clearly show UNF, 1NF, 2NF and 3NF.
○ Clearly identify the Primary Key in all relations.
○ Clearly identify all dependencies at the various normalisation
stages (Partial at 1NF, Transitive at 2NF and Full at 3NF). If none
exist you must note this by stating: No partial dependencies
present and/or No transitive dependencies present.
Thank you! Please explain as well.