Levels of Data Models

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

Levels of Data Models

Levels of Data Models

Presentation Transcript

Data models

Data Models

Data Models

Data Models

Data Models

Using Competency Models for Higher Levels of Performance

Data Models

Data Models

Data Models

Data Models

DATA MODELS

Data Models

Data Models

Data Models

Levels of Abstraction (Views of Data )

Data Models: Degrees of Data Abstraction

Data Models

Data models

Data Models

Data Models

Levels of measurement of data

Data Models