Database systems are pervasive. They are present in
every segment of commercial, academic and virtual world. They are required as
the backbone of any information system, enterprise resource planning, research
activities and other activity that require permanence of data storage. Database
management systems manage data more efficiently and effectively. Presently
almost all popular commercially available database management system support
relational model although many extensions of this model have been in existence.
Some of these DBMSs have been extended to include many advanced features such
as object-oriented support for graphical objects, vary large objects etc.
This course is an attempt to provide you with the
basic information about relational database management system and their
development. This course also provides the basic conceptual background
necessary to design and develop simple database system. Some of the basic
objectives of the course are to:
- · Provide an introduction to the needs of DBMS
- · Describe the features of Relational and ER models
- · Write SQL queries, create forms and queries
- · Draw ER diagrams and design databases
- · Discuss the features for Recovery, Concurrency and Security in DBMS.
Block 1 covers the basic concepts of RDBMS including
the three level database Architecture, the two most important models for
databases; the relational and entity relationship models, the integrity
requirements of databases, issues relating to normalisation of database and
basics about the conventional file organisation.
Block 2 is an attempt to provide you details on the
structured query language (SQL), the standard query language of commercial
DBMS. In addition, the concepts of Database Recovery, transaction management
and security have also been covered in this Block. This block also introduces
the concepts of the distributed and client server database.
Block 3 and Block 4 are oriented towards development
of a database system using DBMS software. Before, reading these blocks, you
must thoroughly go through the concepts given in block 1 and block 2 as they
will be required for any relational database management system application
development. Block 3 focuses on database development steps involving creation
of tables, relationships among tables, forms, reports and queries using the
tools of a DBMS. Block 4 on the other hand highlights the complete process of
development of a Database system for an organisation. It also briefs the
process of the system development.
RDBMS technologies are growing at a very fast pace. You
must keep up pace with it. Specially in the client-server levels of databases,
server side will be the designs you undertake here, whereas client side
development may involve various tools that may be available with the DBMS such
as report writers, form designers, ER diagramming tools etc. You must try to
practice on available DBMSs on Linux and Windows operating systems.
Download from Google Drive
Download from Google Drive
Post a Comment