tables in database ?

Question

i dont know how to design database for my application. i am using VB 2005 and SQL 2005, i am stuck in relationship. i have 5 tables. my question is

i want to 2 items from one table to another table like below

first table is second tables is

CustomerID OrderID
Customer Name Customer Name
ItemS ItemS
orderDate

i want two items from customer tables in order tables. so do i need to create two foreign keys in orders table because i want two items ?

Answer 1

you dont need to add two foreignkey in to other tables.always. you can add just primary key into other tables. only primary key can be foreign key into other tables.

Answer 2

You need just 1 foreign key (CustomerID, not CustomerName) in the Orders table. Give me more info if you want further help.

Answer 3

if you want to reference the data from both the tables you can use this statement

let first table be cust ,second table be order

select a.*,b* from cust a,order b where a.customer_name=
b.customer_name

Answer 4

Yes its call composit keys