Click here to Skip to main content
14,327,298 members
   

Database

 
QuestionHow to use sql server database into oracle Pin
Arun kumar Gautam7-Mar-13 1:05
memberArun kumar Gautam7-Mar-13 1:05 
AnswerRe: How to use sql server database into oracle Pin
Sandeep Mewara7-Mar-13 1:10
mentorSandeep Mewara7-Mar-13 1:10 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 1:13
memberDavidduraisamy7-Mar-13 1:13 
GeneralRe: How to use sql server database into oracle Pin
mhd.sbt7-Mar-13 21:06
groupmhd.sbt7-Mar-13 21:06 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 21:30
memberDavidduraisamy7-Mar-13 21:30 
GeneralRe: How to use sql server database into oracle Pin
mhd.sbt7-Mar-13 21:59
groupmhd.sbt7-Mar-13 21:59 
QuestionCreate a table for prices Pin
MedZi20106-Mar-13 18:10
memberMedZi20106-Mar-13 18:10 
AnswerRe: Create a table for prices Pin
Anish_Chakraborty7-Mar-13 0:43
memberAnish_Chakraborty7-Mar-13 0:43 
Well, there are multiple ways to solve a problem. It depends on whether you want to achieve speed or whether you want to have a normalized database. Here's what I would have done:

Have a table called Products: ProductID, ProductCode, ProductName,...
Have a table called Cities: CityID, City Name
Have a table called Prices: PriceID, Price
Have a table for mapping products with prices and cities, ProductPrice: ProductID, CityID, PriceID

Pro: This way your data remains in a normalized form which is considered to be a good design approach.
Con: You have to perform multiple joins while fetching data which will hamper performance a bit. But, I don't think you have millions of cities. So, I won't be bothered much with that.

Hope it helped. Smile | :)
GeneralRe: Create a table for prices Pin
Davidduraisamy7-Mar-13 1:10
memberDavidduraisamy7-Mar-13 1:10 
AnswerRe: Create a table for prices Pin
Sandeep Mewara7-Mar-13 1:08
mentorSandeep Mewara7-Mar-13 1:08 
AnswerRe: Create a table for prices Pin
MedZi20107-Mar-13 15:29
memberMedZi20107-Mar-13 15:29 
Questionretrieving 3 working days Pin
Member 87018135-Mar-13 7:53
memberMember 87018135-Mar-13 7:53 
AnswerRe: retrieving 3 working days Pin
Mycroft Holmes5-Mar-13 12:01
memberMycroft Holmes5-Mar-13 12:01 
Questionchecking whether today's date is public holiday Pin
Member 87018134-Mar-13 7:08
memberMember 87018134-Mar-13 7:08 
AnswerRe: checking whether today's date is public holiday Pin
David Mujica4-Mar-13 8:20
memberDavid Mujica4-Mar-13 8:20 
AnswerRe: checking whether today's date is public holiday Pin
Mycroft Holmes4-Mar-13 11:43
memberMycroft Holmes4-Mar-13 11:43 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 21:28
memberMember 87018134-Mar-13 21:28 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 21:41
memberMember 87018134-Mar-13 21:41 
QuestionActivate reminder for event to send email notification 3 days before event Pin
Member 87018133-Mar-13 6:01
memberMember 87018133-Mar-13 6:01 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Mycroft Holmes3-Mar-13 11:59
memberMycroft Holmes3-Mar-13 11:59 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Sandeep Mewara3-Mar-13 18:45
mentorSandeep Mewara3-Mar-13 18:45 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Davidduraisamy4-Mar-13 23:52
memberDavidduraisamy4-Mar-13 23:52 
Questionpeak hours query Pin
Jassim Rahma2-Mar-13 23:38
memberJassim Rahma2-Mar-13 23:38 
AnswerRe: peak hours query Pin
Mycroft Holmes3-Mar-13 12:02
memberMycroft Holmes3-Mar-13 12:02 
AnswerRe: peak hours query Pin
Bernhard Hiller3-Mar-13 20:39
memberBernhard Hiller3-Mar-13 20:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.