Normalization is the process in which a database is designed in a way that removes redundancies, and increases the clarity in organizing data in a database.
Normalization of a database helps in modifying the design at later times and helps in being prepared if a change is required in the database design. Normalization raises the efficiency of the data base in terms of management , data storage and scalability.
Now Normalization of a database is achieved by following a set of rules called ‘forms’in creating the database.
These rules are 5 in number (with one extra one stuck in-between 3&4) and they are `1ST Normal Form or 1NF:
Category: Data Base
What is RDBMS?
A relational database uses the concept of linked two-dimensional tables which comprises of rows and columns. A user can draw relationships between multiple tables and present the output as a table again. A user of a relational database needs not to understand the representation of data in order to retrieve it. Relational programming is non-procedural.
What is DBMS?
MySQL and mSQL are database management systems or DBMS. These software packeges are used to manipulate a database. All DBMS use their own implementation of SQL. It may be a subset or a superset of the instructions provided by SQL 92 . MySQL, due to its simplicity uses a subset of SQL 92.
What is Data Base ?
A database is a collection of date organized in a particular way. Data bases can be of many types such as Flat File Databases, Relational Databases, and Distributed Databases etc.
A database is a collection of Data. That may sound overly simplistic but it pretty much sums as simple as text file with a list of names. Or it could be as complex as a large, relational database management system, complete with in-built tools to help you maintain the data.
What is Data Base ?
Data Base means collection of figure ,Raw ,Picture ,Diagrams.