Covered topics: Introduction to databases,
Relational model, algebra, calculus, Basics of SQL programming, Advanced
SQL programming, Database design and normalization, Basics of query and
transaction processing, Introduction to XML (data format and query languages).
information system data is the basic resource of the organization. So, proper
management for data is required for organization to run smoothly. Database
deals the knowledge of how data stored and managed on a computerized information
system. In any
organization, it requires accurate and reliable data for better decision making,
ensuring privacy of
data and controlling data efficiently. The contents include: Introduction,
Disadvantages of file
oriented approach, Database, Why Database, Database Management System(DBMS),
DBMS, Advantages of DBMS and disadvantage of DBMS, Database Basics, Three level
DBMS, Database users, Database language, Database structure.
Database is a collection of interrelated
data and set of programs can access that system. The contents include: Conceptual Modeling,
Relational Approach,Basic Sql Query and Normalization, Transaction Management, Concurrency Control.
Author(s): Ms. K Radhika
Assistant Professor, Ms. P Navya Assistant Professor, Department of Computer
Science Engineering,Institute of Aeronautical Engineering
The contents include: What is DBMS, The relational data model,
Entity-Relationship (E/R)modelling, Relational algebra and relational calculus, SQL, Case Study - Cancer
registry for the NHS –challenges, Schema refinement I, Schema refinement II, Schema refinement III and
advanced design,On-line Analytical Processing (OLAP), Case Study - Cancer registry for the NHS
-Experiences, XML as a data exchange format.
Author(s): Ken Moody, Computer Laboratory, University of Cambridge,UK
purpose of this note is to give students about an understanding of what database
systems are, why we use them, how to use common database systems efficiently
and how database systems work internally. Also teaches about variety of data
management tasks and different approaches to them.
This note covers the following topics: Databases and database users, database system
concepts and architecture, relational data model, lab manual, the relational
data model and constraints, Relational algebra and calculus, sql, basic sql,
JDBC API to access relational databases in java, JDBC API javadoc, sun JDBC,
JDBC scrollable resultsets, oracle JDBC drivers for java 6, ER model, enhanced