BIS Department, Helwan University: DBMS Lecture Notes - Chapter 1

These lecture notes, contributed by Dr. Ahmed Mohamed Abd-Elwahab from Helwan University's BIS Department, offer a comprehensive introduction to Database Management Systems (DBMS). The notes cover essential topics such as the definition of data and information, the purpose and advantages of database systems, and the drawbacks of file processing systems. The content delves into the characteristics of DBMS, including self-describing nature, program-data independence, multiple views, and data sharing. The notes also explore the applications of database systems. The lecture notes are structured with clear outlines, examples, and explanations, making them a valuable resource for students studying database management principles. The document is organized into chapters, with the first chapter introducing fundamental concepts and setting the stage for more advanced topics.

Lectures Notes in
Database Management Systems
Lecture (1)
Submitted By:
Dr. Ahmed Mohamed Abd-Elwahab
Lecture in BIS Department,
Faculty of Commerce & Business Administration,
Helwan University, Cairo, Egypt.

2
COURSE OUTLINE
❑ Chapter 1. Introduction to DBMS.
❑ Chapter 2. Relational Model.
❑ Chapter 3. Entity Relational Model.
❑ Chapter 4. Enhances Entity Relational Model
❑ Chapter 5. Relational Database Design (Mapp
❑ Chapter 6. SQL Basic.

3
CHAPTER (1)
Introduction to DBMS

4
Ch 1. OUTLINE (Part One)
❑ Introduction.
❑ Basic Definitions.
❑ Purpose of Database Systems.
❑ Disadvantages of the File Processing Systems.
❑ Main Characteristics (Advantages) of the Database
❑ Database Systems Applications.

5
1.1 Introduction
All OrganizationsPublic,Governmentalor Private,
Smallor Large depend on Computerized Informa
Systems (CBIS) for Carrying out their daily act

6

7
➢ Data - is a Raw Facts/Materials thatcan be stored
and can take the form of a number of statements.
❑ Data of Student:ID,Name,Age, Level, Gender…
❑ Data of Course:Code,Title,Cost, Hours, Type…
❑ Type of Data:Numbers, String, Text File, Audio, Video.
par chare afdl ast8lal mmkn ll data bt3tk

8
➢ Information - is data that has been converted i
meaningfuland usefulcontextfor end users.
(Processed Data).
❑ List of students is information.
❑ List of male students is information.
❑ The numbers of optional courses is informat

9
Example:
▪ Sales Data -is names, quantities and dollar amounts.
▪ Sales Information- is the amount of sales by product type, or by salespers

10
لكشب تانايبال نيزختمظنموترمب
تانايبال عاجرتساةعرسبوةلوهسوقدة

Flat File Environment
File Processing Database System

12
data wherehouse: aktr mn data base
data mining: discover al knolege from data