write SQL statements for given questions in order to get familiar to basic SQL data manipulation and definition statements by(use MYSQL Application) using insert using update using alter create table create view 1. DEFINE TABLE AUTHORS WITH COLUMNS AUTHORID INT AND AUTHORNAME VARCHAR(30) -- ADD COLUMN LEVEL PRIMARY KEY CONSTRAINT FOR AUTHORID -- ADD COLUMN LEVEL NOT NULL CONSTRAINT FOR AUTHORNAME -- (NOT NULL CAN ONLY BE DEFINED AT COLUMN LEVEL) 2. DEFINE TABLE PUBLISHERS WITH COLUMNS -- PUBLISHERID INT AND PUBLISHERNAME VARCHAR(30) -- ADD TABLE LEVEL PRIMARY KEY CONSTRAINT FOR PUBLISHERID -- ADD TABLE LEVEL UNIQUE CONSTRAINT FOR PUBLISHERNAME 3. ADD NEW COLUMN TO PUBLISHERS TABLE -- CITY VARCHAR(20)
write SQL statements for given questions in order to get familiar to basic
SQL data manipulation and definition statements by(use MYSQL Application)
using insert
using update
using alter
create table
create view
1. DEFINE TABLE AUTHORS WITH COLUMNS AUTHORID INT AND AUTHORNAME VARCHAR(30)
-- ADD COLUMN LEVEL PRIMARY KEY CONSTRAINT FOR AUTHORID
-- ADD COLUMN LEVEL NOT NULL CONSTRAINT FOR AUTHORNAME
-- (NOT NULL CAN ONLY BE DEFINED AT COLUMN LEVEL)
2. DEFINE TABLE PUBLISHERS WITH COLUMNS
-- PUBLISHERID INT AND PUBLISHERNAME VARCHAR(30)
-- ADD TABLE LEVEL PRIMARY KEY CONSTRAINT FOR PUBLISHERID
-- ADD TABLE LEVEL UNIQUE CONSTRAINT FOR PUBLISHERNAME
3. ADD NEW COLUMN TO PUBLISHERS TABLE
-- CITY VARCHAR(20)
4. SET CITY OF PUBLISHER CAN YAYINLARI TO İSTANBUL
6. ALTER TABLE BOOKS AND ADD NEW PRIMARY KEY CONSTRAINT FOR BOOKID
7. ADD NEW COLUMN PRIZE NUMERIC(5,2) FOR BOOKS TABLE
8. ALTER TABLE BOOKS AND ADD NEW CHECK CONSTRAINT FOR PRIZE>=5.00
9.ADD NEW COLUMN NATION CHAR(2) FOR AUTHORS TABLE
Step by step
Solved in 5 steps with 3 images
