Relational model in DBMSIn relational model, the data and relationships are represented by collection of inter-related tables. Each table is a group of column and rows, where column represents attribute of an entity and rows represents records.Sample relationship Model : Student table with 3 columns and four records.Table: Student Stu_Id              Stu_Name                   Stu_Age111                   Ashish                            23123                   Saurav                            22169                   Lester                             24 234                    Lou                                 26Stu_Id               Course_Id            Course_Name111                      C01                      Science111                      C02                      DBMS169                      C22                      Java169                      C39                      Computer NetworksHere Stu_Id, Stu_Name & Stu_Age are attributes of table Student and Stu_Id, Course_Id & Course_Name are attributes of table Course. The rows with values are the records (commonly known as tuples). - Study24x7
Social learning Network
56 followers study24x7 01 Mar 2019 03:27 PM study24x7 study24x7

Relational model in DBMS

In relational model, the data and relationships are represented by collection of inter-related tables. Each table is a group of column and rows, where column represents attribute of an entity and rows represents records.


Sample relations...

See more

study24x7
Write a comment
Related Questions
500+   more Questions to answer
Most Related Articles