Question

please answer my question it's very urgent​

Answer 1

Answer:

i)

create table product

(PID char(4),

Pname varchar(20),

Description varchar(40),

Price decimal);

ii)

PID should be used as primary key because it is different for every Pname. So, it's uniquely identify the row.

iii)

a)

select *from vendor;

b)

insert into vendor

values('V005', 'Vadilal', '2010-03-20', 'Pune');

c)

update vendor

set location='Gujarat'

where vendorID=V003;

hope this will help you__^_^___

Answer 2

Answer:

hikjjhhhhhhhhhhhhhhbhhhhhhhhhhbbh