• Class: Seven

    Chapter 3: Database

    Exercise Solution

    1. Fill in the blanks:

    a) DBMS stands for                   .
                      signify the behaviour of the field.
    c) All the fields relevant to one entity are called as                   .
    d)                   helps to generate information on the basis of tables.
                      is the name of a field that uniquely identifies a record in a table.
                      means storing of same data in duplicate form in different tables separately in same database.

    2. Select the most suitable alternative:

    a) The same information that can be used at different format is known as:
    (i) Data Inconsistency          (ii) Data Redundancy      
    (iii) Sharing      (iv) None of these

    b) The layout for data entries which are based on tables with same information is known as:
    (i) Forms                             (ii) Reports                    (iii) Tables        (iv) Queries 

    c) A table is made of:
    (i) Row and Columns        (ii) Columns          (iii) Row and Records        (iv) Columns and Fields

    3. Write short notes on:

    a) DBMS

    Answer: Database Management System (DBMS) is a tool  for managing and manipulating information of a database. It is designed to store, retrieve, define and manage data in a database.

    b) Field Type

    Answer: The field type determines the type of data which will be entered by a user in a particular field (alphanumeric, numeric, date, and so on).

    c) Record

    Answer: A record is collection of organised data or related facts. It is (sometimes called row) is a group of fields within a table that are relevant to a specific entity. 

    d) Field Name

    Answer: PrinterField name is the name given to the particular column in a table. It indicate what data is contained in each column. 

    e) Tables

    Answer: A table stores information that are stored under records(rows) and fields (columns). In a table every field has different name. i.e. Table is a structure that organises data into rows and columns - forming a grid.

    4. Differentiate between:

    a) Forms and Report

    Answer: It 

    b) Field and Record

    Answer: It 

    c) Text and Numeric data type

    Answer: Motherboard

    5. Answer the following questions:

    a) What is DBMS? What are the features of DBMS?

    Answer: QWERTZ.

    b) What are the components of a database? Explain about it.

    Answer: Nibble.

    c) What is Data Type? Explain different data types used in database package.

    Answer: Platter.

    d) What is Primary Key? How can you set primary key in a table?

    Answer: 120 mm.

    6. To calculate India's population "Jan Ganana" is being done and a database is being prepared for the same. What data type should be used to enter Date of Birth of the citizens in the database?

    Answer: 120 mm

    7. An inter school Sports Meet is going to be organised in which hundreds of students from different schools will participate. Sports events like 'high jump', 'lawn tennis', 'badminton', 'basketball' etc. will be organised. The data of all such events has to be stored on the basis of school, class, age etc. so that different reports for National Level Tournament can be generated. Suggest a package to accomplish such task.

    Answer: 120 mm