80 likes | 183 Vues
Learn essential Database Fundamentals including Entity-Relationship Diagram creation, logical and physical design, normalization, DDL, and more. Understand the role of a Database Administrator (DBA) and how to ensure data quality.
E N D
BA471Management InformationSystems Databases - continued
Database Fundamentals • Data modeling – next steps • Create an ERD • Logical design • Relational • Data definitions • Business definitions • Metadata • Domain
Database Fundamentals • Physical data design • Forward engineer a physical database • DDL – Data Definition Language • Creates Schema • Role of the Database Administrator (DBA)
Database Fundamentals • Data normalization: Physical implementation of data in its logical groupings • De-normalized data example:
Database Fundamentals • Normalized example: ORDER ORDER-PRODUCT First Normal Form (1NF)
Database Fundamentals • Normalized example (3NF):
Database Fundamentals • Enterprise Data Warehouse ERP Product Data extract EDW Summarized Product Data Reports Online Inquiry Finance Sys Product Revenue Data extract
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