RELATIONAL DATABASE MANAGEMENT SYSTEM

Relational Database Management System

An RDBMS is a database system that is based on the relational model which is introduced by DR. E.F.Codd. The database is structure and accessed according to the relationships between data items. In a relational database, all data organized in table form. Table means, store data in a structured format, using rows and columns. It is a subset of DBMS. One important feature of a relational system is that a single database can be spread into one or more tables.

Some important feature:-

· All data in form of a table.

·SQL(Structured Query Language) is implemented by most commercial database systems for accessing the database.

·Mostly support client/server architecture

·Use much security(logging at O/S level, command level, object level)

·Using relational operator would be provided to organize the data before the mention table form.

FOR MORE INFORMATION

Comments

Post a Comment

Popular posts from this blog

KEYS IN RDBMS (PRIMARY KEY, SUPER KEY, CANDIDATE KEY)

Image
KEYS IN RDBMS (Data Constraints) Many keys are available in the RDBMS, They allow finding the relation between columns and table that help identify a tuple (row) in a table. They help find a unique record from the table or database.      Keys are seven types in RDBMS Primary key Super key Alternate key Foreign key Candidate key Unique key Composite key                                                                     Fig 1.2 KEYS 1.       PRIMARY KEY A primary key is an attribute (columns) of a table or group of columns that uniquely identify each record in a table. This contains a unique value that’s no repetition for any row. It cannot be a null value. A table contains only one primary key. Example:- Roll_no Name class ...
Read more

BEST LAPTOP 2021 | TOP BEST LAPTOP | Apple MacBook M1-13-inch | Apple MacBook Pro -16-inch | Dell Inspiron 3505 | HP 15s 6405u

Image
BEST LAPTOP 2021 Various laptop varieties are available today, but now we discuss laptops with the configuration, brand, and prices. If you find a laptop, we have compiled the 11 best laptops from major brands. This article will cover configuration, performance, security, and comparison to the other brands. Category of different demand            Gaming purpose             Education purpose             Developer purpose             Scientific and Research purpose             Business purpose Various brands             Apple             Dell             HP             Acer             Lenovo 1.     Apple MacBoo...
Read more