Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 74 views

    Chapter 1 Lesson Asm654

    Uploaded by

    Nurasyira Awadah
    The document discusses database normalization and why it is important. Normalization helps avoid data inconsistencies that can occur when multiple users access a database simultaneously by organizing data to reduce redundancy. It introduces the concepts of first normal form (1NF), second normal form (2NF), and third normal form (3NF) as ways to structure data to minimize duplicate and inconsistent information.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Chapter 1 Lesson Asm654

    Uploaded by

    Nurasyira Awadah
    74 views2 pages
    The document discusses database normalization and why it is important. Normalization helps avoid data inconsistencies that can occur when multiple users access a database simultaneously by organizing data to reduce redundancy. It introduces the concepts of first normal form (1NF), second normal form (2NF), and third normal form (3NF) as ways to structure data to minimize duplicate and inconsistent information.

    Original Description:

    notes

    Original Title

    CHAPTER 1 LESSON ASM654

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses database normalization and why it is important. Normalization helps avoid data inconsistencies that can occur when multiple users access a database simultaneously by organizing data to reduce redundancy. It introduces the concepts of first normal form (1NF), second normal form (2NF), and third normal form (3NF) as ways to structure data to minimize duplicate and inconsistent information.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    74 views2 pages

    Chapter 1 Lesson Asm654

    Uploaded by

    Nurasyira Awadah
    The document discusses database normalization and why it is important. Normalization helps avoid data inconsistencies that can occur when multiple users access a database simultaneously by organizing data to reduce redundancy. It introduces the concepts of first normal form (1NF), second normal form (2NF), and third normal form (3NF) as ways to structure data to minimize duplicate and inconsistent information.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    CHAPTER 1 LESSON ASM654

    QUESTIONS:

    APA ITU THIRD NORMAL FORM (3NF) & SECOND NORMAL FORM (2NF)?

    ANSWER:

    Ni tentang data normalization. Normalization in a database is the process of organizing the data to
    reduce redundancy. The main idea is to segment a larger table into smaller ones and connect them
    through a relation. But why should an end-user like you or me be concerned about Data
    Normalization?

    Why is Database Normalization important?

    Let’s assume a company stores all its data, such as employee details, personal information, etc., in a
    single table. This data is accessible to end-users such as developers, database admins (DBAs), etc.
    But what happens when multiple end-users interact with the database at the same time?

    For instance, imagine a DBA is updating the database, and during the process, a developer,
    completely unaware, performs another operation on the database. These users now have a different
    view of the database altogether.

    Such data mismatch when multiple users interact with the database simultaneously can be termed
    as an anomaly.

    This is where Data Normalization steps in. It helps in avoiding data inconsistencies and provides a
    more organized way to store your data. So, whether you’re a database administrator or just an end-
    user, you need to be aware of how your data is getting stored and what it means for the company.

    Now that we have a clear idea of what can happen without Data Normalization, let’s look at the
    various normal forms available for Database Management (DBMS).

    So ia adalah untuk mengelak data redundancy.

    What is The Difference between 2NF and 3NF? (arctype.com)


    AN OVERVIEW FOR DATA WAREHOUSING

    NOT IN 3NF (BIG DATA)

    - The data should be de-normalised to 2NF


    - This means you get data redundancy
    - This means you need more storage…
    - …but you can get at the data more quickly
    - This purpose of a DW is to provide aggregate data which is a suitable format for decision
    making

    ETL AND DATA MARTS

    1. Extraction, Transformation and Loading

    - (E – EXTRACTION) Get the data

    - (T- TRANSFORMATION) Make it useful

    - (L-LOADING) Save it to the warehouse

    2. Data Marts (Sub-sets of the DW)

    - Don’t mess with the data

    -Keep it simple for the user

    -Small problems are easier to solve

    You might also like