Transcript Introduction

Eng. Husam Alzaq
Islamic University of Gaza
Course Objectives
 To provide students with an understanding of the
relational model, relational database design, and SQL.
Students will construct sophisticated data models and
implement them on modern relational databases using SQL
constructs.
 To provide students with a working knowledge of the
underlying architecture and implementation of modern
database systems.
Students will study file systems, indexing methods,
transaction management, and query processing.
Important Policies
No make-up quizzes and all exams are close-book
unless specified otherwise.
2. Make-up exam is given only when special
extenuating situation happens and under the
discretion of the instructor
3. You are required to attend every class. Exception is
given only if you notify the instructor with a
legitimate reason in advance.
1.
Other Important Policies
 Don’t arrive late to the class.
 All handouts are available on the instructor's website.
 You are required to check the instructor's website
periodically (at least once a day before the class time)
for important announcement.
Other Important Policies
 All assignments are due at the beginning of the class
time on the due day unless specified otherwise. No
late turn-in will be accepted – no exceptions!!
 No copying is allowed on any assignment. No
credit will be given to both copier's and copiee's
work.
 All assignments should include your work, or else no
credit will be given.
Definition
 A database is a collection of related data [2].
 Database is a collection of persistent data that can be
shared and interrelated [3].
‫تقدمي‬
‫ُ‬
‫ام ِه ْم فَ َم ْن أ ُ‬
‫ُ‬
‫َّ‬
‫ي ِكتَابَهُ ِبيَ ِمي ِن ِه‬
‫م‬
‫إ‬
‫ب‬
‫َاس‬
‫ن‬
‫ت‬
‫و‬
‫أ‬
‫ل‬
‫ك‬
‫عوا‬
‫‪ ‬يَ ْو َم نَ ْد ُ‬
‫ِ‬
‫ِ‬
‫ٍ‬
‫ِ‬
‫َ‬
‫ِ‬
‫َ‬
‫ون ِكتَابَ ُه ْم َو ََل يُ ْ‬
‫ون فَتِ ا‬
‫يًل ]النساء ‪[71‬‬
‫ظلَ ُم َ‬
‫فَأُولَئِ َك يَ ْق َر ُء َ‬
‫ان أ َ ْلزَ ْمنَاهُ َ‬
‫عنُ ِق ِه َونُ ْخ ِر ُج لَهُ يَ ْو َم‬
‫طائِ َرهُ فِي ُ‬
‫‪َ ‬و ُك َّل ِإ ْن َ‬
‫س ٍ‬
‫ْال ِقيَا َم ِة ِكتَاباا يَ ْلقَاهُ َم ْن ُ‬
‫ورا (‪ )13‬ا ْق َرأْ ِكتَابَ َك َكفَى ِبنَ ْف ِس َك‬
‫ش ا‬
‫علَي َْك َح ِسيباا (‪] )14‬اإلسراء ‪[14 – 13‬‬
‫ْاليَ ْو َم َ‬
‫ص ْينَاهُ ِكتَاباا ]النبأ ‪[29‬‬
‫‪َ ‬و ُك َّل َ‬
‫ش ْي ٍء أ َ ْح َ‬
‫تقدمي‬
‫‪ ‬فَأ َ َّما َم ْن أ ُ‬
‫ي ِكتَابَهُ ِبيَ ِمي ِن ِه فَيَقُو ُل َها ُؤ ُم ا ْق َر ُءوا ِكتَا ِبيَ ْه‬
‫ت‬
‫و‬
‫ِ‬
‫َ‬
‫]الحاقة ‪[19‬‬
‫‪َ ‬وأ َ َّما َم ْن أ ُ‬
‫وت ِكتَا ِبيَ ْه‬
‫ت‬
‫و‬
‫ي ِكتَابَهُ ِب ِش َما ِل ِه فَيَقُو ُل يَا لَ ْيتَنِي لَ ْم أ ُ َ‬
‫ِ‬
‫َ‬
‫]الحاقة ‪[25‬‬
‫ُ‬
‫َ‬
‫َ‬
‫ُ‬
‫ساباا‬
‫ح‬
‫ب‬
‫س‬
‫ا‬
‫ح‬
‫ي‬
‫ف‬
‫و‬
‫س‬
‫ف‬
‫)‬
‫‪7‬‬
‫(‬
‫ه‬
‫ن‬
‫ي‬
‫م‬
‫ي‬
‫ب‬
‫ه‬
‫ب‬
‫ا‬
‫ت‬
‫ك‬
‫ي‬
‫ت‬
‫و‬
‫ُ‬
‫ُ‬
‫ِ‬
‫ِ‬
‫ِ‬
‫ِ‬
‫ِ‬
‫ِ‬
‫‪ ‬فَأ َ َّما َم ْن أ َ َ ِ َ‬
‫َ‬
‫َْ َ َ َ‬
‫ورا (‪َ )9‬وأ َ َّما َم ْن أ ُ‬
‫َ‬
‫َ‬
‫ْ‬
‫ي‬
‫ت‬
‫و‬
‫ر‬
‫س‬
‫م‬
‫ه‬
‫ل‬
‫ه‬
‫أ‬
‫ى‬
‫ب ِإل‬
‫ْ‬
‫يرا (‪َ )8‬ويَ ْنقَ ِل ُ‬
‫ِ‬
‫ِ‬
‫ِ‬
‫ا‬
‫ُ‬
‫يَ ِس ا‬
‫َ‬
‫َ‬
‫ِكتَابَهُ َو َرا َء َ‬
‫ورا (‪)11‬‬
‫ف يَ ْد ُ‬
‫عو ثُبُ ا‬
‫ظ ْه ِر ِه (‪ )10‬فَ َ‬
‫س ْو َ‬
‫يرا (‪] )12‬اإلنشقاق ‪[12-7‬‬
‫َويَ ْ‬
‫س ِع ا‬
‫صلَى َ‬
DataBase-Management System
 DBMS is a collection of interrelated data and a set of
programs to access those data [1].
 DBMS is a collection of programs that enables users to
create and maintain a database [2].
 DBMS is a collection of components that support data
acquisition, dissemination, maintenance, retrieval,
and formatting[3].
References
1. Silberschatz, Korth, Sudarshan:
Database System Concepts 4th Edition
2.
Elmasri: Fundamentals Of Database
Systems, 5th Edition 2007.
3.
Michael V. Mannino: Database Design,
Application Development, And
Administration,3rd Edition, McGrawHill/Irwin