I need assistance please creating an erd for a small businesse-commerce website.
- Customer – name, billing address, shipping address, paymentinfo, etc.
- Inventory – descriptions, category, quantity, unit price,etc.
- Order – date, payment info, etc.
- OrderLineItem – typical shopping cart line items
- Supplier – vendor info for items purchased by the company(multiple vendors per item)
- Invoice – items purchased by your company
- InvoiceLineItem – same concept as shopping cart
- FeeAreas – list of states for sales tax and shipping cost
These are the required entities and I am having a hard timeplacing them in crowsfoot notation w/ cardinality due to my lack ofunderstanding of relationships. Serious help please 😀
Expert
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured