Description
Hi
I have small project as per the attached description.
Thank you.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Quiz 1
Simple ER model
Home team
Visitor team
Third Normal Form (3NF)
In 3rd normal form (3NF)) when it is in 2NF a better way may be found of to word this rule.
Order item 3NF
Order 3NF
v
Item 3NF
Contact 3NF
Order payment 3NF
Payment type 3NF
Quiz 2
Creating table
Home team int;
Way team int;
Scores ;
SQL code
Select a;
match number
stadium name
audience name
local team //’-’// vistor team
scores
Quiz 4
Match no
Local team
Visitor team
Date of match
Referee id
Stadium id
scores
1
2
3
chelsea
Arsenal
liverpo...