logo

Short Title: Table ART

   

Added on  2019-09-22

7 Pages1555 Words357 Views
 | 
 | 
 | 
STUDENT16 JULY 2016SQL ASSIGNMENT
Short Title: Table ART_1

ContentsCREATE TABLES......................................................................................................................................2INSERT TABLES.......................................................................................................................................3SELECT STATEMENTS.............................................................................................................................5SQL QUERIES..........................................................................................................................................5SQL JOIN STATEMENTS..........................................................................................................................61 | P a g e
Short Title: Table ART_2

CREATE TABLESTABLE ARTISTCreate table Artist(Artist_Id varchar(5) primary key,Name varchar(10),Address varchar(50),Telephone number(10,0),Amount_of_Art number(5,0));TABLE ARTCreate table Art (Art_Id varchar(20) primary key,Val Number(10,2), Sizes varchar(10), Genre Varchar(20), Date_created Date,Artist_Id varchar(5),foreign key(Artist_Id) references Artist(Artist_Id));TABLE LOCATIONCreate table Location(Location_Id varchar(5) primary key, Start_Date date,End_date date,Section char check (Section IN ('A', 'B', 'C', 'D')),2 | P a g e
Short Title: Table ART_3

End of preview

Want to access all the pages? Upload your documents or become a member.