Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Part B - Unit 3 - DBMS

    Uploaded by

    aditriganti2008

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Part B - Unit 3 - DBMS

    Uploaded by

    aditriganti2008
    21 views13 pages

    Original Title

    PART B- UNIT 3- DBMS

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    21 views13 pages

    Part B - Unit 3 - DBMS

    Uploaded by

    aditriganti2008

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 13

    PART B- UNIT 3: DATABASE MANGEMENT

    SYSTEM

    1. Define the terms


    (a) Database
    (b) Data redundancy
    (c) Report

    2. Give one point of difference between


    (a) Data and Information,
    (b) Form and Query,
    (c) Network and hierarchical data model
    3. Give any four advantages of a DBMS.

    4. Consider the table given below and answer the questions that follow

    (a) Name the fields in the given table.

    (b) Which field should be made the primary key?


    (c) Is there any alternate key in the table?

    (d) How is primary key different from foreign key? Explain with example.
    CHAPTER 9 Starting with LibreOffice
    Base
    D. Answer the given questions
    1. Differentiate between:
    (a) Memo and Varchar data type

    (b) Number and Decimal data type

    (c) Design View and Datasheet view of a table


    2. Name the menu items present on the Base User Interface.

    3.Label the components – Title Bar, Database Pane, Tasks


    Pane, Status Bar of the LibreOffice Base User Interface.

    4. How can we define a primary key in a table?


    5. Write steps to sort the table in descending order of
    primary key.

    6. What is the use of navigation box with respect to tables in


    a database?
    CHAPTER 10 :Working with
    Multiple Tables
    D. Answer the following questions

    1. Give any two advantages of relating a table in a database.

    2. How is redundancy or inconsistency controlled in a


    database? Explain with an example.

    3. Define referential integrity. Who maintains referential


    integrity in a database?
    4. Differentiate between one to one relationship and one to
    many relationship. Give suitable examples to explain your
    answer.
    5. Explain many to many relationship with an example.
    CHAPTER 11 Queries in Base
    D. Answer the given questions
    1. Define a query? What is the need of creating a query in a
    database?

    2. Rearrange the steps given below so as to create a query


    using a wizard.
    1. Give Alias
    2. Select the fields
    3. Set the criterion
    4. Set the sorting order
    5. Give table name

    3. What all information is seen in the overview (last step) of


    the Query wizard?
    4. What is the use of Alias row in the Design grid of the Query
    Design window?

    5. Name any four mathematical functions that can be applied


    to numerical data in a query.

    6. Name the three ways of creating a query in LibreOffice


    Base?
    CHAPTER 12 Forms and Reports
    D. Answer the following questions
    1. Give one difference between a form and a report.

    2. What is a field control with respect to forms?

    3. Which tool on the Forms Record toolbar is used to insert


    text on the form?

    4. Name the two ways to create a form in LibreOffice Base.


    5. What is the difference between a static and a dynamic
    report?

    6. Write the function of Forms Controls toolbar and Records


    toolbar.

    You might also like