V
@Vs22_
question 9
-- Creating the emp table
CREATE TABLE emp (
eno INT PRIMARY KEY,
ename VARCHAR(100),
bdate DATE,
title VARCHAR(50),
salary DECIMAL(10, 2),
dno VARCHAR(10)
);
QUESTION - 8
create table library(bookid varchar(10)primary key,bookname char(20),author char(20),datepurchased date ,publisher char(20),price int );
INSERT INTO library values('b101','cost accounting','jain narang','2013-02-11','kalyani',800);
INSERT INTO library values('b102','bussiness statistics','op aggarwal','2011-12-22','himalaya',750);
INSERT INTO library values('b103','rdbms','cjdate','2015-03-02','TMH',900);
INSERT INTO library values('b104','Mgmt accounting','RK sharma','2016-04-19','kalyani', 4
Question 6
-- create
CREATE TABLE book(isbn int PRIMARY KEY,
title varchar (20),
publication varchar (20)
);
INSERT INTO book VALUES (01,'Taming Flame','Pearson');
INSERT INTO book values (02,'Mocking bird','Tata Mcgrew');
INSERT INTO book VALUES (08,'Milestones','Tata Mcgrew');
INSERT INTO book VALUES (13,'Vow of thieves','Pearson');