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 java flow control, Explain java flow control ? if els...

Explain java flow control ? if else else if while for do while switch case break continue goto is a reserved word.

Change encrypted hsql database into csv format, Change encrypted HSQL datab...

Change encrypted HSQL database into CSV format Project Description: We have an encrypted HSQL Database which we have to convert into csv format. HSQL DB . We have java app

Concurrent Programming, Problem 1 A savings account object holds a non-nega...

Problem 1 A savings account object holds a non-negative balance, and provides deposit(k ) and withdraw(k ) methods, where deposit(k ) adds k to the balance, and withdraw(k ) subtra

Illustrate dynamic vs. static class loading?, 1. "Classes are statically lo...

1. "Classes are statically loaded with Java's "new" operator." This would imply that static methods could be executed without the class being loaded. 2. "Unlike the static loa

Exportobject of unicastremoteobject do, What does the exportObject of Unica...

What does the exportObject of UnicastRemoteObject do? Ans) Exports the remote object to make it available to receive incoming calls, using the certain supplied port. If port not

Design a website in java using xml, The design of the website will be left ...

The design of the website will be left to the individual student. The website must be written only in xml, displayed in xhtml using transforms and xsl for styling elements. Javascr

Encapsulation, Defines to keeping all the related members together in an ob...

Defines to keeping all the related members together in an object. Specifying member variables as private may hide the methods and variables. Objects should hide their inner working

Describe inner classes in java, Describe Inner Classes in java? An inne...

Describe Inner Classes in java? An inner class is a class whose body is described inside another class, referred to as the top-level class. For instance: public class Queue {

Linked list, i want code for to print prime numbers in the linked list queu...

i want code for to print prime numbers in the linked list queue and stack and array in java programming

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

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