CHAPTER-6

Database and DBMS-

An Introduction
EXERCISE Q & A :-

1. What is Database? Write an example.

Ans :-
 Database is a collection of related data, held together in an
organized way.
 Some examples of popular database software or DBMSs are
My SQL, Microsoft Access, Microsoft SQL ,Oracle etc.

2. What is Data? Write an example.

Ans:-
o Data are some raw facts without any context.
o Data are any words, numbers, dates, images, sounds etc.
o For ex- 42 , Rabbits, 16:00 ,76, apples.

3. What is information? Write an example.

Ans:-
 Information is when the data is arranged in a way that make
sense.
 It means meaningful data is known as information.
 For ex- Customer details like name, address, phone number etc

4. Where are the uses of Databases?

Ans:-
Uses of Databases are in following area:-
1. Search engines
2. School Registration Record
3. Police database
4. Library database
5. Telephone Directory

5. How many Components of Table? Name them.

Ans:-
There are two components of table, that are:-
1. Data item(Field)
2. Record

6. Define:
a) Data item(Field)
b) Record
c) Table
Ans:-
a) Data item(Field)
 • A data item represents one type of information.
• A field is also known as a column or attribute.
• It may consist of any number of bits and bytes.

b) Record
Ans:-A record is a named collection of data items which
Represents a complete unit of information.

c) Table
Ans:- A table is a collection of all related data held in a table
format within a database.

7. What are the advantages of Database?

Ans:- Following are the advantages of Database:-

• Databases can store very large number of records efficiently.

• It is easy to add new data, edit or delete old data.
• More than one person can access the same database at the
same time.
• Hence, it is multi access, multi- user support.
• Data saved in database has more Security than in Paper
files.

8. What is DBMS?
Ans:-
A Data Base Management System is software that can
store, edit and organize data in Database.

9. What are the Features of DBMS?

Ans:-
Features of DBMS are:-
1. It stores data at one central location.
2. It allows multiple users to use the Database.
3. It allows Data Sharing.
4. It provides a systematic way to use Database.
5. A DBMS creates duplicate copies of database so that in
case of some data loss event, data can be retrieved from
saved copies of data.
6. A DBMS can Control who can access data and who
cannot.

10. How to Start MS- Access? Write its steps. Ans:-

STEP-1 Click at start Button.
STEP-2 From the start- All programs menu, click at
Microsoft office group’s Microsoft Access.
STEP-3 This will open the MS-Access window.
 11. Explain all the window components of MS-Access.
Ans:-
1) Title Bar: This is the top most bar that displays the title.
2) Quick Access toolbar:- This bar, displays various commonly
used command of MS- Access.
3) Access Ribbon:- This is situated below menu bar.
4) Database window: when a database is opened, all its
components are displayed in a separate sub-window of MS-
Access window called database window.
5) Navigation Pane:- When is database is open, it displays
various object buttons to navigate through various database
objects like Table Queries, forms, Reports etc.
6) Status Bar: This bar is located on the lower left corner of
MS-Access window and this reports all the progress of
database processing.

12. What is a Primary key?

Ans:-
A Primary key is a field (column) that has unique value in a table,
which is not repeated .
For Ex - Students Admission no, Aadhar no.

13. What is Data type? Write an Example.

Ans:-
Data type determine about what type of data is stored in
the field.
For ex:-
a) if the field contains number, we can perform arithmetic operations
like addition, subtraction, multiplication, division etc. on the
field value.
b)But if the field contains text only then we cannot
perform arithmetic operation on it.

14. Define all Data types.

Ans:-
1) TEXT:- Short, Alphanumeric values, such as a name, or a subject, or
a street address etc. are called text.

2) Number:- It is a numeric value, such as an age, bus-number, roll

number etc.

3) Currency :- It is a monetary value e.g., amount in rupees or dollars

or pounds or yen or Euros etc.

4)YES/NO:- Yes and No values and fields that contain only one of two
values e.g., to check whether a student uses school transport or not.
5) Date/Time:- Date and times values e.g., date of birth or date of
admission or exam date etc.

15. What are the Procedures to create a database in DBMS

Ans:-
Procedure to create a database in DBMS are:-
Step 1:- To Know the name and purpose of Database.
Step 2:- To Know about the tables in the database.
Step 3:- Once we know the table we should know the field list
(i.e. what fields are to be stored in each table)
Step 4:- Determine the data types for the field in the table.

16. What is the Procedure to create a blank Database?

Ans:-
Following are the steps to create a blank database:-
STEP 1:- Click on the file tab and then click New Command.
STEP 2:- From the Right Pane, Click Blank Database.
STEP 3:- Under Blank Database, type a file name in the file
Name box.
STEP 4:- Click Create.

17. What are the steps to Create a table in Datasheet view?

Ans:- Following are the steps to create a table in Datasheet view:-
1. Click on the create Tab.
2. Click on the table Design option in the tables group.
3. Enter the name of the field in the field name Column.
4. Choose the type for the field in the Data type Column.
5. Use the Field properties pane to set the properties for the fields,
Repeat steps 3 and 4 for all the fields in the table.
6. Click on the save button on the Quick Access toolbar name.

18. What are the steps to create a Primary key?

Ans:- Following are the steps to create a Primary Key:-

Step 1- Right click the table in which we want to set the primary key and
on the shortcut menu click Design view.
Step 2- Select the field that we want to use as a primary key.
Step 3- Click on the Design tab  Tools group Primary key command.
Step 4- A key indicator is added to the left of the field that we specify as
the primary key .

19. Define Query.

Ans:-
 Query is a question or Request for data.
 It is a way of searching and compiling (collecting) data from
one or more tables.
 20. What are the steps to create a Simple Query?
Ans:- Following are the steps to create a simple Query :-
Step 1- In Database window click Create tab  Query group  Query
wizard.
Step 2- It will open New query dialogue box , choose Simple query
wizard and click okay to create a Select query .
Step 3- Now, we will see the simple query wizard open on our screen
select the name of the table or query select fields whose data we want
to retrieve and click at Next .
Step 4- Follow the direction in the wizard dialogue boxes.
Step 5- At last we can choose either to run the query or to see the
query’s structure in Design view.
Step 6- Finally, result of query will be displayed.

********************************