Question

Need help with my crows foot notation on my visio diagram. Are my notations correct? If not, how should they be?

Customers PK ID Purchase Orders Lineltems FirstName LastName StreetAddress City State Zip PK OrderID FK1 CustomerID Date PK,FK1 OrderlD PK LineNumber SubTotal ProductlD Quantity ExtendedPrice FK2 Tax ota Email OptionAssociati PK,FK1 OrderID PK,FK2 ProductlD PK,FK3 OptionlD Products PK ProductID Intersections Options ProductType ProductName ImageFile UnitPrice MaxAmount DefaultAmount PK,FK2 ProductID PK,FK1 OptionID PK OptionID OptionType OptionName OptionCOst

Answer 1

Here, the relationship between the entity Purchase Orders and Customer is change to "Zero or One or Many" as there can be more than one orders at a time.

for example :- We can make more than one orders at a time in amzon form one Customers Id.