Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
THESE ARE SOME BASIC DATABASE LABS ASSIGNMENT EASY FOR BEGINNERS..THEY CONTAIN OUPUT PICS AND CODE AS WELL
Typology: Lab Reports
1 / 4
This page cannot be seen from the preview
Don't miss anything!
Question No 1
Problem 11. [5] Write a TRIGGER to ensure that DEPT TABLE does not contain duplicate of null values in DEPTNO column. Insert Record in Department having Employee No equal to NULL twice: Trigger Gives Error when I want to insert record 2nd time:
Question No 3 Problem 11. [5] Write a Trigger to carry out the following action: on deleting any records from the emp table, the same values must be inserted into the log table. Delete Record from Employee Table: Record is automatically inserted into Log Table:
