Page 104 - TP_iPlus_V2.1_Class7
P. 104
• Crosstab Query: It shows your data in a grid with row and column headings, so you can see
and compare your information across two categories at once.
Info Byte
Structured Query Language (SQL) is a fifth generation computer language for relational
databases and data manipulation. It is used to insert, update, and retrieve data from a
database table.
Setting up Relationship
A relationship between two tables connects them through a common field. The field in the first
table is called the primary key, and the same field in the second table is called the foreign
key. The foreign key must match the primary key. To create this link, make sure both tables
have a primary key.
To create a relationship, create two tables:
• Table named ‘StudentsDetail’ that holds general information about the students, such as their
Roll No, Student Name, Father’s Name and Class.
• Table named ‘StudentsMarks’ that holds information about Roll No, Marks and Percentage.
Using tables for defining relationships
To define the relationship between the two tables, follow the given steps:
3 Click on the Add button.
1 Click on the Database Tools tab.
2 Click on the Relationships
command from the Relationships
group. 4 After adding the desired tables, click on the
Close button.
102
iPlus (Ver. 2.1)-VII

