Page 309 - IT 402 v2.0 class 10
P. 309
2. The director of a company uses a database to store data about job title. This is a part of the database given
below:
Employee Salary
Payroll
Last Name First Name Dept Salary (`) Job Title
Number
Shan James Finance A621 19500 Payroll Clerk
Gupta Shruthi Finance M5 35000 Accountant
edi eeta uman esources M 18500 Secretary
Walker Tia Sales W815 24000 Sales epresentative
Shafia Ahmed Factory H219 39000 Factory Manager
Mittal Chavi Purchasing M 20000 Purchasing Clerk
i. ow many records are there in this part of the database
ii. ow many fields are there in this part of the database
iii. hat is the ob title of the employee with ayroll Number M
iv. hich department has maximum employees and what are their ayroll Numbers
Ans. i. 6
ii. 6
iii. Secretary
iv. Finance department and their ayroll Numbers are and M5 .
. Shweta is a database administrator. She wants to add records and manage the data in computer and make it
available as per the re uirement. hich record keeping system can help Shweta to do so
ns. MS atabase Management System . xample: Ms- SS Open o ce org S .
. San eev designed a database for an organisation. It contains a set of tables. e can
fetch records from an individual table but he is unable to retrieve information from L if e S k il l s & V al ue s
another table. hat is the drawback in his database
ns. elationship is not established among the two tables.
Unsolved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. A database is an organised collection of ............................. .
i. data ii. Attributes
iii. ecord iv. None of these
. hich of the following is not the advantage of database
i. Sharing of ata ii. educe ata edundancy
iii. Increase ata Inconsistency iv. ata Security
3. A ............................. is a uni ue value that identifies a row in a table.
i. Primary Key ii. Field
ii. Foreign key iv. ueries
Database Management 307

