Project Work
on
Database Management System
Class: X
Session: 2024-25
Name: ______________
Roll No: ________
1
Certificate
This is to certify that the student of class X,
______________ has successfully completed the
DBMS projectwork in the subject Information
Technology(402) laid down in the regulationsof
CBSE for the purpose of Practical Examination in
Class X during the year 2024- 2025.
Internal Examiner
_______
External Examiner
2
TABLE OF CONTENTS
S NO INDEX
1 Introduction to Database Management System
2 Introduction to the project(Table)
3 Objectives of the project
4 Design and Data view of the table(s)
5 Queries
6 Form design
7 Reports
8 Bibliography
3
Introduction to Database
Management System (DBMS)
Database Management System (DBMS) is system
software for creating and managing databases. A
DBMS makes it possible for end users to create,
protect, read, update and delete data in a database.
The most prevalent type of data management
platform, the DBMS essentially serves as an
interface between databases and users or application
programs, ensuring that data is consistently
organized and remains easily accessible.
Database management system (DBMS) is the most organized
application in storing data. The lower level data is stored on
the hard disk itself. There is no sophisticated software that
protects the data on the disks. Apart from protection of data,
there are plenty of structures that are part of the database
management system properties. These structures bring out
new meaning in the data. Among the services the software
system of database management system provide are:
* ask about the data,
* arrange the output with formatting,
* modify the data in the database easily,
* delete a table(s), etc.
4
Introduction to the Project
This project talks about various ways in which a
database system is managed, how it works, how
itsimplifies the task of managing the data and
extracting useful information out of it. I have
used Employee table to explain various features
of Openoffice base and SQL.
5
Objectives of the project
After doing this project I am able to :
Create a table using various ways.
Create forms, queries and reports.
Know more about database
Understand and use SQL tables.
Learn DDL commands
6
Design view of Table Employee
Data view of Table Employee
7
Queries
Write SQL commands for (i) to (v)-
8
Form Design of Employee Table
9
Query 1 Output
Query 2 Output
10
Query 3 Output
Query 4 Output
11
Query 5 Output
12
Report Design of Query 1
Report Design of Query 2
13
Report Design of Query 3
Report Design of Query 4
14
Report Design of Query 5
15
Bibliography
A Textbook of Information Technology –X (402)
CBSE study material Class X
16
