Question

Outline the basic sequences of steps to acquiring a DBMS.

01 Nov 2017
Answer :
Word Count : 2619

A DBMS is a software package that carries out many different tasks including the provision of facilities to enable the user to access and modify information in the database. The database is an intermediate link between the physical database, computer and the operating system and the users. To provide the various facilities to different types of users, a DBMS normally provides one or more spe­cialized programming languages called database languages.

Database languages come in different forms. They are: -

1. Data Description Language (DDL)

2. Data Manipulation Language (DML)

Data Description Language (DDL)

As the name suggests, this language is used to define the various types of data in the database and their relationship with each other.

The basic functions performed by DDL are: -

• Create tables, files, databases and data dictionaries.

• Specify the storage structure of each table on disk.

• Integrity constraints on various tables.

• Security and authorization information of each table.

• Specify the structure of each table.

• Overall design of the Database.

Data Manipulation Language (DML)

A language that enables users to access or manipulate data (retrieve, insert, update, delete) as organized by a certain Data Model is called the Data Manipulation Language (DML). It can be of two types: -

1. Procedural DML - It describes what data is needed and how to get it. For example: - Rela­tional Algebra.

2. Non Procedural DML - It describes what data is needed without specifying how to get it. For example: - Relational calculus.

Functions of DBMS

• DBMS free the programmers from the need to worry about the organization and location of the data i.e. it shields the users from complex hardware level details.

• DBMS can organize process and present data elements from the database. This capability enables decision makers to search and query database contents in order to extract answers that are not available in regular Reports.

• Programming is speeded up because programmer can concentrate on logic of the application.

• It includes special user friendly query languages which are easy to understand by non pro¬gramming users of the system.

The various common examples of DBMS are Oracle, Access, SQL Server, Sybase, FoxPro, Dbase etc.

The service provided by the DBMS includes:

• Authorization services like log on to the DBMS, start the database, stop the Database etc.
• Transaction supports like Recovery, Rollback etc,
• Import and Export of Data.
• Maintaining data dictionary
• User's Monitoring

ADVANTAGES OF DBMS

The DBMS (Database Management System) is preferred ever the conventional file processing system due to the following advantages:

1. Controlling Data Redundancy - In the conventional file processing system, every user group maintains its own files for handling its data files. This may lead to

• Duplication of same data in different files.
• Wastage of storage space, since duplicated data is stored.
• Errors may be generated due to updation of the same data in different files.
• Time in entering data again and again is wasted.
• Computer Resources are needlessly used.
• It is very difficult to combine information.

2. Elimination of Inconsistency - In the file processing system information is duplicated through¬out the system. So changes made in one file may be necessary be carried over to another file. This may lead to inconsistent data. So we need to remove this duplication of data in multiple file to eliminate inconsistency.

For example: - Let us consider an example of student's result system. Suppose that in STU¬DENT file it is indicated that Roll no= 10 has opted for 'Computer'course but in RESULT file it is indicated that 'Roll No. =l 0' has opted for 'Accounts' course. Thus, in this case the two entries for z particular student don't agree with each other. Thus, database is said to be in an inconsistent state. Sc to eliminate this conflicting information we need to centralize the database. On centralizing the data base the duplication will be controlled and hence inconsistency will be removed.

Data inconsistency are often encountered in every day life Consider an another example, w have all come across situations when a new address is communicated to an organization that we deal it (Eg - Telecom, Gas Company, Bank). We find that some of the communications from that organization are received at a new address while other continued to be mailed to the old address. So combining all the data in database would involve reduction in redundancy as well as inconsistency so it is likely to reduce the costs for collection storage and updating of Data.

Let us again consider the example of Result system. Suppose that a student having Roll no -201 changes his course from 'Computer' to 'Arts'. The change is made in the SUBJECT file but not in RESULT'S file. This may lead to inconsistency of the data. So we need to centralize the database so that changes once made are reflected to all the tables where a particulars field is stored. Thus the update is brought automatically and is known as propagating updates.

3. Better service to the users - A DBMS is often used to provide better services to the users. In conventional system,

___ _________ ____ __________ _____ _________ _____ ______ __________ ___ ___.
_________ __________ _________ _________ __________ _____.
______ _________ __________ ___ ___ ______ ________ ____ ___ _____.
_______ ______ ___ ________ _____ _______ __________ ____ _________.
________ _____ ________ ________ _______ _________ __________ _________ _________.
___ __________ ____ ________ __________ _______ _____ _____ ________.
_____ _________ ___ ____ ________ ______ _______ _____ _______.
_______ ____ ___ ___ ____ _________ ______.
_______ _________ _________ ___ __________ ________ ________ ___ ___ _________ ____.
______ ____ ______ _________ _________ ____ ________ ___ ______ ____.
____ __________ _______ __________ _______ __________ ____ ___ __________ ____.
__________ _____ ___ _________ ________ _______ ________ _____.
_________ _______ ________ _______ ___.
___ ___ ___ _______ ______ ________.
____ _____ _______ ___ ____ _______ ________ ____ _______ ______ ________.
__________ ___ _______ _____ ___.
_______ __________ __________ ___ ____ ________ ____ ________ __________ _____.
___ ______ __________ ________ _________ ______ _________ _______ _____ _______.
_____ ______ _____ _____ _____ ____ _________.
______ ____ _______ _________ _______ _________ __________ _____ _________.
________ _______ ___ ___ ________ ___ __________.
______ ___ _______ ___ _________ ____ _______ _________.
_______ __________ ______ ________ ______ ________ _________ ________ ________ ____ ____.
__________ ___ ________ ____ _____ ____ __________ ____ ________.
__________ __________ ____ ________ __________ _______.
_______ _____ ___ _______ _________ _________ __________.
________ ______ _______ _________ __________ ________ _____.
_____ _________ __________ _________ ______ ____ ______ __________ _______ ___.
__________ __________ _________ _______ _________ ____ _________ _______ ________ _________ ___.
___ ___ ______ _______ _________ __________ __________ ___ _______ ______ ______.
_________ ___ ______ ______ ____ ______ _______ ________.
_______ ________ ______ _____ ___ _________ _____ _________ ___.
________ ________ __________ ____ __________ __________ ______ ____.
_______ ________ ____ _______ _________ ___.
_____ ______ ______ __________ _________ _______.
_________ ________ ______ __________ ______ ___ ________ _________ ________ ______ _________.
__________ ______ _____ ____ __________ __________ ___.
__________ ___ _______ _________ _________ ___ ________ __________ _________ _________.
_________ ___ ______ ___ _________.
___ ________ ____ ___ _______ __________ ____ __________ __________.
_______ ___ __________ ___ ___ ____.
___ ________ ________ ___ ______ ______ _______.
________ ____ _______ _______ ______ ________ _____ ___.
_________ ___ __________ ___ ___ _______.
____ ___ _______ _______ ______ __________ ____ _________ _________ _______.
_______ _____ _________ ________ ________.
___ ______ ________ ______ ______ __________.
___ __________ ____ ___ _________ _____ ______ ______ __________.
_________ ________ ___ _____ __________ _______ ____ ________ __________ ________ ________.
__________ _____ __________ _____ ________.
__________ ___ _________ ________ ______ _______ __________ _________ __________ __________ _______ _________.
_______ _________ ____ ________ ________.
_________ _____ ________ ___ _____ _____ __________ ______ ________ _____ ____.
__________ ________ ____ _______ ______ ______ _________ ______.
____ _____ ________ __________ _________ ________ ___ _________ __________ _____ _________ _______.
______ ____ _________ ____ _________ _________ ______ ___ _____ ___ _________ _________.
__________ __________ _________ ___ ________ _________ __________.
________ _________ __________ _____ ________.
_____ _________ _____ ____ ____ _____ __________ _________ ___ _____ ________ ______.
_______ __________ _____ ___ ________ ____ ___ ___ ______ _______ _________.
_______ ______ _____ _________ _______ _______ __________ ________ ______ _____ ______ ______.
___ _______ __________ ____ _________ ______ _____ _____ _________ __________.
____ ________ ___ ______ ______ ______ ____ __________ __________.
_______ ________ __________ ___ ____ _____ _________ ___ _______.
_______ _________ __________ _______ _______.
_________ ________ _________ ______ _______ _________ __________ ______ ____ _________ __________.
______ _________ _________ __________ __________ ____ ____.
_______ ______ ____ ___ _____ ______ ____ ___ _______ _____.
__________ ________ ___ ____ ____ ___ __________.
__________ ________ _______ ___ ____ _____ ________ _______ _____ _______ ______.
__________ __________ ______ ____ _________ ___ _________ _________.
___ __________ _________ __________ ___ __________ ______ _______.
_____ ___ ___ __________ ____ ___ _____ __________ _____ __________ _______ ______.
_____ ______ ______ ________ _____ ______ _____ ________ _________.
_____ ________ ______ ________ _________ __________ _____.
__________ ________ _____ ____ _________ ______ ______ _______ ________ _________ _____.
____ _________ _____ _____ __________ ___ _______ ____ __________.
______ ________ ____ ____ __________ ___ ______ _______.
____ ____ __________ _____ ___ _________ ___ _________ ______.
_________ _____ __________ ________ ____ ______.
_________ _________ ___ _____ ___ ____ ___ _________ ___ ____.
____ ___ _____ ________ ____ ____.
_____ ____ _____ __________ ______ __________ ______ ___ ________ _________ _____.
___ _____ _____ ________ _____ ______ ___ ______ ______.
_____ __________ ____ ________ ___ ________ ______.
___ ____ ___ __________ _____ ___ _______ _____ ___ ___.
_________ _________ _________ _______ _____.
_______ _________ ___ ___ _____ ____ ________ ________ __________ ____.
__________ _______ _____ ____ __________ _________ _____ ___ ______ ______ ________.
_________ _______ ____ ________ ____ ________ ____ _______ ___ _______ ________ ______.
_______ ______ _____ _______ ___.
__________ ______ __________ ________ _____ ______ ________ ____.
____ _______ ____ _______ ________ _____ _____ ___ __________ _______.
__________ __________ _________ _____ _________ ________ ______ _________ __________ ___.
________ ___ ________ ___ ________ _________ ______ ________ ____.
________ ________ ______ _______ ___ ___ ________ ________ ___.
______ ________ ____ ___ ___ ____ ______ ________ ________ _________ _______ ______.
____ ____ ____ _______ ____.
__________ _____ ______ _______ ______ ________ ________ _______ __________.
_________ ____ ___ ________ ____ ______ _______ ___ _______.
__________ _________ ___ ____ _________.
____ _______ _______ _____ ___ ________ ___ _______ _________.
______ _________ ____ ___ ___ _________ _______ _______ __________ ____ _____ _______.
__________ _____ _______ ___ ________ _______ _____ __________ ________ _____ _____.
__________ _____ _____ ____ _____ _________ ________ ___ ________ ____ _______.
______ _____ _____ ______ ______.
_______ ___ _______ _________ _____.
______ ___ _________ ___ __________ _________.
______ __________ _____ __________ __________ ________ _________ _________ ________ _____ _______ __________.
______ ________ ________ ______ _________ ________ ______ ___ _______.
_____ __________ ______ ______ ______ _________ ______ _____ _____.
_________ __________ _________ ______ __________ _______ ________ ____ __________.
__________ _____ _______ __________ ______ __________ _________ _______.
_________ _________ ___ __________ _______ ________ ___.
______ __________ ___ __________ __________.
__________ __________ ______ ________ ___ ____ _________ ______ ______.
____ _______ _______ _____ _______ ____ ________ ______.
_______ _________ ________ _____ _________ _____ ___ __________.
_______ __________ ________ ______ _________.
______ ___ __________ ________ _________ ______ ________ _________ _____ ___.
______ ___ ________ _____ ___ ____ ________ _________ _________ ___.
______ _____ ______ __________ _____ __________ _____ ______ _____.
_______ ______ ________ __________ ____ _________ ______ ___.
_________ ______ _______ __________ ______ __________ _________ ____ __________ _________ ___.
___ _______ _____ ____ ___ ___.
__________ _________ ___ _________ _________ ____ ____ ___ _________ _______ ___ _______.
_________ ________ _______ _____ _____ ________ ____ ___ ____ _______.
_____ _______ _________ ______ _________.
____ ________ _________ ________ ___ ______ _________ _____ _______ ______.
________ __________ ___ ______ ______ _________ ________ _______ _______ _________ _______.
_______ _______ ___ ___ _____ ________.
___ __________ ________ ____ ___ ________ ___ ________ ____ _____ ________.
___ ________ ___ ___ ___ ___ _________ ________ _________.
______ ___ ____ __________ _________ ___.
_________ _______ _______ ___ ________ ___ _____ ______.
______ ____ ___ ____ ______ _____ _____ ___ ________ _______.
_____ _________ ________ ________ _____ ____ ________ ________ _______ ______.
_______ __________ _________ _______ _____ ________ ______.
___ _________ _________ ____ _______ ___ __________ _______ ____ _________ _______ ___.
__________ _______ ___ ____ _____ ____ ___ _________ _____ ___ ______.
_____ _________ __________ _________ ________.
_____ ________ _________ __________ _________.
_____ _____ ___ ________ _______ ____ ___.
_____ __________ ________ _______ ________.
_________ _______ ______ ____ ______ ________ ___ ____ ____ ______ _____.
___ __________ ________ __________ __________ ______ __________ _______ ___ _______ _______.
________ ______ ____ ______ _________ _________ _________ _____ _____ _______ ________ ________.
________ ____ _______ ________ _________ _____ _____ _______ _________ _________ _______ __________.
____ _________ _____ ______ ______ _________ ____.
_____ ______ _______ _________ _____ ________ _______.
______ ______ _______ ________ _______ ________ ____ ___ _________ ____.
______ ____ _____ _______ _______ __________ _____ _______ ________ ____.
____ ___ ______ _____ _________ ___ _______ __________.
__________ ___ _______ __________ ________ __________.
_____ _____ ____ _________ _________ __________ ______ ___ ______ _____ _____.
________ ______ ________ ____ ______ ________ ________ _________ __________ ______ _____.
__________ ____ ________ __________ _________ ________ ________ _______ ________.
________ ________ __________ ___ _______ __________ ______ _______ ___.
__________ ___ __________ ____ ____ __________.
________ _________ _______ ______ __________ _________ _________ _______ _____ __________.
___ _______ _____ __________ _____ ____ ________ ____ _______ _______ _______.
_________ _______ ______ _________ _____ ______.
____ _______ _____ ______ __________ ________ _________ _________ _______ _____ _______.
_________ __________ __________ __________ ______ __________ ___ _____ ____ _________ __________ _____.
__________ ___ ______ ______ ___ _______ ________ ______.
_______ _____ ________ ___ __________ _________ ________ ____ __________ _____ _________.
____ _____ ____ __________ ____ ______ ____ _________ _______ ____.
___ ___ _________ ___ ________ _________ __________ _______.
______ _______ ________ _____ _________ _____ ____.
_______ _________ ______ _________ __________ ___ ____ ___.
___ __________ ______ _______ __________ _________ _____ _________ _______ ___.
______ ______ _____ ____ ______ ______ _________ ________ __________ __________.
_______ ____ _______ ____ _______ ______ _____ ______ ______ _____ _____.
_________ ____ _____ ___ _________.
____ ________ ____ __________ __________ __________ _________ ________ __________ ______ _______.
_____ ____ _______ _____ __________ _______ ____ _____ __________ ___ _______ ___.
_____ _____ ___ ____ ______ __________ ________ _____ ________ __________.
______ _____ ____ _________ ____ _____ _________ ________.
__________ ____ ____ _______ _____ _______ ______ ___ __________.
________ ___ _______ ________ ____ ________.
_______ __________ ________ ____ _________ ____ __________.
________ ______ ______ ________ __________ __________ _______ ___ ____ _______ ________ ______.
______ ____ ______ ________ ___ __________ ____ __________ ____ _________ ___ ___.
____ ___ __________ _______ _________ __________.
_________ ______ _________ ___ ______ _____ ________ ________.
_______ ______ ___ _________ _______ _________ ____.
_______ ___ _______ ______ _______ ____ __________ ______ ___ __________ _____ _______.
_____ ________ ___ _______ _____ ______ __________ ______ _________ _________.
________ ___ _________ _______ ________.
____ _____ ___ _____ ___ _____.
__________ __________ ___ ___ _________ ______ ____.
______ ______ _________ ______ ___ ______ ______ ________ ________ ________ ______.
_________ _____ _________ ______ __________ _______ _____ __________ ____ ________ __________ _________.
________ ____ ______ _____ _______ ________ _________ _______ __________ _______ _______.
___ _______ __________ ___ _______ _________ ___.
_________ __________ ______ ___ ____ ________.
________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MS 54 2011 - Outline the basic sequences of steps to acquiring a DBMS. | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→