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

