Oracle Application DBA Information

Tuesday, 3 May 2016

Database Normalization explained.

Understanding and mastering database normalization techniques is essential in order to achieve a high performance database design for your system. If your design doesn't conform to (at least) the Third Normal Form (3NF), chances are high that you will find it hard to achieve the performance needed for a successful application.

Furthermore, you will find that writing good DML-statements (SELECT, UPDATE, INSERT or DELETE) is difficult, and sometimes actually impossible, without using a lot of procedural coding (PL/SQL in Oracle, VB/C# in Microsoft products).

Many "experts" will tell you that if you do database normalization up to (and including) the Third Normal Form, you're well off. The Database Normalization eBook shows you that this a far too easy approach, and it is richly documented with graphical Entity Relationship and Server Diagram examples. for more Detail Click Here!
Posted by appsdba.furqan at 04:22
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
appsdba.furqan
View my complete profile

Blog Archive

  • ►  2024 (15)
    • ►  February (1)
    • ►  January (14)
  • ►  2023 (4)
    • ►  December (4)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (15)
    • ►  November (5)
    • ►  September (7)
    • ►  August (1)
    • ►  January (2)
  • ►  2019 (30)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
    • ►  June (14)
    • ►  May (3)
    • ►  April (7)
    • ►  January (1)
  • ►  2018 (13)
    • ►  August (1)
    • ►  July (1)
    • ►  June (11)
  • ►  2017 (31)
    • ►  December (2)
    • ►  November (22)
    • ►  March (7)
  • ▼  2016 (66)
    • ►  October (9)
    • ►  August (4)
    • ►  July (19)
    • ▼  May (34)
      • How to Resolve ORA-01102: cannot mount database in...
      • Resolving Gaps in Data Guard Apply Using Increment...
      • Oracle Linux 6 Installation Step by Step Guide
      • Find out APPS/SYSADMIN password in Oracle Apps R12...
      • Oracle User info using Process ID
      • Configuring Flashback Database through SQL
      • MAINTAINING ONLINE REDO LOG FILES
      • Oracle Password File 10gr2 & 11gr2
      • Gather system (CPU) stats using DBMS_STATS
      • Oracle RAC(Real Application Cluster) DBA Interview...
      • Statspack
      • Oracle initialization parameter file
      • Oracle Startup Process
      • Oracle Background Process
      • Database Normalization explained.
      • Create Recovery Catalog Rman
      • Archivelog History Checking
      • Auditing On 10gr2 & 11gr2
      • Find Power Privileges given to users
      • Duplicate Oracle database on the same server
      • Oracle Database V$ Views
      • DBMS_SQLTUNE | SQL Tuning Task using SQL_ID
      • Data Guard Implementation (For Oracle 10g R2 ...
      • Enable remote desktop on linux using VNC
      • execute shell script USING DBMS_SCHEDULER
      • Check RMAN command / script syntax
      • Verify Database 32/64 bit creation
      • DB Buffer Usage Query
      • CPU USAGE BY current Users
      • difference between core dba and apps dba
      • Changing Database link password without recreating
      • Dataguard Health Check Query's
      • CMCLEAN.SQL FOR EBS R12
      • PRIVILEGES MANAGEMENT & TABLESPACE MANAGEMENT ( Al...
Simple theme. Powered by Blogger.