what is the diff between dbms and rdbms(what are the 12
rilations in the rdbms).
Answer Posted / sid
DBMS is a system that allows to insert, update, delete and
retrieve data
RDBMS stores data in the form of related tables. It allows
data security
12 rules for RDBMS are:
-data should be tabular
-accessing of data must be easy
-supports for null values in fields other than primary key
-tool must be same for database structure and for data itself
-database must support at least one programming language
-data can be represented as views
-insert,update and delete operations for multiple tables/rows
-data should be physically independent
-data must be logically independent
-integrity independence of database
-user should not know distribution of database
-modifying database structure must be through a language
like SQL
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain dml compiler?
What is super key in dbms?
Discuss transparent DBMS?
How do we select distinct values from a table?
Explain the terms database and dbms. Also, mention the different types of dbms.
Explain the Normalized Relations?
What are the three main types of models?
What is field record and table in database?
What is data example?
What is the purpose of normalisation?
Explain the concepts of a primary key and foreign key.
What do you mean by denormalization?
Write a query to create a duplicate table with and without data present?
What are codd rules?
What do you mean by aggregate and scalar functions in dbms?