Question

create a database for a stationery shop. hint :create fields for items, price, color, vendor, etc. plz give answer properly...

Answer 1

Create table stationery(items varchar2(10), price number, color varchar2(10), vendor varchar2(10));

Answer 2

Query for creating a database for a stationary shop :

• Database Query:

Create table stationary_shop (

item_id int (10) NOT NULL ,

item_name varchar (20) NOT NULL ,

item_price int (10) NOT NULL ,

item_quantity varcar (20) NOT NULL ,

item_color varchar (10) ,

vendor_name varchar (20) NOT NULL ,

PRIMARY KEY ( item_id )

) ;

• This will create a database table named stationary_shop having fields as item_id , item_name , item_price , item_color , vendor_name .