Hi dudes,

I am a newbie to the database, I have drawn a E-R diagram, but I ain't sure if it makes any sense to you guys.

Hi,
Yes, you certainly need some help here. I apologize for not giving you a conceptual model myself, I'm tired.

Customer, Orders and Items.
Customers know about, request, or purchase, etc. 'Items' through an order. So customers don't generally have a direct relationship to the 'Items'.

An item can be on zero, one or many orders.
An order can be for one or many items.
SO ... you see there's a many to many between order and items.

Here's a model link for you. Replace the 'Aircraft Parts' entity with your 'Items' entity.

It appears you don't need the Customer Quotation and Quotation Items entity.

http://www.databaseanswers.org/data_...arts/index.htm

Enjoy!!
Vmusic

Thanks a lot mate!!

Marked! I will come back to check this soon!thanks a lot.:-)
demande credit
immobilier simulation pret de france taux calcul
courtierUne simulation credit immobilier de France
a faire un
pret.demande
credit immobilier simulation pret de france taux calcul
courtier