Member Avatar for gowans07

I'm trying to create a database to store product and customer information.
An item have many batch numbers (batch ID)
a batch number can only belong to one item

an item can be in many products
a product contains many items

an order can contain many products
a product can be in many orders

a customer can have many orders
an order can only be for one customer

from this information i have created the following relationships.http://postimage.org/image/2fva2x890/
Is this all correct?? i think the relationship between batch ID in tbl_batch is wrong??
Cheers in advance

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by ChrisPadgham
Member Avatar for ChrisPadgham

The relationships between Customer Order and OrderProduct is wrong.

The tbl_Order should have the CustomerId as a foreign key not tbl_Order_Product.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.