Page 404 - Trackpad 402_Class-X_Final
P. 404

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]


        Table Name : STATE
        Field Name     Data Type

        StateID        Number[NUMERIC]
        StateName      Text[VARCHAR]

        Forms/Query/Relationship:

            Set Relation Between Tables (CustID - Customer To BillDetails and StateID – Customer To State).
           Generate a query that will display the records of Customer Table along with Statename 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.


                                                                                21 st   #Productivity & Accountability
        DATABASE                                                              Century   #Information Literacy
                                                                                Skills
        1.  Create a Database-SCHOOL with the given tables:
            STUDENT

            Admno varchar(5)   [primary key]

            Name varchar(20)
            Address varchar(30)

            City varchar(10)
            Phoneno number(10)

            Dob date
            MARKS

            Rollno number(3)  [primary key]
            Admno varchar(5)

            Tcode varchar(5)
            Test1 number(6,2)

            Test2 number(6,2)





          404   Trackpad Information Technology-X
   399   400   401   402   403   404   405   406   407   408   409