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 relationship Model: Student table with 3 columns and four records.
Table: Student
Stu_Id | Stu_Name | Stu_Age |
111 | Ashish | 23 |
123 | Saurav | 22 |
169 | Lester | 24 |
234 | Lou | 26 |
Table: Course
Stu_Id | Course_Id | Course_Name |
111 | C01 | Science |
111 | C02 | DBMS |
169 | C22 | Java |
169 | C39 | Computer Networks |
Here 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).
Leave a Reply