Ask a question to Desklib · AI bot
Assignment On SQL
7 Pages1555 Words357 Views
Added on 2019-09-22
BookmarkShareRelated Documents
STUDENT16 JULY 2016SQL ASSIGNMENT
ContentsCREATE TABLES......................................................................................................................................2INSERT TABLES.......................................................................................................................................3SELECT STATEMENTS.............................................................................................................................5SQL QUERIES..........................................................................................................................................5SQL JOIN STATEMENTS..........................................................................................................................61 | P a g e
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
