NORMALIZATION AND SQL DDL STATEMENTS Essay Example | Topics and Well Written Essays - 500 words

NORMALIZATION AND SQL DDL STATEMENTS - Essay ExampleAtomicity ensures that no incomplete transactions be always executed by the system which ensures the state of data always remains stable despite some(prenominal) hardw are/software failures. Consistency ensures that only those transactions will execute that do not demoralise any of the database consistency rules which ensures data remains valid. Isolation ensures uninterrupted single transaction processing e.g. the concurrent transaction requests are handled serially i.e. one transaction at a time. Durability ensures that transactions are logged and therefore transactions can be rolled back at any time.Database normalization is a set of guidelines that helps in organizing data efficiently which improves the overall performance of a DBMS. It helps remove data wordiness (does not allow duplicate data storage in multiple tables) which in turn reduces the berth consumed by database. Furthermore, it improves data consistency by all owing only sensible and logical data dependencies between tables (e.g. a table stores only data that is related). There are five normal forms of database 1NF, 2NF, 3NF, BCNF and 4NF. Mostly, normalization till the trinity form is enough for most database system applications. 1NF helps eliminate duplicate column from a table and identifies quaint column(s) i.e. through primary key. 2NF separates data subsets into separate tables forming foreign keys. And 3NF ensures all columns in a table are dependent only on the primary key.The exercise helped in understanding the concept of ACID stupefy and offered a hands-on approach to designing and optimizing a database design. It helped in practicing the application of the most widely use normalization guidelines on a previously formed database model. Furthermore, it also helped practice the DDL statements involved in the unfeigned creation of a database application in