Categories
Data Base

What is Database Normalization?

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:

Categories
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.

Categories
Data Base

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.

Categories
Data Base

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.

Categories
Data Base

What is Data Base ?

Data Base means collection of figure ,Raw ,Picture ,Diagrams.