sql stetment
1. Create a view for the buyer table that contains the buyer number, first name, S.ID for all buyers where their seller id is 122. Name the columns (Buyer Number, Name, Seller. Id). 2. Insert a new buyer with id=80 to the view with SID=122. Choose values for the other columns. 3. Insert a new buyer with id =90 to the view with SID =123. Choose values for the other columns. 4. Recreate the view with "WITH CHECK OPTION". 5. Repeat (3) with buyer id =100. Justify your results. 6. Recreate the view with "WITH READ ONLY" 7. Repeat (3) with buyer id =110. Justify your results. 8. Create a view that contains the Seller name and number of buyers for each Seller. Second: DCL 1. Create a user; the username is your yourName universityID and the password is Test123. 2. Change the password of the new user to TestAbc. 3. Create role named admin02. 4. Give the admin02 the ability to login, create table, insert any buyer, update name of any Seller. 5. Grant admin02 role to your user. 6. Grant your user the ability to delete any buyer and the ability to grant this privilege to any user. drop table product_supplier cascade constraints; drop table seller cascade constraints; drop table Buyer cascade constraints; drop table product cascade constraints; drop table product_amountstatus cascade constraints; create table product_supplier(supplier_id number(5) primary key,supplier_name varchar2(15), address varchar2(15)); insert into product_supplier values(201,'ali','Amman'); insert into product_supplier values(202,'omar','Zarqa'); insert into product_supplier values(203, hend','Irbid'); insert into product_supplier values(204, bana','Amman'); insert into product_supplier values(205, zaid', null); create table seller(id number(5) primary key,name varchar2(15),s_position varchar2(25)); insert into seller values(121, 'said', 'Casher'); insert into seller values(122,'reem','Sales Officer'); insert into seller values(123,'ahmad','seller Assistant'); insert into seller values(124, "tina','Vendor'); insert into seller values(125,'saleem', 'Casher'); create table Buyer(buyer_id number(5) primary key,first_name varchar2(13),last_name varchar2(13), mobile varchar2(10), bdate date, s_id number(5) references seller(id)); insert into Buyer values(1, 'mohammad', 'qasem','0718333331','1-feb-1990', 121); insert into Buyer values(2,'abber','radi', '0714424442','3-oct-93',122); insert into Buyer values(3,'Imar','kamal', '0715511878','6-jan-96', 122); insert into Buyer values(4, 'lana','attar', 0716671888 ', 7-jan-90',122); insert into Buyer values(5, ' Yadi', 'ahmed', '0718111119','11-jan-90', 123); insert into Buyer values(6, "lona', 'mohammad', '0723222225','3-jun-99',124); insert into Buyer values(7, 'kamal', 'saleem', 0713963912', 7-dec-95', 122); create table product(p_name varchar2(10) primary key,supplier id number(5) references product_supplier(supplier_id). amount number(3), price number(3)); insert into product values('product1',201,50,30); insert into product values('product2',201,60,15); insert into product values('product3',203,70,10); insert into product values('product 4 ', 204, 80,20); insert into product values('product5',204, 10,25); insert into product values('product6',204,70,30); create table product_AmountStatus(status varchar2(30) primary key_lower_amount number(3), upper_amount number(3)); insert into product_AmountStatus values('not available',0,0); insert into product_AmountStatus values('very few',1,10); insert into product_AmountStatus values('available',11,40); insert into product_AmountStatus values('abundant',41,150)
