Scribd
Upload
4 views1 page

Dbms Notes

The document outlines key components of a database, including databases, tables, queries, forms, and reports. A database organizes related data for easy management, while tables structure data in rows and columns. Queries retrieve specific data, forms facilitate user interaction with the data, and reports present formatted information for summaries and official use.

Uploaded by

yuvi97590
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

Dbms Notes

The document outlines key components of a database, including databases, tables, queries, forms, and reports. A database organizes related data for easy management, while tables structure data in rows and columns. Queries retrieve specific data, forms facilitate user interaction with the data, and reports present formatted information for summaries and official use.

Uploaded by

yuvi97590
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

Database
A database is an organized collection of related data stored in a structured way.
It allows easy data storage, retrieval, and management. Examples: student
records, employee details.

2. Table
A table stores data in rows and columns.
 Row = Record
 Column = Field
Each table stores data about one subject (like students or products).

3. Query
A query is used to retrieve specific data from one or more tables.
It can filter, sort, calculate, and summarize data without changing the original
table.

4. Form
A form is a database object used to enter, view, and edit data easily.
Forms provide a user-friendly interface compared to tables.

5. Report
A report is used to present data in a formatted and printable form.
It is mainly used for summaries, totals, and official output.

You might also like