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
   105   106   107   108   109   110   111   112   113   114   115