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

