50 likes | 114 Views
This data model represents the different levels of data in an enterprise sales management system, including conceptual and relational models. It encompasses entities such as orders, customers, sales representatives, products, and warehouses.
E N D
Levels of Data Models Enterprise Conceptual Relational
ORDER_LINE Enterprise Data Model SALES_REP CUSTOMER Sells_to Places_Order PART ORDERS
C_ C_ STREET SR_ FIRST FIRST C_ C_ TOTAL_ LAST SR_ SLSREP_ CUSTOMER C_STATE CITY COMMISSION NUMB LAST _NUMBER C_ ZIP_ CODE SR_ SALES_REP CUSTOMER Sells_to ZIP_CODE CREDIT_ LIMIT SR_ COMMISSION STREET _RATE BALANCE SR_ SR_CITY STATE Places_Order ITEM_ PART_ CLASS QUOTED DESCRIPTION _PRICE PART_ NUMBER ORDERDATE PART ORDERS UNITS_ ORDER_LINE ON_HAND ORDER_ NUMBER NUMBER_ UNIT_ ORDERED WAREHOUSE PRICE _NUMBER Conceptual Data Model
SLSREP_ NUMB CUSTOMER _NUMBER PART_ NUMBER ORDER_LINE ORDER_ NUMBER Relational Data Model C_ C_ STREET SR_ FIRST FIRST C_ C_ TOTAL_ LAST SLSREP_ SR_ CUSTOMER C_STATE CITY COMMISSION NUMB LAST _NUMBER C_ ZIP_ CODE SR_ SALES_REP CUSTOMER Sells_to ZIP_CODE CREDIT_ LIMIT SR_ COMMISSION STREET _RATE BALANCE SR_ SR_CITY STATE Places_Order ITEM_ PART_ CLASS QUOTED DESCRIPTION _PRICE PART_ NUMBER ORDERDATE PART ORDERS UNITS_ ON_HAND ORDER_ NUMBER NUMBER_ UNIT_ ORDERED WAREHOUSE PRICE _NUMBER
ORDER_LINE Enterprise Data Model SALES_REP CUSTOMER Sells_to Places_Order PART ORDERS