100 likes | 223 Views
Database Management System 2009/2010. Eng. Husam Alzaq Islamic University of Gaza. Course Objectives.
E N D
Database Management System2009/2010 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. • Make-up exam is given only when special extenuating situation happens and under the discretion of the instructor • You are required to attend every class. Exception is given only if you notify the instructor with a legitimate reason in advance.
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) ]الإسراء 13 – 14[ • وَكُلَّ شَيْءٍ أَحْصَيْنَاهُ كِتَابًا ] النبأ 29 [
تقديم • فَأَمَّا مَنْ أُوتِيَ كِتَابَهُ بِيَمِينِهِ فَيَقُولُ هَاؤُمُ اقْرَءُوا كِتَابِيَهْ ]الحاقة 19 [ • وَأَمَّا مَنْ أُوتِيَ كِتَابَهُ بِشِمَالِهِ فَيَقُولُ يَا لَيْتَنِي لَمْ أُوتَ كِتَابِيَهْ ] الحاقة 25 [ • فَأَمَّا مَنْ أُوتِيَ كِتَابَهُ بِيَمِينِهِ (7) فَسَوْفَ يُحَاسَبُ حِسَابًا يَسِيرًا (8) وَيَنْقَلِبُ إِلَى أَهْلِهِ مَسْرُورًا (9) وَأَمَّا مَنْ أُوتِيَ كِتَابَهُ وَرَاءَ ظَهْرِهِ (10) فَسَوْفَ يَدْعُو ثُبُورًا (11) وَيَصْلَى سَعِيرًا (12) ] الإنشقاق 7-12 [
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 • Silberschatz, Korth, Sudarshan: Database System Concepts 4th Edition • Elmasri: Fundamentals Of Database Systems, 5th Edition 2007. • Michael V. Mannino: Database Design, Application Development, And Administration,3rd Edition, McGraw-Hill/Irwin