UNIT 3: DATABASE MANAGEMENT SYSTEM IT402 Class 10th

   Class -10th 

Information Technology (402)

UNIT 3:  DATABASE MANAGEMENT SYSTEM

using LibreOffice Calc

Practical Marks : 10

Download Libre Office:

1) Appreciate the concept of Database Management System:

• Identify the data and information,
• Identify the field, record, table in the database,
• Prepare the sample table with some standard fields.
• Assign the primary key to the field,
• Identify the primary key, composite primary key, foreign key.

2)  Create and edit tables using wizard and SQL commands :

• Start the Libre Office Base and observe the parts of main window,
• Identify the data base objects
• Create the sample table in any category using wizard,
• Practice to create different tables from the available list and choosing fields from the available fields.
• Assign data types of fields, Set primary key,
• Edit the table in design view, Enter the data in the fields

3)  Perform operations on table:

• Demonstrate to:
• Insert data in the table,
• Edit records in the table,
• Delete records from table,
• Sort data in the table,
• Create and edit relationships
• one to one, one to many, many to many,
• Enter various field properties.

4)  Retrieve data using query  :

• Prepare a query for given criteria,
• Demonstrate to create query using wizard, and using design view,
• Edit a query,
• Demonstrate to apply various criteria in query – single field, multiple fields, using wild card,
• Performing calculations using query in Base,
• Demonstrate to group data,
• Use basic SQL commands,

5)  Create Forms and Reports using wizard :

• Illustrate the various steps to create
• Form using Form Wizard,
• Enter or remove data from Forms,
• Demonstrate to modify Forms,
• Demonstrate to change label, background,
• Search record using Form,
• Insert and delete record using Form View,
• Illustrate the various steps to create
• Report using Report Wizard,
• Demonstrate various examples of Report.