Help please. I do not understand sql statements. if anyone can help me i will greatly appreciate it

 

Homework 2Due Date: Sept. 17, 2016 at 11:59 PMConsider the scenario from homework 1, where we designed an E-R diagramas represented in the following Fgure for an art gallery in Greensboro.Task1 (70 points):Write SQL statements to create the corresponding relationsand capture as many of the constraints as possible.If cannot capture someconstraints, explain why. Make sure that the data type and size for eachattribute are appropriate.±or example, a numerical data type is a betterchoice than a string data type for the attributettlAmt.Task 2(30 points)::write SQL statements to load data into each relation.You are required tocome up withatleast 5 recordsfor each table.Please put your SQLstatements into an SQL script Fle and submit it to the assignment link.Make sure your SQL script fle can be run successFully in MySQLbeFore submitting it. IF it has any syntax error, your grade oF thisassignment will be a ZERO.OFavorsIDArtsTsfNamemNamelNamebirThPlacedaTeBorndaTeDiedCreaTesoCounTryarTSTyleArTworksIDtTlesizedescriptonpriceMNPaintngSculpTureSTaTueTypemaTerialmaTerialweighTsTyleMNCusTomersIDfNamemNamelNameaddresssTyleLike±lAmTMNDisplayExhibitonnameThemesTarTedDaTeendedDaTeMNmaTerialweighTsTyleyearheighTwide

• 1495613365-Homework 23.docx

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1495613368-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer