Class 10 IT Practical File on DBMS 2024-25 (Assignment 1)

In this article we providing information regarding latest Class 10 IT Practical File on DBMS 2024-25 (Assignment 1)

Class 10 IT Practical File on DBMS 2024-25 (Assignment 1)

In your Upcoming CBSE Board Exam – On Internal Marks is 50.

Based On CBSE Curriculum-

So we are discuss one by one Practical’s Be Connected.

Unit 3 – Database Management System

Learning Outcome – Create and edit tables using wizard

Assignment 1

Objective:

Steps to create a table using table wizard

Task:

Create a table using wizard and insert data.

Solution:

1. Click on Start → All Programs → LibreOffice 24.2 → LibreOffice Base. 24.2 LibreOffice Base window will open with Database Wizard.
2. Click on Create a new database option.
3. Click on Next button.
4. Select the database Register option either Yes, or No.
5. Check on Open database for editing.
6. Click on Finish button.
7. It will prompt to save the database.
8. Type the desired name and save it. I have given db1.
9. Now click on Tables button from Left pane and choose the option – Use Wizard to Create Table… from the tasks window.
10. The Table Wizard will open. Follow wizard steps to create a table.
11. In first step of wizard select the Category either Business or Personal,
12. Now choose a table from list of table. As I have selected Employees table.
13. Click on Next and select field types and all if you want to change it. Click on Next. I have selected EmployeeID, Firstname, Lastname, Salary, Datehired.
14. Set a primary key for your table in this step. Click on Use an existing field as a Primary Key. I have selected EmplyeeID as Primary key. Click on Next.
15. If you wish to change the table name then type new name for the table and click on Insert.
16. Data immediately, and click on Finish. Enter data now.

Output :

Thanks to Beloved Readers.