Database Management system and Relational Database management System Difference.
Role of database Manager ?
Size: 233.67 KB
Language: en
Added: Jun 28, 2019
Slides: 8 pages
Slide Content
DBMS AND RDBMS
What is Data ? A collection of raw facts and figures . Raw material that can be processed by any computing machine. Data can be represented in the form of: numbers and words which can be stored in computer’s language. i.e Name Number
Database A repository of logically related and similar data. • An organized collection of related information so that it can easily be accessed, managed and updated. E.g .: Dictionary Airline Database Student Database Library Railways Timetable
What is DBMS? A DBMS is a software used to store and manage data. The DBMS was introduced during 1960's to store any data. It also offers manipulation of the data like insertion, deletion, and updating of the data . DBMS system also performs the functions like defining, creating, revising and controlling the database. It is specially designed to create and maintain data and enable the individual business application to extract the desired data.
RDBMS Relational Database Management System(RDBMS) is an advance version od DBMS system. It came into existence during 1970’s RDMBS is a software system which is used to store only data which need to be stored in the form of tables Data are managed and stored in rows and columns which is known as Tuples and Attributes. Types of Keys: Primary key – uniquely identify in a record Foreign key - A field of table which is the Primary key of another table.
Difference between DBMS and RDBMS
What is the role of Database Manager of an Online Shopping Company For Managing Data as a Business resources ?