What do you mean by database management system? Write down the advantages of database system are traditional file processing system.
Subject | Introduction to Computer System |
---|---|
NU Year | Set: 6.(d) Marks: 8 Year: 2010 |
A database management
system (DBMS) is system software for creating and managing databases. The
DBMS provides users and programmers with a systematic way to create, retrieve,
update and manage data.
The principal advantages of
DBMS over file processing system:
• Flexibility: Because
programs and data are independent, programs do not have to be modified when
types of unrelated data are added to or deleted from the database, or when
physical storage changes.
• Fast response to
information requests: Because data is integrated into a single database,
complex requests can be handled much more rapidly than locating data
separately. In many businesses, faster response means better customer service.
• Multiple access: Database
software allows data to be accessed in a variety of ways (through various key
fields), by using several programming languages (both3GL and nonprocedural4GL
programs).
Lower user
training costs: Users often find it easier to learn such systems and
training costs may be reduced. Also, the total time taken to process requests
may be less, which would increase user productivity.
• Less storage: Theoretically,
all occurrences of data items need be stored only once, thereby eliminating the
storage of redundant data. System developers and database designers often use
data normalization to minimize data redundancy.