Outline the basic sequences of steps to acquiring a DBMS.
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 specialized 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: - Relational 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
____ ___ _____ __________ _____ _____ ___.
_______ _____ ____ _______ _____ ________ ________ __________.
_____ ________ __________ __________ ____ _____ ______ ______ _________.
__________ ___ ___ ____ ____ _____ __________ ____.
________ ________ ______ ____ _________.
_____ _____ _______ ____ ________ ___ ________ ___.
_________ ______ _____ ___ ______ _________ ______.
________ ____ _____ ____ ____ ___ ______ _____ _________.
___ _________ _________ ____ ______ __________ ____ ______ _______ __________ ___.
_______ __________ ___ ___ _________ ______ ________ _____ ___ _______ _______ ______.
_______ __________ ____ ______ __________ __________.
___ ________ ____ ____ _______ ______ ___ __________ _________.
___ ___ _____ ________ _________ ____ __________ ____ ______ ______ _____.
_____ _________ ______ ____ _______ ____ _______ _____.
_________ __________ ___ _____ __________ ________ _________ _________ _______ __________.
_____ __________ ______ ______ ______ ________ _______.
_____ ____ _____ ______ __________ ___ __________ _______ ______ _______ _______ _________.
__________ ____ ___ ___ _________ ________ ____ ____.
________ ________ ___ ____ ___ ______.
___ ______ ______ _________ _____ __________ ____.
___ ___ _____ ________ __________ ____ __________ _______ _______ _________ _________ _____.
_________ ____ ______ _______ __________ ______.
____ __________ ______ ____ ________ ___ __________ ________ _________ _____.
______ __________ ____ ________ ______ ________ __________.
___ _________ ________ ___ __________ __________.
____ _________ ____ ______ ___.
_____ _________ ________ ______ ________ _________ ___.
____ __________ _____ ____ _________ ___ __________ _________ ___ ______.
__________ ______ ________ _____ __________.
________ ___ _________ ________ _____ _______ ___.
_______ ____ ___ __________ _________ ______ ____ ________ ____.
____ ________ ___ __________ _______ ________ __________ ________.
________ ______ ___ __________ __________ _______ _______.
_________ ___ _______ _______ ________ ___ ___.
_________ _______ _______ _____ ______ _______ ________ ________ ____ ________.
_________ ____ ______ _____ ____.
______ __________ _____ __________ _________ _____ _____ _________ _________.
_______ ________ ____ _____ _______.
_______ ____ ___ ____ ___ ______ _____ _______.
_____ ___ _____ __________ __________ __________ _____ _______ _____ ______ _________ ______.
___ ________ ______ __________ _____ _______ _________ _______ __________ ______ _______.
______ _________ _______ ________ ______ _______ _________ ______ __________ ________ __________.
_________ _________ ____ ___ __________ _________.
_________ ______ __________ ___ ______ ____.
_______ ____ ______ _____ ___ _____ _______.
___ ___ ________ ________ _________ ___ _____ _____ _________.
_____ _______ ____ ___ ____ ____ _______ __________ _____ _________ ______ ________.
_______ _________ ___ _________ _______ _________ ________ ____ _____ ______ ____.
______ ______ ___ _____ _______ ___ _____ _____ _______ __________.
___ _______ __________ ___ __________ _______ _______ ____.
__________ _________ __________ _____ _____ ________ ________ _________ ___ _______ __________.
____ _________ ____ ____ ______.
_____ ______ ______ ___ ___ _________ ________.
________ __________ _________ ___ _____ ____ _________ ___ ______ ______ _______ __________.
________ ______ _______ ________ ______ ______ _________.
_____ ____ ____ ______ __________ __________ _____ ______ ____.
___ _________ ____ __________ __________ __________ _______ _______ __________ ___.
_________ ______ ____ ________ __________ _____ ___ _____.
______ _____ _______ ___ ___ _______ _________ ____ _________ ___.
________ _____ ____ _____ ______ __________ ________ ___.
_____ ________ ________ _______ ___ ______ _______ _______ _________ __________ ____.
______ _____ __________ __________ __________ ___ ______.
___ ______ __________ ____ ___ ________ _______ __________ ___ _______ _________ _____.
_____ _____ ______ ____ _____ _______ ____.
__________ ____ _________ _______ _________.
__________ ____ ____ _____ __________ _________ ___ ________ _______.
___ __________ ___ _____ ________.
_____ __________ ___ _______ ________ _______ _____ ___ _________ _________.
_____ ________ ____ ____ ______ ________.
______ ________ _________ _________ __________ ________ _________ _____ __________.
______ __________ ____ __________ __________.
______ _____ _____ ___ __________ ________ ____ ______ ____ ______ _______ ________.
_____ _______ ________ ________ _________ _________ _____ ________.
___ _____ ________ _______ _____ _________ ____ _____ ________ ____ ___.
_______ ________ ____ __________ __________ __________.
_______ ________ _________ __________ ______ ____ ____ ______ ____ ____ ___ _______.
_________ ___ _______ __________ ___ ________ ____ __________ _______ _________ ____ _________.
____ __________ __________ _______ _______.
_________ ________ _________ ______ ______ _________ ________ _____.
________ _______ _________ ___ ________ _________.
_____ _________ _________ _________ _________ ____ ________ ________ ________ ________ ______.
_________ _____ ______ ___ ______ ____ ________.
______ _________ _________ __________ ___ ____ _________ ___ ________.
_____ _____ _________ ___ _____ _____ _________.
________ ________ ______ ________ _________ ________ _________ ______ ________ _____.
_________ _________ __________ ________ _____ ________ _______ ____ __________ ______ ______ ____.
______ __________ ___ __________ ____ ________ ______ _______ _____ _____ ___ __________.
____ ___ ________ _____ ___ ___ __________ ________.
_____ _________ __________ ____ _______ _________ ____ _____.
________ ______ _______ ______ ____.
_______ __________ __________ _______ _________.
_____ _________ ___ __________ _______ _______ _______.
___ _______ ________ _________ _______ _________ _______ __________ _____ _______.
________ _____ ______ ______ ___ _______.
_____ ________ _____ ____ _____ ____ _________ _______ __________ ________ ______.
___ ________ _______ __________ ____ _______ ____ ______.
_______ ________ ________ _________ _____ ________ _________.
____ _______ ____ __________ ___ _______ _______ ___ ______ __________.
________ _______ ___ _______ ______ ____ ______.
__________ ______ _________ ___ _________ _________ ______ ______.
______ _________ ___ __________ ________ ________ ____ _________.
_____ _____ ________ ____ ____ _________.
________ __________ _____ _______ _____ ____ ______ _________ ____ ______ ___.
___ _____ ____ __________ ____ ________ ___ _______.
______ ____ ________ ______ _________ _______ __________ _______ _______ ________.
___ ___ _______ _______ __________ _________ _________ _________ _____.
______ ____ ______ ___ ___.
________ _______ ____ ____ _____ __________ _________ _______ ____ ______ ____.
_______ _______ ____ ______ ______ ______ ________ _____ __________ ____ _______.
______ ________ _______ ____ _________ _____ _____ ___ _____ ______ ______ ___.
__________ ____ _________ __________ ______ _________ ____ __________ __________ _________ ___ ____.
___ _____ _____ _______ ______ ___ ___ ________ ______.
_____ ___ __________ ___ _____ ____ ___ ______ ________ _____.
____ ___ ______ ___ _____ ______ ______ _________ _____ _____.
_______ _____ _______ ___ ______ _________ _______ ______ ________.
___ ____ _____ ____ ___ ___ __________ _____ _______ _____ _______ ___.
________ _____ ___ ____ ____ ________ ________ _______ _____.
________ _______ ______ ______ ______.
____ ___ ____ ______ _________ __________ ____ ____ __________ ___.
___ _________ ________ _______ ________ ______ ________.
______ _______ __________ ________ ___ ___ ___ __________.
__________ _________ _____ ___ _____ ______.
__________ ______ _________ ____ _______.
_________ _____ ______ _________ _________ ____.
____ __________ __________ _____ ______ __________ _________ ________ _____ _________.
__________ ________ ____ __________ ___.
____ _________ ____ _______ ________ ______ __________ ______.
______ _______ ____ _______ ___ ______ ___ _______ __________.
_________ _______ _______ ____ _______ _____ ______ ____ _________ ___.
_________ ____ _____ ________ ______ ____ ________ ________.
_______ ______ ____ __________ ______.
__________ ____ ____ _____ _________ __________ _________ ______ _____ _________ ___.
____ _______ _________ ______ _____ _______ _____ _____ ____ ________.
________ _______ _________ ______ ________ ___ _________ _____ _________ ___ ________ ______.
______ ________ ______ ___ ____ ________ _______ ____ ______ _______ __________ _______.
______ _____ _________ _____ _________ _________ ____ _________.
__________ __________ _______ ______ _________ ______ __________ ________ __________ _____.
_________ _______ _________ _______ __________ _____ ______ ______ ____.
_______ _______ _________ _______ _____ ____ _______ ___.
____ ________ _______ ___ ______ __________ _________ __________ __________ ________ __________.
____ ___ _______ __________ ____ _________ _____ ___ _________.
_____ _______ ________ _________ __________ ________ _____.
_____ __________ __________ __________ _________ __________ ____ _______ ___.
_____ _________ _____ _____ _________ __________ ________ ________ _____.
____ ________ ___ __________ __________ ____ ____ ____ _____.
______ _____ ______ _________ ______ ________ ______ ________ _____ _______.
____ ___ __________ ______ _______ _____ ____ ____ __________ __________.
________ ________ _________ __________ _______ ___ ______ __________ ____.
___ ________ _________ _________ ______ ______ _______ _____ ______.
___ ____ _______ __________ ________ _________ _______ ____.
__________ ____ __________ _______ _______ ___.
______ _______ ________ ___ ______ ____ ____.
____ _________ ________ ___ ______ ________ _______ __________.
________ ____ _________ _______ _________ _________ _____ _____ _____ _________ ______ ________.
______ ________ ________ _______ _________ _______ ______ ______.
___ ______ ________ ____ ______.
___ ______ ____ ______ ______ ______.
_________ __________ _________ ____ _____ ___ ________ ____ ____.
_____ _________ ______ ________ __________ _______ ________ _____ ______ ______.
_____ _____ _____ _______ ____ ___ _____ ____ __________ _________.
_____ _________ ______ ______ ________ ______.
_________ _____ ____ ______ _______ ___ ___ _______ ________ ______.
______ __________ ____ ___ __________ ___ __________ _______ __________.
____ ___ ____ ______ ____.
___ _______ _________ _______ __________ __________ __________ __________ _________.
___ _______ ______ ________ ________ _______ _________ ____ ___ ___.
________ _______ ________ ___ ______.
_______ ________ ________ ____ ____ _______ _____ ________.
___ ___ ____ _________ ___ ________.
__________ _______ ____ ___ ____ ____ __________ ________ ______.
________ _____ ______ ______ _________ ______ ___ _____ _____.
_______ ____ __________ ______ _____ ______ ________ ____ ______ ________ ____ ___.
_________ ______ ________ ______ _____ ________.
_______ _______ ___ ________ _____ ________ _______.
_________ _______ _______ _____ ________ _______ ___ ___ ___ ________.
_____ _______ _____ _________ _________ ______ ______ _______ ________ _________ _________ ______.
____ ___ ______ _________ _________.
____ ___ ___ ________ ____ _____ ____.
_______ _____ _____ _________ _________ ___ ___.
______ ____ ___ __________ ______ ______ _______.
_______ _________ ___ __________ _____ _____ ______ __________ ________ _________ ______ ______.
___ ___ ____ ____ ____ ________ _____ _________ _____ ___ _________.
______ ______ ___ _________ ____ ____ _________ ___ _________.
___ _____ ____ _____ ________ ____ ____ ___ __________ ____ _______ _____.
__________ _________ _______ ___ ____ ______ ______ ____ _________ _____ _______.
_____ ____ ______ _____ _________ __________ _______ _____ ________ _________ _________.
___ ______ ________ _______ ______ _________.
_________ _______ _____ ___ ________ __________ ________ __________ ___ ___ _______ ________.
______ _________ ________ _____ ________ _________ _____ ____ ________ _____ ____.
____ ___ _____ ______ _________ _____ _________ _________ ___ ______.
____ __________ ____ _____ ________ ____ ____ _________ __________ _____ ____ ____.
________ _____ ________ _________ _________ ______ _____ __________.
_____ ___ _____ _________ _____ ____ _________ __________ _____ _______ ____.
_______ _______ __________ _____ ___.
____ __________ ______ ____ _____.
____ ________ _________ ___ _________ ________ _______ ______ _____ ___.
___ __________ _________ ____ ___ _________ ______ _____ ________ _________ ____ _________.
______ _________ __________ ______ __________ ___ __________.
___ ___ __________ ________ ___ __________ _______ ____.
____ ________ __________ _____ __________ _______ _____ _____ ____ __________.
________ _______ _____ _________ _________ _________ ___ ______ _____ ____ _____ ___.
_________ _____ _____ ____ _____ _______.
_________ ___ ____ ___ _____ _________ ________ ___ __________.
_________ _______ ________ _____ __________ _________ _________ _______ __________ _________ __________ _______.
_________ _______ ________ ___ ______ ___ _________.
_______ ____ _________ _________ __________.
_____ ______ ___ _______ _________ ______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required