Class 10 DBMS notes

 which data type is used to store numeric characters or special symbol in MS Access?

= Short Text

which view is used to modify a table in MS Access?

= Design view

What Is a Database? Give examples

A database is an organized collection of structured information, or data, typically stored electronically in a computer system.

eg. of database are:

MySQL, SQL Server, MongoDB, Oracle Database, PostgreSQL, Informix, Sybase, etc.

What is primary key ? List its  advantages of it.

A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each table record.

Advantages of primary key:

a) Data can not be repeated. It prevents duplicate records from being entered.

b) It makes fast access for database to locate records in the table. Fast sorting and searching records.

c) It creates the relationship between tables.

d) It avoids null value.

what is data sorting??  list the advantages of data sorting.

Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize.

The advantages of data sorting are:

a) It helps arrange all records in a table.

b) It is able to deal well with a huge list of items.

c) No additional storage is required.

what types of work is done in MS Access using form and query object ?

A form in Access is a database object that you can use to create a user interface for a database application.

Using a query makes easier to view, add, delete, or change data in your Access database. Queries helps to find specific data quickly by filtering on specific criteria (conditions) Calculate or summarize data.

which data type is suitable to store photographs of students in MS Access?

OLE object

which view is used to modify a table structure in MS Access?

Design view

What is Database management system (DBMS)? 

Write its advantages.

Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data.

The advantages of DBMS are:

a) Data integrity

b) Data Security

c) Better data integration

d) Faster data access

What is field in dbms?

Field is a physical structure in a form, file or database that holds data.

What is record?

A record is a collection of items or data that is organized in a group of fields within a table that are related to a specific topic.

Define form . Write its uses.

A form in Access is a database object that you can use to create a user interface for a database application.

The uses of form are:

a) Displaying and editing data.

b) Controlling application flow.

what is the storage size of memo and text data type in MS Access?

Memo can store upto 2 GB of data and Text can store upto 255 characters.

what is query ?

A query is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.

what is the field size of yes no field in MS Access?

= 1 bit

write the objects of MS Access.

=They are: tables, forms, queries and reports.

what are the types of queries in MS Access??

They are: 

• Select queries 

• Action queries 

• Parameter queries 

• Crosstab queries 

• SQL queries.

What are data types in ms access? Write some data types of ms access.

Data types are the building blocks of databases. Data type determines the kind of the values which users can store in any given field. 

Some data types of ms access are:

a) Text

b) number

c) Date and time

d) Memo

e) Currency

f) OLE

g) Yes/ No

h) Hyperlink

i) Attachment

j) Lookup wizard

which data type enters value automatically for the new records in MS Access?

= Auto number

differentiate between select query and action query.

Select queries do not change the data. They will show lists of data and various statistics and other requirements. Action queries do things like update records or delete records, which is changing the data.

differentiate between forms and reports.

differentiate between data sorting and data filtering in MS Access.

Sorting means arranging the data in ascending or descending order. Sorting can be done on numerical and textual values. Also it can be applied on multiple columns.

 Filtering is a quick and easy way to find and work with selected data based on the criteria you specify. The filter feature selectively blocks out the data you do not want to see and displays only the rows or columns that meet the conditions or criteria you specify. 

what is the caption in the table structure of MS Access?

Caption is the name that displays in the title bar at the very top of the report.

The caption field property is the field property that allows us to assign a descriptive name for a field name.

What is ( RDBMS ) relational database management system?

A relational database management system (RDBMS) is a program used to create, update, and manage relational databases. 

Some of the most well-known RDBMSs include MySQL, PostgreSQL, MariaDB, Microsoft SQL Server, and Oracle Database.

what is the importance of query in the database?

Queries help you find and work with your data

A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

While designing table structure which data types are suitable to store information about the teacher's name, address ,salary and date of birth?

= Teacher's name: Text

Address: Text

Salary: Currency

Date of birth: Date and time

Which data type is used to insert email addresses in MS Access?

= Hyperlink

differentiate between record and field.