The Lazy Coder

-- a -> CREATE the tables with appropriate constraints CREATE Table Student( Stud_Id INT PRIMARY KEY, Stud_Name VARCHAR(10) ); CREATE Table Membership( Mem_no INT PRIMARY KEY, Stud_Id INT, FOREIGN KEY(Stud_Id) REFERENCES Student(Stud_Id) on delete CASCADE ); CREATE Table Book( book_no INT PRIMARY KEY, book_name VARCHAR(10), author_name VARCHAR(10) ); CREATE Table IssueRec( iss_no INT PRIMARY KEY, iss_date DATE, mem_no INT, book_no INT, FOREIGN KEY(mem_no) REFERENCES Membership(Mem_no) on delete CASCADE, FOREIGN KEY(book_no) REFERENCES Book(book_no) on DElete CASCADE ); -- b -> Insert around 10 records INSERT INTO student VALUES (1,"Harsh"); INSERT INTO student VALUES (2,"Rohit"); INSERT INTO student VALUES (3,"Anju"); INSERT INTO student VALUES (4,"Tushar"); INSERT INTO student VALUES (5,"Aman"); INSERT INTO student VALUES (6,"Sonali"); INSERT INTO student VALUES (...

CREATE Table student( stud_no INT PRIMARY KEY, stud_name VARCHAR(20) ); CREATE Table membership( Mem_no INT PRIMARY KEY, stud_no INT, FOREIGN KEY (stud_no) REFERENCES student(stud_no) on delete set NULL ); CREATE Table Book( book_no int PRIMARY KEY, book_name VARCHAR(20), author VARCHAR(15) ); CREATE Table iss_rec( iss_no INT PRIMARY key AUTO_INCREMENT, iss_data DATE , mem_no int , book_no int, FOREIGN KEY (mem_no) REFERENCES membership(Mem_no) on delete set NULL, FOREIGN KEY (book_no) REFERENCES Book(book_no) on delete set NULL ); SELECT * FROM student; SELECT * FROM membership; SELECT * FROM book; SELECT * FROM iss_rec; INSERT INTO student VALUES (1, "Harsh Prasad"); INSERT INTO student VALUES (2, "Rihana "); INSERT INTO student VALUES (3, "Love Kush"); INSERT INTO student VALUES (4, "Jiten Kapoor"); INSERT INTO student VALUES (5, "Anju Kumari"); INSERT INTO student VALUES (6,...

CREATE Table Employee( emp_id INT PRIMARY KEY , first_name VARCHAR(10), second_name VARCHAR(10), dob DATE , sex VARCHAR(1), salary int , supervi_Id int, branch_id int ); CREATE table Branch( branch_id int PRIMARY KEY, branch_name VARCHAR(10), mngr_id int, mngr_strt_date date, FOREIGN KEY (mngr_id) REFERENCES employee(emp_id) on delete set null ); CREATE Table client( clientId int PRIMARY key, client_name VARCHAR(10), branch_id int, FOREIGN KEY(branch_id) REFERENCES Branch(branch_id) on delete set null ); CREATE Table Works_with( emp_id INT, clientId int, total_sales int -- PRIMARY key(emp_id, clientId), -- FOREIGN key(emp_id) REFERENCES employee(emp_id) on delete CASCADE, -- FOREIGN key(clientId) REFERENCES client(clientId) on delete CASCADE ); CREATE Table Branch_Suppliers( branch_id int , supplier_name VARCHAR(15), supply_type VARCHAR(15), PRIMARY key (branch_id, supplier_name...