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

