Page 271 - IT 402 v2.0 class 10
P. 271
Therefore, it reduces data-entry errors.
Summarise data from related and associated tables.
Creating and Editing Relationships between Tables
Consider a database of your class in which the student details and their marks details are stored in two
separate ables namely S N and S N M S . stablish a relationship between two tables and
add a few records in both the tables. elete a record from the S N able and see if the same gets
deleted from the S N M S table or not.
relationship refers to an association or connection between fields of two or more tables. hen you relate
or connect two tables, there is a need to enter the same data in separate tables.
o establish a elationship between two tables open the able window. Select the elationships option
from ools menu. ssuming that there are two tables namely S N and S N M S . lick on
S icon from the Standard oolbar.
O
Select the S option from the INS menu from the menu bar. he S window opens
with the list of the available tables in the database file from which the user can select the tables to set
relationship.
Step 1: Click here to set relationship.
Step 2: dd ables window opened after clicking on dd ables icon.
1
2
Step 3: Select the table S N from the dd ables window and then click on dd button. he table
namely S N gets displayed with all fields.
Step 4: Follow the above steps to add the S N M S table to set the relationship between them.
Database Management 269

