Information Technology
Project
Session - 2024-2025
Name - Janesh Kumar
Class - X-E
Topic Name - Database
Submitted To -
Certificate
This is certify that I am Janesh Kumar of Class X-E of St. Thomas School, Bahadurgarh
has successfully completed the Information Technology project report titled "Database"
under guidance of Mr. Parmod Sir during the academic year 2024 -25 towards partial
fulfilment of Information Technology Practical examination conducted by CBSE..
__________ __________
Mr. Parmod Sir Mr. Sudhir Sir
(IT Teacher). (Principal Sir)
Acknowledgement
I would like to express my sincere gratitude to all these individuals for mentoring and
supporting me in completing this project.
My teacher (Mr. Parmod Sir) for providing me with invaluable insights and direction. Our
esteemed principal (Mr. Sudhir Sir) for fostering an environment of learning and
creativity within our school.
To my parents, their constant encouragement, patience, and understanding have been
the pillars of my success.
I am grateful to my friends who contributed ideas and perspectives that enriched the
project. Thank you everyone for shaping this project and enhancing my learning
experience.
DATABASE
INTRODUCTION
Databases are being used extensively in our day-to-day life. Be it business, engineering,
medicine, education, library, to name a few. For example, consider the name, class, roll
number, marks in every subject of every student in a school. To record this information
about every student in a school, the school might have maintained a register, or stored
it on a hard drive using a computer system and software such as a spreadsheet or
DBMS package. Such collection of related data that has been recorded, organized and
made available for searching is called a Database.
Components Of Database
1. Table -Tables are database objects that contain all the data in a database. In tables,
data is logically organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field in the record. For
example, a table that contains employee data for a company might contain a row for
each employee and columns representing employee information such as employee
number, name, address, job title, and home telephone number.
2.Forms -A form is a database object that contains different fields. These fields collect
information from a source which is collected and stored in a database for further
reference. Businesses these days can make use of database forms to gather
information via web browsers
3. Query -In everyday language, a query is simply a request for information. Similarly,
the meaning of a query in database management is a request for data. If you need to
access, manipulate, delete, or retrieve data from your relational database, you'll need a
database query written using a specific syntax.
4. Reports -A database report is a formatted presentation of data from a database that
provides structured information for decision-making. Database reports are specifically
meant to convey information in a way that is easy to understand by human beings. See
also: data profiling, data segregation, data mining.
Advantages Of Database
1. Data Security - Enhanced Data Security. DBMS enhances data security through
encryption and access control measures.
2. Data Reduncy - In a DBMS, data redundancy is minimised.
3. Data Integrity - In a DBMS, data integrity ensures the consistency and accuracy of
data within the database.
4. Data Sharing - Improved Data Sharing. One of the biggest advantages of a DBMS is its
ability to share data.
Steps To Create Form In Database -
1 . In the Navigation pane, select the table you want to use to create a form. You do not
need to open the table.
2. Select the Create tab, locate the Forms group, then click the Form command.
3. Your form will be created and opened in Layout view.
Steps To Create Report -
1. Open the table or query you want to use in your report. ...
2. Select the Create tab on the Ribbon. ...
3. Access will create a new report based on your object.
4. It's likely that some of your data will be located on the other side of the page break.
Steps To Set Primary Key (Account Number)
Step 1: Open a table in Design view.
Step 2: Select the field or fields you want to define as the primary key( Account Number)
or click the row selector for the desired field.
Step 3: Click Primary Key on the toolbar. After clicking on primary key, selected column
will be look as below image.
Steps To Create Query -
(i)Open the database on whose table(s), you want to create a query.
(ii) In the database window, select Queries from the left pane and click Use Wizard to
Create Query.
iii) Query wizard will start. First of all, select the tables on which you want to query upon.
(iv) In the next step, you can specify the sort order by selecting the sort field(s).
(v) Next, you need to specify the condition or the search condition.
(vi) In the next step, specify the alias names for the values being displayed. If you a okay
with the default alias names, simply click Next.
(vii) Lastly, it will show you overview of your query. Click finish here to view your query.
() Finally, it will show you records matching the condition of your query.
CREATING TABLE IN DESIGN VIEW
Steps for 'Creating a Table in Design View' -
1. In the database window, click on Tables tab and click on Create Table in Design View.
2. Table Design Window will open. Enter field names and select data type for each field.
You may add a description for the field under Description Column.
3. You can set field properties as desired. Once done, press Ctrl+S.
CREATING QUERY USING WIZARD
1. Click on Query Tab. Under Tasks Section, click on Use Wizard to Create Query.
2. The Query Wizard will open. Choose the fields for which you want to create the table.
3. Specify the Search Conditions, Sort Order and Alias Names.
4. Click on Finish button.
CREATING TABLE IN DESIGN VIEW
Steps for 'Creating a Table in Design View' -
1. In the database window, click on Tables tab and click on Create Table in Design View.
2. Table Design Window will open. Enter field names and select data type for each field.
You may add a description for the field under Description Column.
3. You can set field properties as desired. Once done, press Ctrl+S.
Creating report in Wizard
Creating form in wizard
