Page 428 - IT 402 v2.0 class 10
P. 428

enerate a  uery that will display the records of  ustomer  able along with Statename and  illing details
          of the customer.  he  uery should calculate the balance amount of the customer.

          Design a Form to display the customer details.
           pdate any  ustI  in   S OM   table and verify if the same gets updated in  I      I S table.


        PROJECT-5

                                                                                                 S ub j e ct  E nr ich me nt
        Follo  t e gi en instruction to com lete t e  ro ect:

          The following table shows the members of a community centre.


               Number          Last_Name         First_Name          DOB          Member_Type       Payment

                 001         Singh            Ashish               03/04/77      Senior                 Y

                 002         Mir a             autam               16/06/92      Junior                N
                 003         Chouhan          Kunal                02/11/85      Senior                N

                 004         Chetan           Rahul                06/07/74      Senior                 Y

                 005         Bhagat           Manish               12/10/89      Junior                 Y




         reate a  uery for community centre which wants to find the members according to the following criteria:
          Member_Type is not ‘Senior’ and Payment is ‘N’.

          Member_Type is not ‘Senior’ and Payment is ‘Y’.

          Member_Type is not ‘Junior’ and Payment is ‘Y’.

          Member_Type is not ‘Junior’ and Payment is ‘N’.


        PROJECT-6


        Follo  t e gi en instruction to com lete t e  ro ect:

          Open various government and private sites for registration of tickets or purchase of any product and
          observe the information asked on such transaction sites.

           Visit any online shopping site and observe the details of products published.





















         426       Touchpad Information Technology-X
   423   424   425   426   427   428   429   430   431   432   433