Trusted by 2+ million users,
1000+ happy students everyday
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
STUDENT16 JULY2016SQLASSIGNMENT
ContentsCREATETABLES......................................................................................................................................2INSERTTABLES.......................................................................................................................................3SELECTSTATEMENTS.............................................................................................................................5SQLQUERIES..........................................................................................................................................5SQLJOINSTATEMENTS..........................................................................................................................61|P a g e
CREATE TABLESTABLEARTISTCreatetableArtist(Artist_Idvarchar(5)primarykey,Namevarchar(10),Addressvarchar(50),Telephonenumber(10,0),Amount_of_Artnumber(5,0));TABLEARTCreatetableArt(Art_Idvarchar(20)primarykey,Val Number(10,2),Sizesvarchar(10),GenreVarchar(20),Date_createdDate,Artist_Idvarchar(5),foreignkey(Artist_Id)referencesArtist(Artist_Id));TABLELOCATIONCreatetableLocation(Location_Idvarchar(5)primarykey,Start_Datedate,End_datedate,Sectioncharcheck(SectionIN ('A','B', 'C', 'D')),2|P a g e
You are reading a preview
Upload your documents to download orBecome a Desklib member to get access