I need a short paragraph about the ERD in general:
Here is another picture for the system to help you in explaining the ERD:
CustAddress CustID CustEmail Partid Type UnitPrice CustName CustPhone (PRO ID) auto parts Qty Customer Accounts (SOID)) Qty ) Y PRO contains (PartID) (PartID) SO contains places PRO ID SuppName SO Total reorders purchase re-orders supplier accounts SuppEmail sales orders SuppLocation PRO Date SO Date PRO Total SupplD SuppPhone SO ID EagleDyne Level O DED Deleted Acct. Info D1 Cust. Acct Archive DB Deleted Acct. Info Cust. Act. Delete Request D2 Cust. Acct. DB Cust. Name, Loc., Ph#, Email (Cust info) Cust. Info + ID# Cust. Account Deletion Request Maintain Cust. Data Part Desc, Keywords Cust ID, Part, Date, Unit Price, Total Customer Qty of parts Purchase confirmation Sales Order Process D3 Sales Order DB SO Confirmation Deleted Acct. Info D4 Supp. Acct Archive DB Deleted Acct. Info 3 Maintain Supplier Data Acct. Delete Request Supplier info+ID D5 Supp. Acct DB Acct. Delete Request Supp. Name, Loc., Email, Ph#(Supp. Info) Manager Part Desc, keywords Mngr, Part, Qty, UnitPrice, Total Quantity of Parts D6 Purch. Re-Order DB Purchase re-order Processing Purchase confirmation Purchase Re-order confirmation D7 Inventory Archive DB Deleted acct.info Part name, desc, type, unit price, qty (part info) Part Deletion Request Deleted acct.info Maintain Inventory Data D8 Inventory DB Part deletion request Part Info + ID# Inventory report request Inventory report request Inventory report Purchase Re-order report request Purchase re-order report 6 Display Summary Reports Sales Order Report request Purchase Re-order report request Inventory report Purchase re-order report Sales order report Sales Order Report request Sales order report CustAddress CustID CustEmail Partid Type UnitPrice CustName CustPhone (PRO ID) auto parts Qty Customer Accounts (SOID)) Qty ) Y PRO contains (PartID) (PartID) SO contains places PRO ID SuppName SO Total reorders purchase re-orders supplier accounts SuppEmail sales orders SuppLocation PRO Date SO Date PRO Total SupplD SuppPhone SO ID EagleDyne Level O DED Deleted Acct. Info D1 Cust. Acct Archive DB Deleted Acct. Info Cust. Act. Delete Request D2 Cust. Acct. DB Cust. Name, Loc., Ph#, Email (Cust info) Cust. Info + ID# Cust. Account Deletion Request Maintain Cust. Data Part Desc, Keywords Cust ID, Part, Date, Unit Price, Total Customer Qty of parts Purchase confirmation Sales Order Process D3 Sales Order DB SO Confirmation Deleted Acct. Info D4 Supp. Acct Archive DB Deleted Acct. Info 3 Maintain Supplier Data Acct. Delete Request Supplier info+ID D5 Supp. Acct DB Acct. Delete Request Supp. Name, Loc., Email, Ph#(Supp. Info) Manager Part Desc, keywords Mngr, Part, Qty, UnitPrice, Total Quantity of Parts D6 Purch. Re-Order DB Purchase re-order Processing Purchase confirmation Purchase Re-order confirmation D7 Inventory Archive DB Deleted acct.info Part name, desc, type, unit price, qty (part info) Part Deletion Request Deleted acct.info Maintain Inventory Data D8 Inventory DB Part deletion request Part Info + ID# Inventory report request Inventory report request Inventory report Purchase Re-order report request Purchase re-order report 6 Display Summary Reports Sales Order Report request Purchase Re-order report request Inventory report Purchase re-order report Sales order report Sales Order Report request Sales order report
