What is Database ?
Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.
What is DBMS ?
A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.
RDMS
A relational database management system (RDBMS) is a program that lets you create, update and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use.
Relational Database
A relational database is a collection of data item organised as a set of formally described tables from which data can be accessed or reassembled in many different ways without having recognize the database tables. The relational database was invented by E.F.Codd at IBM in 1970.
The main highlights of this model are -
1. Data is stored in tables called relations.
2. Relations can be normalized.
3. In normalized relations, values saved are atomic values.
4. Each row in a relation contains a unique value.
5. Each column in a relation contains values from a same domain.
Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.
What is DBMS ?
A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.
RDMS
A relational database management system (RDBMS) is a program that lets you create, update and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use.
Relational Database
A relational database is a collection of data item organised as a set of formally described tables from which data can be accessed or reassembled in many different ways without having recognize the database tables. The relational database was invented by E.F.Codd at IBM in 1970.
The main highlights of this model are -
1. Data is stored in tables called relations.
2. Relations can be normalized.
3. In normalized relations, values saved are atomic values.
4. Each row in a relation contains a unique value.
5. Each column in a relation contains values from a same domain.
Comments
Post a Comment