Page 428 - TP_IT_V1.0_C10_flipbpookl
P. 428

18.  Create a database-COMPANY with the tables-EMPLOYEE, SALARY, DEPARTMENT
                  •  Use Design View to design the structure of EMPLOYEE and SALARY tables.
                  •  Use table wizard to design the structure of the DEPARTMENT table.
                  •  Assign a Primary key in each table.
                  •  Insert 10 records in each table using Table Data view.
                  •   Make a form for displaying the details of the EMPLOYEE table. The form should allow addition, modification and
                    the deletion of the records.
                  •  Make a report to display the details of all the departments using the DEPARTMENT table.
              19.  Consider the following PRODUCT table.
                                           PROD ID     PROD NAME       PRICE    QUANTITY
                                            P101     JEANS             1500        100
                                            P121     TROUSERS          2100        200
                                            P131     SHIRT             1300        150

                                            P141     SKIRT             1200        120
                  Perform the following task on LibreOffice Base:
                  •  Give the command to create the above table.
                  •  Display the structure of the table.
                  •  Insert the above mentioned records.
                  •  Display the details of the product whose price is in the range of 1000 to 2000.
                  •  Display only the product name and price of all the products.
                  •  Display all details where the product name has ‘IRT’.
                  •  Modify the quantity of the shirt to 100.
                  •  Delete the record for TROUSERS.
              20.  Create a Database:- Global School and a Table:- Students
                  Enter the following record in a table.
                          Name      Roll_No.       DOB         Contact_No.           Email         Location

                         Ravi     23            05-07-1990   1234657896       ravi@gmail.com       100
                         Delhi    TROUSERS      2100         200              2100                 200
                         Rahul    17            05-07-1990   2157896541       rahul@gmail.com      Mumbai
                         Puja     28            12-10-1992   3865478951       puja@gmail.com       Delhi
                         Suraj    21            25-03-1995   3265987845       suraj@gmail.com      Bangalore

                         Arya     26            15-07-2008   4512365598       arya@gmail.com       Pune
























                426   Trackpad Information Technology (Ver. 1.0)-X
   423   424   425   426   427   428   429   430   431   432   433