Download
ba471 management information systems n.
Skip this Video
Loading SlideShow in 5 Seconds..
BA471 Management Information Systems PowerPoint Presentation
Download Presentation
BA471 Management Information Systems

BA471 Management Information Systems

76 Vues Download Presentation
Télécharger la présentation

BA471 Management Information Systems

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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