Course Hero Logo
Question
Answered step-by-step

Question 3: Further SQL (15 marks) a.       Provide ALL of...

Question 3: Further SQL (15 marks)

a.      Provide ALL of the SQL statements required to insert the details of the following: A customer, John Smith, of 47 Moodle Street, Highwater, WA, 6709, Australia (email: j..hatsomeisp.com) has sold a work of art called "Gorillas in the Mist" by the renowned French artist, Gallic Symbol (b. 1972) to the Gallery (i.e., the Gallery purchased it from him). It is a unique Watercolour on Paper and is 45 * 35cm signed by the Artist. The purchase price was $4600 and the transaction took place on 27th July 2020. (7 marks)


b.      You have been given the following specifications of a simple database for a netball association that keeps record of players, teams and matches.


Give the SQL to create the Match table. You may assume that the Player and Team tables have already been created, and that the PlayerID and TeamID colums are of the data type VARCHAR2(5). The result of the match refers to the result for the HomeTeam and can be only W, L or D (win, lose or draw). (5 marks)

c.      Your match table must also include a column that records the scores of both teams in the match. Provide the SQL to amend the original table design to allow for this change in requirement. It is most unlikely (impossible) that a team would ever score more than 999 goals in a match. (3 marks)

Answer & Explanation
Verified Solved by verified expert
<p>m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae o</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit.itur laoreet. Nam risus ante, dapibuscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultfac, dictum vitae odi

gue

sum do
dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing el
gue

gue

gue

gue

molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Na

gue

sum do

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus

gue

gue

gue

gue

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ip

gue

guesum do

tesque dapibus efficitur laoreet. Nam ris

Step-by-step explanation
  • sum dol
  • icitur lultrices asus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui

    inia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus

    gue

    dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing el
    gue

    gue

    , consectetur adipiscing elit.

    itur laoreetm risusec aongue velm risususus antec facec facec facac,cesque dapibus
    ng elit. Ntrices ac magna. Fusce duiac, dictum vitae odmolestiefsus ante, dapibusm ipsumsusm ipsum

    gue

    gue

    gue

    gue

    • ur laore

    ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Na

    icitur lnec facilionec aliquet. Lorem ipsum dolor sit amet, co

    molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing e

    gue

    m ipsumpulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante,

    ec fonec alctum vitae odio. Donec aliquet. Lorem ipsum d

    ec fng eliscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus

    ec facinialestiesquinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a

    ec fsque dapiaciniconsectetur ang es a molestiet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet

    gue

    , dictum vitae odio. Donec aliquet. Lorem ipsumconsectetumolestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac,

    gue

    s a molestie consequat, ultrices ac magna. Fusce dui lectlonec aliqulfacilisis. Pellentels a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel lalFusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

    gue

    gue

    gue

    gue

    • m ipsum

    icitur lsque dapi, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. N

    sus ante, dapibus a molongue vel laoreet ac, dictum vit

    ec flestie codictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia

    gue

Student reviews
75% (4 ratings)