Assignment On SQL
Added on - 22 Sep 2019
7
pages
1555
Words
156
Views
0
Downloads
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’re reading a preview

To View Complete Document
Become a Desklib Library Member.
Subscribe to our plans