Everyone has a talent and so do you. Let it shine out, is all you have to do.
--Your friends at LectureNotes

Note for Database Management System - DBMS By Sujeet Choudhary

  • Database Management System - DBMS
  • Note
  • Cochin University of Science and Technology CUSAT, Eranakulam - CUSAT
  • Master of Computer Applications
  • Uploaded 11 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-2

• DBMS contains information about a particular enterprise – Collection of interrelated data – Set of programs to access the data – An environment that is both convenient and efficient to use • Database Applications: – – – – – – – Banking: transactions Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Online retailers: order tracking, customized recommendations Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions • Databases can be very large. • Databases touch all aspects of our lives Slide 1- 2

Text from page-3

Types of Databases and Database Applications • Traditional Applications: – Numeric and Textual Databases • More Recent Applications: – – – – – Multimedia Databases Geographic Information Systems (GIS) Data Warehouses Real-time and Active Databases Many other applications Slide 1- 3

Text from page-4

Basic Definitions • Database: – A collection of related data. • Data: – Known facts that can be recorded and have an implicit meaning. • Database Management System (DBMS): – A software package/ system to facilitate the creation and maintenance of a computerized database. • Database System: – The DBMS software together with the data itself. Sometimes, the applications are also included. Slide 1- 4

Text from page-5

Drawbacks of using file systems to store data • Data redundancy and inconsistency – Multiple file formats, duplication of information in different files • Difficulty in accessing data – Need to write a new program to carry out each new task • Data isolation – Multiple files and formats • Integrity problems – Integrity constraints (e.g., account balance > 0) become “buried” in program code rather than being stated explicitly – Hard to add new constraints or change existing ones

Lecture Notes