Page 302 - Trackpad 402_Class-X_Final
P. 302

Consider the following table “ITEM”:
                 uiz Bee
                                          ITEMNO          NAME             PRICE        QUANTITY
                                        11           SOAP              34             12
                                        22           POWDER            85             10
                                        33           FACE CREAM        80             15
                                        44           SHAMPOO           120            21
                                        55           CONDITIONER       200            11
                                Write SQL queries to do the following:
                                •   Display the total amount of each item. The amount must be calculated as the price.
                                  multiplied by quantity for each item.
                                •   Display the details of items whose price is less than 50.
                                •   Display the name of items and its price in ascending order.
                                •   Display the details of all items whose name start with ‘S’.








                             Is ‘NOSQL’ used for in structured data?




                WHAT IS A FORM?

        Form is a database Object which is used to create an interactive user interface by connecting it with a table. Each field
        of a table is displayed in a text box with a Field label on one side so that the user can enter, edit and view records in
        an efficient way. The data added, deleted,updated through a form will be reflected in the table connected to the form.
        A form in Open Office Base can be created by using any of the given methods:
        •  Use Wizard to Create Form

        •  Create Form in Design View
        Steps for Creating Forms Using a Wizard

        Wizard is an easy way that guides you through the step by step process of creating forms. Follow the given steps to
        create a form using a wizard:

        Step 1:  Select database object Forms  and click on Use Wizard to Create Form option.



























          302   Trackpad Information Technology-X
   297   298   299   300   301   302   303   304   305   306   307