DBMS: Database Management Systems is a software (or set of programs) designed to create and maintain a database to store and retrieve information.
Data stored in single large tables and when modify or insert a record whole database is modified or updated.
RDBMS: Relational Database Management Systems is a DBMS that maintains the data in tables and relationships which are created and maintained across and among the data and tables. (developed by Dr.E.F Codd in 1970’s-80’s).
The database management system (DBMS) of a relational database is called an RDBMS, and is the software of a relational database.
Database is broken down in to multiple tables so when modify or insert a record only a small portion(table) of the database is modified or updated. Tables connected to maintain the relationships using “key fields(or Columns)”.
In Tables data is stored in Rows (Tuples) and Columns (Attributes).
No comments:
Post a Comment