In computerized
information system data is the basic resource of the organization. So, proper
organization and
management for data is required for organization to run smoothly. Database
management system
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),
Function of
DBMS, Advantages of DBMS and disadvantage of DBMS, Database Basics, Three level
architecture of
DBMS, Database users, Database language, Database structure.
Objective of this note is to understand the basic concepts and
the applications of database systems, the basics of SQL and construct queries
using SQL and explains the relational database design principles.
Author(s): Malla Reddy College Of Engineering
and Technology
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.
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.
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
ER model.