1 - DBMSConceptsand Architecture (LectureSession1)...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
DBMS Concepts and  Architecture (Lecture Session-1) Monday, January 18, 2010 1 DLPD, BITS-Pilani.                Prepared  by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction to DBMS Databases and Systems to manage them have become significant components of any present day business of any nature. These databases help businesses to perform their day-to-day activities in an efficient and effective manner. Data: Known fact that can be recorded and that has implicit meaning. Ex. Name , Tel_no , city etc. This data can be stored in a file on a computer. Database: Is a collection of related data. Monday, January 18, 2010 2 DLPD, BITS-Pilani.                Prepared  by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 2
DBMS: Is a collection of programs that enables users to create and maintain databases in a convenient and effective manner. DBMS is a software system that facilitates the following: 1. Defining the database: This includes defining the structures, datatypes, constraints, indexes etc. 2. Constructing the database: This means storing data into the database structures. 3. Manipulating database for various applications. This encompasses activities like querying the database , inserting new records into the database, updating some data items, and deleting certain items from the database. Monday, January 18, 2010 3 DLPD, BITS-Pilani.                Prepared  by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Some Examples of DBMS Applications: Banking – Accounting, Transactions etc. Airlines – Ticketing etc. Universities Credit card Transaction Telecommunications – Call record, billing etc. Finances Sales Human resources Manufacturing The above list becomes never ending. Monday, January 18, 2010 4 DLPD, BITS-Pilani.                Prepared  by Dr.R. Gururaj, Asst.Professor of CS
Background image of page 4
Traditional file Systems as Databases If we take the example of savings bank enterprise, information about customers and savings accounts need to be stored. One way to keep the information on computers is to store in files
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

1 - DBMSConceptsand Architecture (LectureSession1)...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online