Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help with both the questions Task 2 Populate the tables with values given below. Please insert the data in CAPITAL letters. Note that the

image text in transcribed

image text in transcribed

Please Help with both the questions

Task 2 Populate the tables with values given below. Please insert the data in CAPITAL letters. Note that the fields STADIUMID, FANID or MATCHID (i.e. S01, F001 or M01) has zero in it and not letter 'O STADIUM TABLE STADIUMID STADIUMNAME S01 S02 STADIUMCITY CAPACITY OPENYEAR 1956 2017 LUZHNIKI STADIUM MOSCOW SAINT PETERSBURG SAINT STADIUM FISHT STADIUM KAZAN ARENA SAMARA ARENA SPARTAK STADIUMMOSCOW 80000 67000 PETERSBURG SOCHI S03 S04 S05 S06 48000 45000 45000 42000 2013 2013 2018 2014 SAMARA FAN TABLE FANID FANNAME F001 FOO2 FOO3 ELLEN SMITH FO04 FOO5 FO06 FO07 F008 FOO9 FO10 FANNATIONALITY AMERICAN RUSSIAN AUSTRALIAN BRISTISH RUSSIAN BRAZILIAN RUSSIAN LEBANESE CHINESE AMERICAN FANCATEGORY SILVER GOLD SILVER GOLD BRONZE SILVER BRONZE SILVER GOLD SILVER MONICA JONES DMITRIY VLADIMIR MR. BEAN GOR MIKHAIL ALBERTO HERNANDEZ 7 NATALIA PAKLINA NANCY AJRAM JIE CHEN MAX CAMERON MATCHES TABLE MATCHID FIRSTTEAM | SECONDTEAM MATCHDATE | KICKOFF | STADIUMID MO1 M02 M03 M04 MO5 M06 M07 M08 T9 T17 T29 2018-06-14 15:00:00 S01 2018-06-1416:00:00 S02 2018-06-16 18:00:00S03 2018-06-1920:00:00 S02 2018-06-1920:00:00 S04 2019-06-20 15:00:00 S06 2018-07-15 20:00:00S01 2018-07-15 16:00:00S02 T10 T1 T2 T4 T15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions