ROLL NO - 202213001
DIV – D SEM – 2
CRDBMS JOURNAL
1. Create the following table and insert at least 10 records in each with
appropriate constrains .
Student ( sid , sname )
Customer ( customer id , name , contact number , address , city , grade ,
salesman_id )
AFRE SAHIL ANILBHAI DIV – D SEM – 2 1
, ROLL NO - 202213001
DIV – D SEM – 2
CRDBMS JOURNAL
Product ( pid , customer id , product name , product quantity , order date )
Salesman ( salesman_id , name , city , commission )
2. Write a query to grant view and delete privileges to the user “ abc “ on
student table .
AFRE SAHIL ANILBHAI DIV – D SEM – 2 2
DIV – D SEM – 2
CRDBMS JOURNAL
1. Create the following table and insert at least 10 records in each with
appropriate constrains .
Student ( sid , sname )
Customer ( customer id , name , contact number , address , city , grade ,
salesman_id )
AFRE SAHIL ANILBHAI DIV – D SEM – 2 1
, ROLL NO - 202213001
DIV – D SEM – 2
CRDBMS JOURNAL
Product ( pid , customer id , product name , product quantity , order date )
Salesman ( salesman_id , name , city , commission )
2. Write a query to grant view and delete privileges to the user “ abc “ on
student table .
AFRE SAHIL ANILBHAI DIV – D SEM – 2 2
