Comprehensive Notes Unit3 Database Management System Class10

In this article, you will get Comprehensive Notes for Unit 3 Database Management System Class 10.

Learning outcomes of Unit 3 Database Management System class 10

This unit has the following learning outcomes:

  1. Appreciate the concept of Database Management System
  2. Create and edit tables using wizard and SQL
  3. Perform operations on table
  4. Retrieve data using query
  5. Create forms and Reports using wizard

1 Appreciate the concept of Database Management System

This learning outcome has following theory concepts:

  • Concept and examples of data and information
  • Concept of Database
  • Advantages of Database
  • Features of Database
  • Concept and examples of relational database
  • Concept and examples of field, record, table, database
  • Concept and examples of Primary key, composite primary key, foreign key
  • Relational data base management system (RDBMS) software

2 Create and edit tables using wizard and SQL

  • Introduction to an RDBMS
  • Database objects – tables, queries, forms, and reports of the database
  • Terms in the database – table, field, record
  • Steps to create a table using table wizard, Data types in Base
  • Option to set the primary key
  • Table Data View dialogue box
  • DDL Commands

3 Perform operations on table

  • Inserting data in the table
  • Editing records in the table
  • Deleting records from the table
  • Sorting data in the table
  • Field properties
  • Referential integrity
  • Creating and editing relationships – one to one, one to many, many to many

4 Retrieve data using query

  • Database query
  • Defining query
  • Query creation using a wizard
  • Creation of query using design view
  • Editing a query
  • Applying criteria in query – single field, multiple fields, using wildcard
  • Performing calculations
  • Grouping of data
  • Structured Query Language (SQL)

5 Create forms and Reports using wizard

  • Forms in Base
  • Creating a form using the wizard
  • Steps to create a form using Form Wizard
  • Options to enter or remove data from forms
  • Modifying form
  • Changing label
  • Changing background
  • Searching record using Form
  • Inserting and deleting record using Form View
  • Concept of Report in Base
  • Creating Report using the wizard
  • Steps to Create Report using Wizard

Comment Your Views

%d bloggers like this: