Db lec 04_new

Introduction to DBMS

1. +
Dr Ramadan Babers
Faculty of Science -HelwanUniversity
Fall 2018
DB
LEC-04

2. Entity-Relationship Model (ER Model)
2
Degree of Relationship
Many-to-many: One entity from A can be associated
with more than one entity from B and vice versa.

3. Many-to-Many
3
BooK

4. Many-to-Many
4
Author

5. Many-to-Many
5
BooK
Author
BooK Author

6. 6
Book_Author
Many-to-Many

7. 7
Book Author
Book_Author
Many-to-Many

8. Entity-Relationship Model (ER Model)
8
Degree of Relationship
How to Handle a Many-to-ManyRelationship in
Database Design

9. + DatabaseSystems
BasicConcepts
9

10. 1-Areas of Database Study
10
DBMSsoftware
DatabaseDesign
QueryLanguages
ApplicationProgramming
DatabaseAdministration
Data Warehousing & DataMining

11. 2-Characteristics of the Database Approach
11
insulationof programs & data
supportof multiple user views
use of a catalogto support database descriptions
DB
A collection of described and interrelated data storedand
managed by general purposeDBMS

12. 3-DBMS Functions
12
Data Dictionary
Data Storage Management
Data Transformation and Presentation
Security
Multi-user Access Control
Backup and Recovery
Data Integrity
Database Access Language
Database Communication Interface

13. 4-Database System Environment
13
DBMS
Software
ApplicationPrograms/Queries
Software:
QueryProcessing &programs
Software: DataAccess
Database
System
Users/Programmers
Database
Definition
Database

14. 5-Database Approach
14
Data definition language(DDL).
Permits specification of data types, structures and any
dataconstraints.
All specifications are stored in thedatabase.
Data manipulation language(DML).
General enquiry facility (query language) of thedata.

15. 6-Components of DBMS Environment
15

16. 6-Components of DBMS Environment (cont.)
16
Hardware
Can range from a PCto a
networkofcomputers.
Software
DBMS, operating system,
network software(if
necessary) and also the
applicationprograms.
Data
Used by the organization
and a description of this
data called theschema.

17. 6-Components of DBMS Environment (cont.)
17
Procedures
Instructions and rules
that should be applied to
the design and use of
the database andDBMS.
People

18. 7-Database Players (3 types)
18
DBA
access authorization, coordination &
monitoringdatabase usage, problem
determination, performance tuningetc
Designers
identify the requirements & chose the appropriate
structures to represent & store thedata
Users(Casual, parametric, Sophisticated,stand-alone)
System analysts & applicationprogrammers
DBMS system designers &implementers
Tooldevelopers
Operators & maintenancepersonnel

19. 8-Database User Types (4 types)
19
Users(Casual, parametric, Sophisticated,stand-alone)
Casual end usersoccasionally access the
database, but they may need different
information each time. They use a sophisticated
database query language to specify their
requests and are typically middle-or high-level
managers or other occasional browsers.
Naive or parametric end users make up a
sizable portion of database end users. Their main
job function revolves around constantly querying
and updating the database, using standard types
of queries and updates—called canned
transactions.

20. 8-Database User Types (cont.)
20
Sophisticated end users include engineers,
scientists, business analysts, and others who
thoroughly familiarize themselves with the
facilities of the DBMS in order to implement
their own applications to meet their complex
requirements.
Standaloneusers maintain personal
databases by using ready-made program
packages that provide easy-to-use menu-
based or graphics-based interfaces. An
example is the user of a tax package that
stores a variety of personal financial data for
tax purposes.

21. 9-DBMS Interfaces
21
Menu-based Interfaces forbrowsing
Forms-basedInterfaces
GUIs
Natural LanguageInterfaces
SpecializedInterfaces
Interfaces for theDBA
QueryLanguage