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?

Differentiate between smtp and pop3 server, Differentiate between SMTP and ...

Differentiate between SMTP and POP3 server? SMTP (Simple Mail Transfer Protocol) is a protocol used to send and receive eMail messages over a TCP/IP network. While POP3 (Post

Explain what is object in java language, Explain what is Object in JAVA lan...

Explain what is Object in JAVA language? They are foundation of object oriented language. They are data structure holds data fields and properties and methods

Web application in Java.., 1. Go to www.bytesizebook.com 2. Follow the firs...

1. Go to www.bytesizebook.com 2. Follow the first link: Guide to Web Development with Java 3. Click on Examples tab 4. Go down to Chapter 4 to find all jar folders, packages, class

List down the names of two array techniques available java, List down the n...

List down the names of two array techniques available in JavaScript. The two techniques thata rae available in java script is: 1. sort( ) [sorts elements within alphabetical

Dijkstra''s algorithm, How can I convert Dijkstra''s algorithm to do max fl...

How can I convert Dijkstra''s algorithm to do max flow instead of min flow, and how can I implement it into Ford Fulkerson algorithm?

Currency calculator, I have to write a several line currency exchange rate ...

I have to write a several line currency exchange rate calculator.it wants me to use a variable and prompt var dollarAmount = Prompt("Enter amount in U.S. dollars:"); and give t

Interface, Interface to calculate carbon foot print

Interface to calculate carbon foot print

Admin panel to upload my html and psd templates, Admin panel to upload my h...

Admin panel to upload my html, php, psd templates Project Description: -Upload my psd file and convert -Login panel -Client login panel -Encryption code -Send dem

Javascript validation, Javascript validation, JAVA Programming 1. Obtaining...

Javascript validation, JAVA Programming 1. Obtaining the new script: Download and save the attached comment CGI mailer script form-mail2.pl to your server''s cgi-bin directory, and

When should a method be static, When should a method be static? • Neith...

When should a method be static? • Neither reads from nor writes to example fields • Independent of the state of the object • Mathematical methods which accept arguments, appl

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