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

