@aeyshaencilatta45_gmail_com

-- create a table CREATE TABLE de (department_id int, department_name varchar(30), department_block_number int); -- insert some values INSERT INTO de VALUES (1, 'CSE', 3); INSERT INTO de VALUES (2, 'IT', 3); INSERT INTO de VALUES (3, 'SE', 3); -- fe

create table Rentals(rental_id varchar(10), customer_id varchar(10), car_id varchar(10), pickup_date date, return_date date, km_driven int, fare_amount double(10,2)); insert into Rentals values('R100', 'CD10', 'BM12', '12-FEB-2020', '30-MAR-2020',

create table cars(car_id varchar(10), car_name varchar(20), car_type varchar(20), owner_id varchar(20)); insert into cars values('BM12', 'BMW', 'BMW Z4 M4oi', 'O0111'); insert into cars values('SW72', 'Swift', 'Swift ZXI plus DT', 'P0112'); insert

create table customers(customer_id varchar(10), customer_name varchar(20), address varchar(20), phone_no bigint, email_id varchar(20)); insert into customers values('CD10', 'Twinkle', '19 bangalore', '123 456 7890', 'xyz1@gmail.com'); insert into c

create table Owners(owner_id varchar(10), owner_name varchar(20), address varchar(20), phone_no bigint, email_id varchar(20)); insert into Owners values('O0111', 'Hasan', 'H/12 coimbatore', '111 111 1111', 'abc@gmail.com'); insert into Owners value

create table Orders(order_id varchar(10), customer_id varchar(10), hotel_id varchar(10), partner_id varchar(10), order_date date, order_amount int); insert into Orders values('OP001', 'C1001', 'H01', 'P001', '08-JAN-2022', 500); insert into Orders

create table Customer(customer_id varchar(10), customer_name varchar(20), address varchar(20), phone_no bigint, email_id varchar(20)); insert into Customer values('C1001', 'Anbu', '17 Coimbatore', '111 111 1111', 'abc@gmail.com'); insert into Custo

create table Hotel_details(hotel_id varchar(10), hotel_name varchar(20), hotel_type varchar(20), rating int); insert into Hotel_details values('H01', 'Aarthi', 'Coimbatore', 5); insert into Hotel_details values('I02', 'Zara', 'Chennai', 2); insert

create table Delivery_partners(partner_id varchar(10), partner_name varchar(20), phone_no bigint, rating int); insert into Delivery_partners values('P001', 'Priya', '111 111 1111', 5); insert into Delivery_partners values('Q002', 'Jeya', '222 222 2

create table Mark(value int, subject_id int, student_id int); insert into Mark values(467, 75, 101); insert into Mark values(391, 76, 102); insert into Mark values(420, 77, 104); insert into Mark values(498, 78,105); insert into Mark values(250, 79

create table Subject(subject_id int, subject_name varchar(30), subject_code varchar(10), staff_id int); insert into Subject values(75, 'SPM', 'HI986', 41); insert into Subject values(76, 'CT', 'GY876', 42); insert into Subject values(77, 'DBMS', 'S

create table Staff(staff_id int, staff_name varchar(30), department_id int); insert into Staff values(41, 'Jemilda', 05); insert into Staff values(42, 'Nisha', 10); insert into Staff values(43, 'Regina', 12); insert into Staff values(44, 'Sathyaraj

create table Student(stuedent_id int, student_name varchar(30), address varchar(40), city varchar(30), department_id int); insert into Student values(101, 'Aeysha', 'Nehru nagar', 'Coimbatore', 05); insert into Student values(102, 'Benit', 'Church

create table department(department_id int, department_name varchar(30), department_block_number int); insert into department values(10, 'CSE', 104); insert into department values(20, 'IT', 102); insert into department values(05, 'ECE', 109); insert