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
This lecture
note covers introduction to database, management system, Introduction to basic
concepts of database systems, History of database systems, View of data,
Database languages, Database architecture and relational model.
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
The
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.