Introduction to Database Management Systems: Lecture Notes for BBA-6 Students, Exercises of Chemistry

Download Introduction to Database Management Systems: Lecture Notes for BBA-6 Students and more Exercises Chemistry in PDF only on Docsity!

Introduction to Information Technology

Introduction to Information Technology

Class :BBA -

Credit Hours (3)

Class :BBA -

Credit Hours (3)

Ajaz Khan Baig

2

Introduction to Information Technology

Lecture

Database Management

Reference:

Discovering Computers 2011: Living in a Digital World Chapter 10

10/29/

Databases, Data, and Information

Databases, Data, and Information

 Database software, often called a database management

system (DBMS), allows users to:

The Hierarchy of Data

 Data is organized in layers



Files, records, fields, characters

The Hierarchy of Data

Common data types include:

Maintaining Data

 Users add new records to a file when they obtain new data

Maintaining Data

 Users modify a record to correct inaccurate data or update

old data

Maintaining Data

Validation compares data with a set of (validation

checks/) rules or values to find out if the data is

correct

File Processing Versus Databases

Database Management Systems

 A DBMS provides several tools that allow users and

programs to retrieve and maintain data in the database

Database Management Systems

A query language consists of simple, English-like

statements that allow users to specify the data to

display, print, or store

Query by example (QBE) provides a GUI to assist

users with retrieving data

Database Management Systems

A form is a window on the screen that provides

areas for entering or modifying data in a database

Database Management Systems

A report generator allows users to design a report

on the screen, retrieve data into the report design,

and then display or print the report