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?

What is the difference between SOA and a Web Service, Normal 0 ...

Normal 0 false false false EN-US X-NONE X-NONE

Cryonic labs, Cryonic Labs Project Description: Seeking people to col...

Cryonic Labs Project Description: Seeking people to collaborate with in designing gaming apps and mobile apps for the Android Market. I'm presently a student in Computer Engi

Difference between bean factory and application context, On the surface, an...

On the surface, an application context is similar as a bean factory. But application context offers much more.. ? Application contexts give a means for resolving text messages,

What do you understand by java virtual machine, Java Programming 1. Wha...

Java Programming 1. What do you understand by Java Virtual Machine? 2. Write a simple Java program to display a string message and explain the steps of compilation and execu

Develop tennis draw software, Project Description: We need to develop so...

Project Description: We need to develop software that has a database of players with the ability to delete and add players at will, once captured there can be a draw to set them

Using the Case Study supplied, The report: Your report must describe the re...

The report: Your report must describe the requirements of the application, outline the design of the solution, and provide a testing procedure to prove the application works. In yo

Imagemagick or same as text png generation, Imagemagick or same as text png...

Imagemagick or same as text png/jpg generation expert needed Project Description: Require someone who is experienced with generating text images. You will use any of the soft

Explain the char data type in java, Explain the char data type in java? ...

Explain the char data type in java? A char is a single character in which a letter, a digit, a punctuation mark, a tab, a space or something same. A char literal is a single on

Write a program on clearing rectangles, Write a program on clearing Rectang...

Write a program on clearing Rectangles ? It is also potential to clear a rectangle that you've drawn. The syntax is exactly what you'd expect: public abstract void clearRect

What type of operations takes place inside microprocessors, What type of op...

What type of operations takes place inside Microprocessors Building Blocks? Enlist them along with brief description. Bus Interface Unit: The bus interface unit is the part o

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