Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

RDBMS

Photo of author

By Team EasyExamNotes

A DBMS based on relational model is called relational database management system or RDBMS.
RDBMS uses relational structures to store data. A relation is also called a table.A relation contain tuples (rows) and attributes (columns).

STUDENT

Roll_noNameCity
10001AnuragBurhanpur
10002YashKhandwa
10003PrafulNepa nagar
10004HarshalKhanknar

MARKS

Roll_noMarks
1000192
1000281
1000378
1000485

In RDBMS tables are related each other.

Relation are set using a common column between tables.

In above tables, Roll_no is a common attribute between them which established a relation.

Download as PDF

Related posts:

  1. SQL Functions
  2. History of DBMS
  3. Introduction to DBMS
  4. Introduction to Database
  5. Advantages and Disadvantages of DBMS
  6. SQL | DDL, DML, DCL Commands
  7. Domain
  8. Entity and Attribute
  9. Relationship among entities
  10. Attribute
  11. Database Relation
  12. DBMS Keys
  13. Schema
  14. Twelve rules of CODD
  15. Normalization
  16. Functional Dependency
  17. Transaction processing concepts
  18. Schedules
  19. Serializability
  20. OODBMS vs RDBMS
  21. SQL Join
  22. SQL Functions
  23. Trigger
  24. Oracle cursor
  25. Introduction to Concurrency control
  26. Net 11
  27. NET 3
  28. NET 2
  29. GATE, AVG function and join DBMS | Prof. Jayesh Umre
  30. GATE 2014 DBMS FIND Maximum number of Super keys | Prof. Jayesh Umre
  31. GATE 2017 DBMS Query | Prof. Jayesh Umre
  32. Data types
  33. Entity
  34. Check Constraint
  35. Primary and Foreign key
  36. SQL join
  37. DDLDMLDCL
  38. Database applications
  39. Disadvantages of file system data management
  40. RGPV DBMS Explain the concepts of generalization and aggregation with appropriate examples
  41. RGPV solved Database approach vs Traditional file accessing approach
  42. Find all employees who live in the city where the company for which they work is located
  43. Concept of table spaces, segments, extents and block
  44. Triggers: mutating errors, instead of triggers
  45. Dedicated Server vs Multi-Threaded Server
  46. Distributed database, database links, and snapshot
  47. RDBMS Security
  48. SQL queries for various join types
  49. Cursor management: nested and parameterized cursors
  50. Oracle exception handling mechanism
  51. Stored Procedures and Parameters