Click here to Skip to main content
15,920,956 members
Home / Discussions / C#
   

C#

 
GeneralRe: Database Design Question/Problem Pin
Colin Angus Mackay6-Dec-06 8:01
Colin Angus Mackay6-Dec-06 8:01 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 8:37
mfcuser6-Dec-06 8:37 
GeneralRe: Database Design Question/Problem Pin
Colin Angus Mackay6-Dec-06 9:35
Colin Angus Mackay6-Dec-06 9:35 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 10:08
mfcuser6-Dec-06 10:08 
AnswerRe: Database Design Question/Problem Pin
Guffa6-Dec-06 8:02
Guffa6-Dec-06 8:02 
AnswerRe: Database Design Question/Problem Pin
User 17164926-Dec-06 8:49
professionalUser 17164926-Dec-06 8:49 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 9:03
mfcuser6-Dec-06 9:03 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 9:44
mfcuser6-Dec-06 9:44 
I don't know much about database but this is somthing similar in terms of keys relationship. Let me know if I am right. Assume that I have a table name customer than inside that table I have the following fields.

CustomerID
FirstName
LastName
PhoneNUmber
Address
City
Zipcode

Insde that table I can have a customer name Jhon, Gerry, Fred, Tony

Now, I have another table name Order, insider that table I have
OrderNumber
Price
Quantity
Total

I don't know a lot about database, but I assume there is a relationship between CustomerID and OrderNumber.

Now assume that Gerry order 1 Item, based on the following
OrderNumber = 320;
Price = $2
Quantity = 1
Total = $2

How many relationship to I have? I assume one, I also think that Gerry oder number can be retrieved from his name, order number or customer number, etc. Basically, I want to do something similar to that, for example, for one person I can have multiple order. What is different from mine, is that all the fields from the second table do not need to be filled. Some of them can be empty.


GeneralRe: Database Design Question/Problem Pin
Colin Angus Mackay6-Dec-06 10:08
Colin Angus Mackay6-Dec-06 10:08 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 10:26
mfcuser6-Dec-06 10:26 
GeneralRe: Database Design Question/Problem Pin
Colin Angus Mackay6-Dec-06 10:49
Colin Angus Mackay6-Dec-06 10:49 
GeneralRe: Database Design Question/Problem Pin
mfcuser6-Dec-06 11:02
mfcuser6-Dec-06 11:02 
GeneralRe: Database Design Question/Problem Pin
Paul Conrad6-Dec-06 11:16
professionalPaul Conrad6-Dec-06 11:16 
GeneralRe: Database Design Question/Problem Pin
Colin Angus Mackay6-Dec-06 12:03
Colin Angus Mackay6-Dec-06 12:03 
QuestionDo developers post as other users....? Pin
ednrgc6-Dec-06 7:01
ednrgc6-Dec-06 7:01 
AnswerRe: Do developers post as other users....? Pin
Colin Angus Mackay6-Dec-06 7:35
Colin Angus Mackay6-Dec-06 7:35 
AnswerRe: Do developers post as other users....? Pin
Eric Dahlvang6-Dec-06 10:08
Eric Dahlvang6-Dec-06 10:08 
Questionstore file location Pin
Kim06186-Dec-06 5:52
Kim06186-Dec-06 5:52 
AnswerRe: store file location Pin
ednrgc6-Dec-06 6:52
ednrgc6-Dec-06 6:52 
AnswerRe: store file location Pin
Ravi Bhavnani6-Dec-06 7:33
professionalRavi Bhavnani6-Dec-06 7:33 
QuestionImage size Pin
netJP12L6-Dec-06 5:29
netJP12L6-Dec-06 5:29 
AnswerRe: Image size Pin
Robert Rohde6-Dec-06 7:33
Robert Rohde6-Dec-06 7:33 
GeneralRe: Image size Pin
netJP12L6-Dec-06 8:00
netJP12L6-Dec-06 8:00 
QuestionCustom TabPage Control Pin
t4ure4n6-Dec-06 5:16
t4ure4n6-Dec-06 5:16 
AnswerRe: Custom TabPage Control Pin
Not Active6-Dec-06 5:31
mentorNot Active6-Dec-06 5:31 

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.