Page 321 - IT_V1.0_Class10
P. 321

21 st
                 PROJECT-4                                                                        Century   #Technology Literacy
                                                                                                    Skills
                 Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its Customers and
                 make their billing details. The table name and its structure are as follows:

                      Table Name : CUSTOMER              Table Name : BILLDETAILS              Table Name : STATE
                   Field Name        Data Type         Field Name        Data Type        Field Name      Data Type

                 CustID         Number[NUMERIC]      CustID         Number[NUMERIC]      StateID      Number[NUMERIC]
                 CName          Text[VARCHAR]        Quotation      Number[NUMERIC]      StateName    Text[VARCHAR]

                 Add1           Text[VARCHAR]        Challan        Number[NUMERIC]
                 StateID        Number[NUMERIC]      Bill           Number[NUMERIC]

                 Phone          Number[NUMERIC]      Amount_Billed Number[NUMERIC]
                 Mobile         Number[NUMERIC]      Amount_Paid    Number[NUMERIC]
                 ContactPerson  Text[VARCHAR]

                 CreditLimit    Number[NUMERIC]

                 Forms/Query/Relationship:

                   Set relation between tables:
                   o CustID field of CUSTOMER table to CustID field of BILLDETAILS table.
                   o StateID field of CUSTOMER table to StateID field of STATE table.
                   Create a query in Design View that will display the records of the customer along with the State name and
                   billing details of the customer. The query should calculate the balance amount of the customer.
                   Design a form to display the customer details.

                   Update any CustID in CUSTOMER table and verify if the same gets updated in BILLDETAILS table.

                 PROJECT-5
                                                                                                     21 st
                 Follow the given instruction to complete the project:                            Century   #Technology Literacy
                                                                                                    Skills
                   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        Mirza             Gautam               16/06/92      Junior                N
                          003        Chouhan           Kunal                02/11/85      Senior                N
                          004        Sharma            Rahul                06/07/74      Senior                Y
                          005        Bhagat            Manish               12/10/89      Junior                Y


                 Create  a  query  in  Design  View  for  community  centre  that  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 Work    319
   316   317   318   319   320   321   322   323   324   325   326