Page 399 - Trackpad 402_Class-X_Final
P. 399

Create the following table for the Student‘s Details.

                              Book ID       Student Name              Class             Section
                                 1       Amit Kumar                     7                  C
                                 2       Ria Aggarwal                   8                  A
                                 3       Yash Yadav                     6                  D
                                 4       Ananya Gupta                   8                  B
                •  Show the relationship between the two tables based upon the common field.
                •   Create a form for the Student’s Details table. Enter the following records through the form.
                  Gyan Shanker           8      B
                  Richa Sinha            6      A
                •   Write a query to find the Book Name, Publication, Student’s Name, Class and Price from both the Student’s
                  Details table and Library Management System tables.
                •  Generate a report of the query created.
            26.  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.
            27.  Create the given PRODUCT table.

                                          PRODID     PRODNAME       PRICE   QUANTITY
                                            P101    JEANS           1500       100
                                            P121    TROUSERS        2100       200
                                            P131    SHIRT           1300       150
                                            P141    SKIRT           1200       120
                Write an SQL query for the given instructions using the above table:
                •  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.
            28.  What is Instant Messaging?
                •  Find out the list of instant messaging services available in your computer.
                •  List the two kinds of instant messaging software with examples
                •  What is Google Chat? Give the steps to send a message to a friend using Google Chat.
            29.  List down a few general rules and etiquettes to be followed while chatting.
            30.  List a few of the best practices that can be followed to be safe while using the internet.
            31.  How can you keep your password safe?
            32.  Give the steps to clear your login credentials in Google Chrome.




                                                                                                 Practical Work  399
   394   395   396   397   398   399   400   401   402   403   404