Quote Originally Posted by Medusa View Post
database is an organized collection of data. When you take any web sites or any pages you can't go further without database. The importance of the database is very high in every web site.


A relational database is a combination of schema,tables,queries,reports,views and other elements.All of are familiar with this terms in MS Access.


DBMS- Data Base Management System is a computer software application that interact with end users,other applications and the database itself to capture and analyze data. Most of the IT related people study about DBMS.


There are many types of DBMS ;



  • RDBMS-
  • RDBMS Tier1
  • NoSQL DBMS
  • IMDBMS
  • CDBMS
  • Cloud-based data management System



Advantages of DBMS

  • Data Security
  • Robust Data integrity capabilities
  • Logging and Auditing of Activity
  • Uniform Administration procedures for data



There are many models to represent databases.The ER model is very popular... I would like to share some begineer short points for the Database and content.
These are some of the conceots of data base
Field (Column): a single piece of information. Could be a name, or a number. In some cases, it may even be a null or empty value.
Record (Row): a collection of related fields. A number of pieces of information that relate to the same object. For example: If you keep records on an employee, you might have their name, address, social security number, phone number, etc…Each piece of the information relates back to one employee. This would be the employee’s record.
Table (File): a collection of related records. If you put all the employee records together, you have a table of employees.
Database: a collection of tables. If you were keeping the company records, you might have a table for employees, a table for customers, and another for sales records. All these tables would be combined as a database.