..how to make database for different city having different prize of same product.

Question

1.00/5 (1 vote)

See more:

for example :
i have two city like Mumbai, pune
and i have product like laptop,and mobile and also having different prize on base of city
when we select city like mumbai ,product like mobile prize is 200rs
and when we select city like pune ,product like mobile prize is 500rs
how it done?..

Posted 19-Feb-14 19:24pm

Rajnish D mishra

Add a Solution

3 solutions

Solution 1

firstly please specify on which field you have primary key?
you can do like
SELECT prize FROM item_master WHERE product like 'mobile' and city like 'mumbai' from the same table.

Posted 19-Feb-14 19:34pm

Shah Parth P

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

prakashdotnet · Accepted Answer · 2014-02-19T19:41:00

SQL

Create table Product
(ProductID INT IDENTITY(1,1)
 ,ProductCode VARCHAR(50)
,ProductName VARCHAR(100)
);
Create table ProductPrice
(
ProductPriceID INT IDENTITY(1,1)
,ProductID INT 
,CityID INT
,Price NUMERIC(20,4)
)

Create table City
(
CityID INT IDENTITY(1,1)
,CityName VARCHAR(100)
)

add fk for city id and product id on Productprice table

Ramug10 · Accepted Answer · 2014-02-19T20:04:00

You can setup your DB like below.

CREATE TABLE PRODUCT
(PRODUCTID INT IDENTITY(1,1)
 ,PRODUCTCODE VARCHAR(50)
,PRODUCTNAME VARCHAR(100)
);
CREATE TABLE PRODUCTPRICE
(
PRODUCTPRICEID INT IDENTITY(1,1)
,PRODUCTID INT 
,CITYID INT
,PRICE NUMERIC(20,4)
)
 
CREATE TABLE CITY
(
CITYID INT IDENTITY(1,1)
,CITYNAME VARCHAR(100)
)
 
 SELECT C.CITYNAME,P.PRODUCTNAME,PP.PRICE FROM PRODUCT P
 INNER JOIN PRODUCTPRICE PP ON P.PRODUCTID = PP.PRODUCTID
 INNER JOIN CITY C ON C.CITYID = PP.CITYID
 WHERE C.CITYID=1

ProductID,CityID are Foreign Keys in ProductPrice table

..how to make database for different city having different prize of same product.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0