Database Management System: Unit I: Relational Databases
Introduction to Relational Databases
Relational Databases - Database Management System
Relation database is a collection of tables having unique names. For example - Consider the example of Student table in which the information about the student is stored.
Part II: Relational Databases
Introduction
to Relational Databases
• Relation database is a collection of tables having
unique names.
• For example - Consider the example of Student table in which the information about the student is stored.
The above table consists of three column headers RollNo,
Name and Phone. Each row of the table indicates the information of each student
by means of his Roll Number, Name and Phone number.
Similarly consider another table named Course as follows –
Clearly, in above table the columns are CourseID, CourseName and
Credits. The CourseID 101 is associated with the course named Mechanical and
associated with the course of mechanical there are 4 credit points. Thus the
relation is represented by the table in the relation model. Similarly we can
establish the relationship among the two tables by defining the third table.
For example - Consider the table Admission as
From this third table we can easily find out that the course to which
the RollNo 001 is admitted is computer Science.
Database Management System: Unit I: Relational Databases : Tag: : Relational Databases - Database Management System - Introduction to Relational Databases
Related Topics
Related Subjects
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation