The book Introduction to Database Management System is an outcome of practical and teaching experience of the authors on the subject. The knowledge of database systems has become an essential part of education in computer field. The book covers the syllabus of B.Tech/M.C.A./B.C.A./M.B.A. of various universities. The book presents an exhaustive and up-to-date exposition of database management system in an easy-to-understand manner. A large number of well-defined figures have been included to explain the concepts in a better way. The book bridges the gap between theoretical learning and practical implementation of databases for various applications. The book will help the students to grasp every topic without any difficulty. Special efforts have been made to minimize the errors.
Additional Info
  • Publisher: Laxmi Publications
  • Language: English
  • ISBN : 978-93-81159-31-6
  • Chapter 1

    Introduction to Database Systems Price 2.99  |  2.99 Rewards Points

    An organization must have accurate and reliable data (information) for effective decision making. Data (information) is the backbone and most critical resource of an organization that enables managers and organizations to gain a competitive edge. In this age of information explosion, where people are bombarded with data, getting the right information, in the right amount, at the right time is not an easy task. So, only those organizations will survive that successfully manage information.
  • Chapter 2

    E-R and EER Models Price 2.99  |  2.99 Rewards Points

    The entity-relationship (E-R) model was introduced by Chen in 1976. He described the main constructs of the E-R model i.e., entities, relationships and their associated attributes. The E-R model continues to evolve but there is not yet a standard notation for E-R modeling. E-R model is mainly used for conceptual data modeling. It is popular due to the factors such as relative ease of use, CASE tool support, and the belief that entities and relationships are natural modeling concepts in the real world.
  • Chapter 3

    File Organization Price 2.99  |  2.99 Rewards Points

    A file organization is a way of arranging the records in a file when the file is stored on secondary storage (disk, tape etc.). The different ways of arranging the records enable different operations to be carried out efficiently over the file. A database management system supports several file organization techniques. The most important task of DBA is to choose a best organization for each file, based on its use. The organization of records in a file is influenced by number of factors that must be taken into consideration while choosing a particular technique. These factors are (a) fast retrival, updation and transfer of records, (b) efficient use of disk space, (c) high throughput, (d) type of use, (e) efficient manipulation, (f ) security from unauthorized access, (g) scalability, (h) reduction in cost, (i) protection from failure.
  • Chapter 4

    Data Models Price 2.99  |  2.99 Rewards Points

    A data model provides mechanism to structure the data for the entities being modelled, allow a set of manipulative operators to be defined on them, and enforce set of constraints to ensure the accuracy of data. Thus we can say it is a conceptual method of structuring the data.
  • Chapter 5

    Relational Algebra and Calculus Price 2.99  |  2.99 Rewards Points

    Relational algebra is one of the two formal query languages associated with the relational model. It is a procedural language. It specifies the operations to be performed on existing relations to derive result relations. A sequence of relational algebraic operations forms a relational algebraic expression. The result of the relational algebraic expression is also a relation. The relational algebra is very important due to many reasons. Firstly, it provides a basic foundation for relational model operations. Secondly, it is used as a basis for implementing and optimizing queries in RDBMS’s. Thirdly, some of the basic concepts of relational algebra are incorporated into the SQL language.
  • Chapter 6

    Functional Dependency and Normalisation Price 2.99  |  2.99 Rewards Points

    Normalization is based on the analysis of functional dependencies. A functional dependency is a constraint between two attributes or two sets of attributes. The purpose of the database design is to arrange the various data items into an organized structure so that it generates set of relationships and stores the information without any repetition. A bad database design may result into redundant and spurious data and information.
  • Chapter 7

    Query Languages Price 2.99  |  2.99 Rewards Points

    In the previous chapter, we have discussed about the relational algebra and relational calculus that are used for relational query. Both provide a powerful set of operations to specify queries. But both type of languages are expensive to implement and use. In this chapter, we discuss two query languages that are widely used in the various commercial RDBMS’s. The first one is the Structured Query Language (SQL) and the second one is the Query-By-Example (QBE).
  • Chapter 8

    Transactions and Concurrency Control Price 2.99  |  2.99 Rewards Points

    Transaction is a logical unit of work that represents the real-world events. A transaction is also defined as any one execution of a user program in a Database Management System (DBMS). The transaction management is the ability of a database management system to manage the different transactions that occur within it. A DBMS has to interleave the actions of many transactions due to performance reasons. The interleaving is done in such a way that the result of the concurrent execution is equivalent to some serial execution of the same set of transactions.
  • Chapter 9

    Database Security and Authorization Price 2.99  |  2.99 Rewards Points

    Database Security and Authorization
  • Chapter 10

    Database Recovery System Price 2.99  |  2.99 Rewards Points

    A Computer system can be failed due to variety of reasons like disk crash, power fluctuation, software error, sabotage and fire or flood at computer site. These failures result in the lost of information. Thus, database must be capable of handling such situations to ensure that the atomicity and durability properties of transactions are preserved. An integral part of a database system is the recovery manager that is responsible for recovering the data. It ensures atomicity by undoing the actions of transactions that do not commit and durability by making sure that all actions of committed transactions survive system crashes and media failures. The recovery manager deal with a wide variety of database states because it is called during system failures. Furthermore, the database recovery is the process of restoring the database to a consistent state when a failure occurred. In this chapter, we will discuss different failures and database recovery techniques used so that the database system be restored to the most recent consistent state that existed shortly before the time of system failure.
  • Chapter 11

    Query Processing and Optimization Price 2.99  |  2.99 Rewards Points

    Query processing requires that the DBMS identify and execute a strategy for retrieving the results of the query. The query determines what data is to be found, but does not define the method by which the data manager searches the database. Therefore Query optimization is necessary to determine the optimal alternative to process a query. There are two main techniques for query optimization. The first approach is to use a rule based or heuristic method for ordering the operations in a query execution strategy. The second approach estimates the cost of different execution strategies and chooses the best solution. In general most commercial database systems use a combination of both techniques.
  • Chapter 12

    Parallel and Distributed Databases Price 2.99  |  2.99 Rewards Points

    To meet the changing requirements of the users, the modern database systems operate with an architecture where multiple CPU’s are working in parallel on the database to provide the services. These multiple CPU’s are working in parallel and are located in the same building and communicating with each other at very high speed. The databases used in such systems are called parallel databases. Parallel systems improve processing and I/O speeds by using multiple CPU’s and disks in parallel. Parallel processing divides a large task into many smaller tasks and executes the smaller tasks concurrently on several CPU’s and completes it more quickly. Parallel computers with hundreds of CPU’s and disks are available commercially.
  • Chapter 13

    Data Warehouses and Data Mining Price 2.99  |  2.99 Rewards Points

    It is general concensus among the Business gurus that in today’s competitive market readily available high quality information is vital in business. Consider the comments from a management expert. “Information is pivotal in today’s business environment. Success is dependent on its early and decisive use. A lack of information is a sure sign for failure. The rapidly changing environment in which business operates demands ever more immediate access to data”. (Devlin, 1997).
  • Chapter 14

    Database Design Project Price 2.99  |  2.99 Rewards Points

    Database design is an interactive process. Lots of tools and methods are available to design database. Database is the most important part of an organization. Growth of any organization depends upon its database. Database should be consistent. In a large organization situated in different continents with large number of users, an effective database is required to provide database independence, rights to handle database and consistent data. Database should be able to handle rapid changes, interactive queries and support distributed data handling etc. To design such kind of database a systematic procedure is required so that DBA can design an effective database.
  • Chapter 15

    Additional Topics Price 2.99  |  2.99 Rewards Points

    Additional Topics

About the Author