Page 242 - IT_V1.0_Class10
P. 242

21 st
                                                  Lab Assignment ‘n Activity                    Century   #Technology Literacy
                                                                                                      #Information Literacy
                                                                                                  Skills

                   Complete the following activities and tick the circle.
                     Create a School database and the Student table with the following fields:
                       Field Name           Field Type

                       Stu_ID               Number[NUMERIC]
                       Stu_Name             Text[VARCHAR]

                       Gender               Text[VARCHAR]
                       Class                Text[VARCHAR]
                       Sec                  Text[VARCHAR]

                       Roll_No              Number[NUMERIC]
                     Set Stu_ID as primary key in the Student table.

                      Create another table, namely, Parents to store parent’s details with fields Stu_ID (Number
                       [NUMERIC]), Fname (Text[VARCHAR]), Mname (Text[VARCHAR]).
                      Set Stu_ID as primary key in the Parents table.

                      Add atleast 10 records in both the tables.
                      Set relationship between both the tables.
                       Modify Stu_ID of the last record as 11 in Student table and see if the Stu_ID of the last

                       record of Parents table changed or not.
                       Delete one record from the Student table and see if the same Stu_ID is deleted from the
                       Parents table or not.




                  Recap Zone


                   A relationship refers to link between different tables of a database by matching the data on the basis
                    of the common Primary key field.
                   Establishing relationships between tables is essential for minimising data redundancy and ensuring
                    consistency.
                   There  are  three  important  types  of  relationship  that  can  be  created  in  a  database  which  are
                    One-to-One, One-to-Many, Many to Many.

                   Referential integrity is applied in databases to maintain the accuracy and consistency of data in
                    relationships between tables.
                   A relationship refers to an association or connection between fields of two or more tables.











                240     Information Technology Play (Ver 1.0)-X
   237   238   239   240   241   242   243   244   245   246   247