answersLogoWhite

0

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.
Database normalization saves storage space and makes the data easier to index and analyse. Querying highly normalized relational databases can become quite complex since a large number of tables may need to be linked together.

User Avatar

Wiki User

12y ago

What else can I help you with?

Continue Learning about Natural Sciences

What are the 3 primary GIS data types that GPS receivers collect?

The 3 primary GIS data types that GPS receivers collect are: spatial data (latitude and longitude coordinates), attribute data (information about the location like elevation or time), and metadata (details about the data collection process such as accuracy or date).


What is the difference between DBMS and GIS?

A DBMS (Database Management System) is a software system that manages databases, storing, organizing, and retrieving data. GIS (Geographic Information System) is a specialized system for capturing, storing, analyzing, and visualizing spatial or geographic data. While both involve managing data, GIS focuses specifically on geographic information.


What are the components of gis?

A GIS is a computer system capable of capturing, storing, analyzing, and displaying geographically referenced information; that is, data identified according to location. Practitioners also define a GIS as including the procedures, operating personnel, and spatial data that go into the system.GIS based application is a five staged process or we can say GIS have 5 components that involves the following:Data AcquisitionPre ProcessingPost ProcessingData ManagementData RenderingIf you wan't more information about these GIS steps visit the related links for detailed information about GIS and its component. This is the link of a company named Albireo Telematics which is a leader in GIS services, so I think they will answer your question the best way.


How are GIS and GPS related?

GPS (global positioning system) gathers geographic positioning data and converts to a file that can be used by a GIS (global information system) which can map it to show the location of the actual coordinates.


What means GPS and GIS?

GPS is Global Positioning System, which locates positions on the ground with the use of GPS receivers. This capability of often used to make fairly accurate maps, one kind of which is GIS maps.GIS is Graphic Information System, which stores database information in computer maps. For instance, a city could use GIS to keep track of all its water meters, where they are, what brand, what style, what size, how old, when last serviced, last meter readings, and so forth.Parks departments could use GIS to keep track of its trees, the species, when planted, when last pruned, how healthy, and so forth.The surveying department could use GIS to track survey markers, their precise locations, what type of monument they are, how old, what agency installed them, and photos of what they look like.

Related Questions

What are the role of normalisation in dbms?

with this normalisation only we reduce redudency


What are the disadvantages of normalisation?

When we use Normalisation it does not allow some of the modifications of the database. Another disadvantage of Normalisation is that it is only applicable in the Relational Database Management System.


What is the difference between normalisation and denormalisation?

Hi, Normalisation is used to reduce the redundancy of database. So, we divide the the data into smaller tables. These tables are related to each other through a relationship. Denormalisation is the reverse process of normalisation. In this we add redundancy of data and grouping of data to optimize the performance.


What normalisation is used in IEEE 754 format?

none, it uses denormalization.


What do the initials GIS stand for?

What GIS stand for in genetics


Why is normalisation necessary?

Normalisation is necessary in database because of following:It eliminates data redundancy. Same data do not occur in more than one places.By making use of normalisation query process is easy.Data entry time is saved as the tables are broken down in repeating and not repeating fields.Data modification is made easy.Database becomes more flexibleInconsistent dependency is eliminated


When was GRASS GIS created?

GRASS GIS was created in 1984.


When was Quantum GIS created?

Quantum GIS was created in 2009.


What is the difference between GIS and cartography?

GIS is basically cartography on a computer (information system). So GIS is an application of cartography.


If you earn a certificate in GIS is it appropriate to use GIS after your name?

Earning a certificate in GIS is not the same as GIS certification. Unless the certificate program you attended results in a higher degree such as a Bachelor's or Master's degree, there are no initials you can place after your name. GIS certification is a fee-based process currently handled by the GIS Certification Institute (GISCI), that evaluates the GIS proficiency of an individual by assessing their experience, education, and contributions to the GIS industry. Those individuals awarded certification by the GISCI may place the acronym GISP (for GIS professional) after their name.


Which geographic tool uses computer technology to collect manipulate analyze and display data about the earths surface?

GIS


When was TeleCAD-GIS created?

TeleCAD-GIS was created in 2002-02.