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

