Home » Developer & Programmer » Designer » Doubt in database design (Oracle 10g sql plus)
Doubt in database design [message #555875] Tue, 29 May 2012 10:17 Go to next message
gokul1242
Messages: 1
Registered: May 2012
Location: Chennai
Junior Member
Hi i am creating a database design for an online shopping site.In the customer database i collect all the customer information such as name,dob,address,user_name etc and store in a table.now when the customer is buying a product if he wants the product to be delivered to some other address which is not the same address what he gave in the customer information table.then where can i store the new address in the database.do i need to create a separate table for storing the address or is there any other way??

Report message to a moderator

Re: Doubt in database design [message #555878 is a reply to message #555875] Tue, 29 May 2012 10:26 Go to previous messageGo to next message
John Watson
Messages: 8738
Registered: January 2010
Location: Global Village
Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Your problem is to do with the data model: you need to set up a one-to-many relationship between a table of customers and a table of addresses. Google for DATA NORMALIZATION or perhaps ENTITY RELATIONSHIP MODEL and you will find plenty of advice.

Report message to a moderator

Re: Doubt in database design [message #555880 is a reply to message #555878] Tue, 29 May 2012 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also read our Normalization wiki page.

Regards
Michel

Report message to a moderator

Re: Doubt in database design [message #580804 is a reply to message #555880] Thu, 28 March 2013 05:37 Go to previous message
Alanjohn
Messages: 2
Registered: March 2013
Location: New York, USA
Junior Member
You need to build new data base table in which customers write their new information and make connection of it with old content table. By this why you can automatically get solution of your problem.

Report message to a moderator

Previous Topic: Natural join in ERD
Next Topic: Fact Table Design
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 12 01:50:49 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.