Product Table PRODUCT ID PKI PRODUCT NANEI PRODUCT PRICE POD

Product Table PRODUCT ID PKI PRODUCT NANEI PRODUCT PRICE PODUCT TTPE ID FKI B209 Bottled water $199 Span lingWater $249 Sam Pellegrino Raspbenry Lime $249 Lemon Seltzer $249 Orgric Strawbery $249 poradise Juice 8249 Green Tea Bottled Lemonade 6259 Iced Tea 8209 Lemonade 8209 Ked Green Tea 1 Iced Chai Tea Lotte 6209 Carrot Pineapple $389 Power Smoothie Low Fat Strawbery Barama Power oothie 1 Smoothie $4.29 Superfruit Power $429 Frozen Caramel 29 Hot Coffee B209 Hot Tea $169 1 Iced Coffe 1 Hot Chocolate $2.09 Tea Latte E389 8169 2 Travel Refill 1 Caramel Latte $3.39 1 1 Caffe Latte $339 1 Skiray Caffe 2 Peppermint Mocha E39 2 Caffe Mocha $3.39 1 2 Cappuccino E339 1 2 Espresso 1 2 Iced Caramel 63.89 1 elLatte 2 Iced Coffe ntochan 3.89 1 2 Iced Caffe Latte E339 1 2 Juice E249 2 Apple Juice 69 2 3169 2 Chocolate 3119

Solution

Your scenario should be considered from creation point of view :

Generally primary key should not have duplicate values.

But in this case you need to insert the same product_id values 1 and 2 many times.

For this create the table with the primary key composed of product_id and product_name to maintain uniqueness.

create table product(product_id number,product_name varchar2(20),product_price varchar2(5),product_type_id number,primary key(product_id,product_name),foreign key(product_type_id) references product_type(product_type_id));

Now insert

insert into product values(1,\'soda\',\'$2.09\',5);