Write SQL statements for given questions in order to get familiar to basic SQL data manipulation and definition statements by using insert using update using alter create table create view.(Use MYSQL Application) 1.SET CITY OF PUBLISHER CAN YAYINLARI TO İSTANBUL 2. DEFINE TABLE NAMED BOOKS WITH COLUMNS -- BOOKID INT, TITLE VARCHAR(30), AUTHORID ?, PUBLISHERID ?, -- GENRE VARCHAR(20) -- ADD FOREIGN KEY CONSTRAINT PUBLISHERID -- ADD FOREIGN KEY CONSTRAINT AUTHORID WITH ON DELETE CASCADE -- ON DELETE CASCADE (when a referenced parent table row is removed all the child are removed automatically) 3. ALTER TABLE BOOKS AND ADD NEW PRIMARY KEY CONSTRAINT FOR BOOKID 4. ADD NEW COLUMN PRIZE NUMERIC(5,2) FOR BOOKS TABLE
Write SQL statements for given questions in order to get familiar to basic SQL data manipulation and definition statements by
using insert using update using alter create table create view.(Use MYSQL Application)
1.SET CITY OF PUBLISHER CAN YAYINLARI TO İSTANBUL
2. DEFINE TABLE NAMED BOOKS WITH COLUMNS
-- BOOKID INT, TITLE VARCHAR(30), AUTHORID ?, PUBLISHERID ?,
-- GENRE VARCHAR(20)
-- ADD FOREIGN KEY CONSTRAINT PUBLISHERID
-- ADD FOREIGN KEY CONSTRAINT AUTHORID WITH ON DELETE CASCADE
-- ON DELETE CASCADE (when a referenced parent table row is removed all the child are removed automatically)
3. ALTER TABLE BOOKS AND ADD NEW PRIMARY KEY CONSTRAINT FOR BOOKID
4. ADD NEW COLUMN PRIZE NUMERIC(5,2) FOR BOOKS TABLE
5. ALTER TABLE BOOKS AND ADD NEW CHECK CONSTRAINT FOR PRIZE>=5.00
6.ADD NEW COLUMN NATION CHAR(2) FOR AUTHORS TABLE
7. CREATE VIEW BOOKSVIEW WITH AUTHORS, BOOK TITLES AND PRIZE
8. CREATE VIEW PUBVIEW OF PUBLISHERS WITH ID AND NAME
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images