1. BA471Management InformationSystems Databases - continued

2. Database Fundamentals • Data modeling – next steps • Create an ERD • Logical design • Relational • Data definitions • Business definitions • Metadata • Domain

3. Database Fundamentals • Physical data design • Forward engineer a physical database • DDL – Data Definition Language • Creates Schema • Role of the Database Administrator (DBA)

4. Database Fundamentals • Data normalization: Physical implementation of data in its logical groupings • De-normalized data example:

5. Database Fundamentals • Normalized example: ORDER ORDER-PRODUCT First Normal Form (1NF)

6. Database Fundamentals • Normalized example (3NF):

7. Database Fundamentals • Enterprise Data Warehouse ERP Product Data extract EDW Summarized Product Data Reports Online Inquiry Finance Sys Product Revenue Data extract

8. Database Fundamentals • Data Quality issues • Ways in which data quality can be compromised • Errors at data entry • Software-introduced errors • Deterioration over time • Sabotage • Honest mistakes