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
   99   100   101   102   103   104   105   106   107   108   109