Page 306 - IT 402 v2.0 class 10
P. 306
B. Fill in the blanks.
. he concept of MS was developed by ............................. at I M in .
2. ............................. is the meaningful form obtained after processing of data.
3. Arranging records in ascending/descending order is called ............................. .
. wo ables are linked based on a field which is known as ............................. .
5. The ............................. option specifies the length of the data that can be stored in a field.
6. ............................. property specifies the width of the field.
7. The ............................. property specifies and controls how data is entered and displayed.
8. ............................. option should be activated if the field cannot contain N values.
ns. . .F. odd . information . Sorting
. key field 5. length . ength
. field . e uired or ntry re uired
Section B
(Subjective Type Questions)
A. Answer the following questions:
. hat are the benefits of using MS
ns. he benefits of using MS are:
Reduces Data Redundancy: MS reduces the duplication or repetition of data to a large extent thus
saving valuable disk space and time.
Sharing of Data: he data stored at one place can be used by multiple users or for different applications.
Sharing of data saves time and money. It helps in reusability.
Ensures Data Security: It allows only authorised users to access the data from the database. ifferent
permissions or restrictions are imposed on a database according to levels.
Reduces Data Inconsistency: he data remains updated in case any change is made i.e. when a modification
is made in one portion of data, the changes are automatically done in the other portion wherever that data
has been used.
Data Integrity: he MS ensures that only valid data can be entered into the database according to the
standards laid down by an organisation.
Interactive Interface: MS provides a convenient interface for entering or viewing data by providing a
presentable format according to the user s choice.
2. Write about the elements of a database.
Ans. The following are the elements of database:
Table: A table is a collection of logically related records. The records are arranged in a tabular structure in
the form of rows and columns. he columns represent fields and the rows represent records.
Query: It is a call or request to retrieve or generate some information from the tables. It generates
information according to the given conditions. It can retrieve information from a single as well as multiple
tables. It helps in managing as well as manipulating a database.
Form: It provides an interface in a user-defined layout which lets the user view enter records as well as
modify records. Data of tables can be displayed in the form view.
304 Touchpad Information Technology-X

