April 13, 2012 at 7:02 am
Hello everyone,
I am new to this design project and I need a plan or basic flow idea for one of my project.
I should design a orders table, below are the details it should have in it.
1.Item ( name or item num), must be unique.
2.Customer name ( their should be single customer for a order)
Note: their can be zero or more items in an order.
My views to design above table:
1. Customers table
Name, Id, description,cost
2. Item_info
Item_id, name, description, cost
But I am not clear about order table
To pop up cutomerid and itemid, I can make use of Foergin key constraint from above tables.
I have no idea how should I take care of different items to be logged into table.
I know, there are things I am not clear about, But will sure address ur questions.
Please let me know. Thank you
April 13, 2012 at 7:20 am
This was removed by the editor as SPAM
April 13, 2012 at 7:21 am
What is the cardinality between two tables.
If M:M then use a juncture table.
April 13, 2012 at 8:41 am
What are the other items? And how do they relate, if at all?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply