what is the difference between DBMS and RDBMS??
Answer Posted / gowtham raj
DBMS:
1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.
6)FoxPro, IMS are Examples
RDBMS:
1)It is used to establish the relationship concept between two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.
6)SQL-Server, Oracle are examples
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Suppose database is running slow, what will you do?
Write a query to create a duplicate table with and without data present?
What is pdo in database?
Explain the term generalization.
Which database is best for large data?
How many types of data are there?
What are the uses of database management system?
Enlist the types of cursor?
Explain the advantages and disadvantages of a hierarchical database?
How to prevent firebird.log file from filling up the disk partition?
What is the purpose of using a model?
Why are forms important in databases?
Why is foreign key used?
What are stand-alone procedures?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????