Page 110 - iPrime_V2.2_class7
P. 110
Subject Enrichment
Create a table for the Library Management System.
Create a table for the Students Details.
a. Show the relationship between the two tables based on the common field.
b. Create a form for the Students Details table. Enter the following records through the
form:
Gyan Shanker 8 B
Richa Sinha 6 A
c. Write a query to find the Book Name, Publication, Student Name, Class and Price from
both the Students Details table and Library Management System tables.
d. Generate a report of the query created.
1. Explain different types of database objects.
2. Demonstrate how forms and reports can be customised.
3. Explain different types of queries to the students.
108 Touchpad iPRIME (Ver. 2.2)–VII

