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
Database Management System: Unit I: Relational Databases
Under Subject
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Related Subjects
Environmental Sciences and Sustainability
GE3451 ESS 4th Semester | 2021 Regulation | 4th Semester EEE Dept 2021 Regulation
Theory of Computation
CS3452 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Artificial Intelligence and Machine Learning
CS3491 4th Semester CSE/ECE Dept | 2021 Regulation | 4th Semester CSE/ECE Dept 2021 Regulation
Database Management System
CS3492 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Algorithms
CS3401 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation
Introduction to Operating Systems
CS3451 4th Semester CSE Dept | 2021 Regulation | 4th Semester CSE Dept 2021 Regulation