Illustrate normalization? , JAVA Programming

Assignment Help:

 

Normalization is a design technique that is mostly used as a guide in designing relational databases. Normalization is necessary a two step process that gives data into tabular form by removing repeating groups and then replaces duplicated data from the relational tables.

Redundant data wastes disk space and builds maintenance problems. If data that allows in more than one place must be modified, the data must be modified in exactly the same way in all locations which is prone to errors and time consuming. A modification to a customer address is much simpler to do if that data is stored only in the Customers table and now in the database.

Inconsistent dependency is a database structure that makes certain assumptions about the location of data. As, while it is intuitive for a user to look in the Customers table for the address of a particular client, it may not create sense to look there for the salary of the employee who invokes on that customer. The employee's salary  is  exist  to,  or  dependent  on,  the  employee  and  thus  could  be  placed  to  the  Employees  table. Inconsistent dependencies can create data difficult to access because the path to find the data cannot be logical, or may be
broken or missing.

 

 

1546_Normalisation.png


Related Discussions:- Illustrate normalization?

Explain nested classes (or outer and inner classes) in java?, In Java not a...

In Java not all classes must be described separate from each other. You may put the definition of one class under the definition of another class. The class inside class is called

Explain what is constructors, Explain what is constructors ? It is freq...

Explain what is constructors ? It is frequent the case in which overloaded techniques are essentially the similar except that one supplies default values for a few of the argum

To change c code and place into a java application, To change c code and pl...

To change c code and place into a java application Project Description: To change c code and place into a java application Skills required are C Programming, Java, Softwar

Implement decision tree algorithm using netbeans, Implement Decision Tree A...

Implement Decision Tree Algorithm using Netbeans (Java) & Microsoft Access 2007. "One Level is enough, output should contains gain of each attribute, the selected attribute and

Javascript to calculate the cost of each book, Write JavaScript code that i...

Write JavaScript code that is executed during form submission to calculate the cost of each book (based on quantity specified) and the overall total cost. The results should be dis

Catch clause should be used to handle the exception, How does a try statem...

How does a try statement determine which catch clause should be used to handle the exception?

How to implementing the cloneable interface, How to Implementing the Clonea...

How to Implementing the Cloneable Interface The java.lang.Object class contains a clone() method which returns a bitwise copy of the current object. protected native Object cl

Explain declaring- allocating and initializing two dimension, Explain the f...

Explain the following terms declaring, Allocating and initializing two dimensional array? Two dimensional arrays are declared, allocated and initialized much such as one dimens

Creating applications based on soa, Creating applications based on SOA ...

Creating applications based on SOA Select your implementation technologies carefully. Carefully check if Web services are suitable. Sometimes using traditional methods suc

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd