Transcript Slide 1

Introduction To
The Course
Prepared by:
Mr. Mahmoud Rafeek Alfarra
Copyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-Wesley
Lecturer of course
 Mahmoud Rafeek Alfarra
 General Secondary School Certificate, Science division, Khan Younis, Gaza,
Palestine, 1999
 BSc Computer Science, The Islamic University of Gaza, Gaza, Palestine ,
2004
 MSc Computer Science, Pattern Recognition, AAST, Alexandria, Egypt.
Thesis title “Document Clustering using Graph-based Growing Hierarchal
Self-Organizing Map (G-GHSOM)”,2008
 E-mail: [email protected]
 Site: http://staff.cst.ps/mfarra
 Office Hours: Tues. & Thur. (11:00- 12:00)
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Course objectives
 Be able to understand, what is the difference
between database & file based system.
 Be able to understand the database concepts.
 Be able to understand the objective of DBMS
and its uses.
 Be able to understand the normalization
 Be able to build Databases and manage it using
Oracle.
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Resources
 Fundamental of database systems, elmasri and
Navathe.
 Slide of the text book.
 Oracle’s slides of SQL part
 Notes of lectures
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Assessment






40 % : Final Exam
20%: Mid
10%: practical
10 %: Projects
10%: Home works & Quizzes
10%: absent and activity
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Assignments: submission policy
 All assignments must be send by your college
mail ([email protected] )
 Send your assignments to [email protected]
 On Time.
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Course outlines
 File based system
 Databases and Database Users
 Database System Concepts and Architecture
 The Relational Data Model and Relational Database
Constraints
 Basic SQL in Oracle
 Triggers & Views
 The Relational Algebra and Relational Calculus
 Data Modeling Using the ER Model
 Relational Mapping
Copyright © 2011 Ramez Elmasri and Shamkant Navathe
Thank You…
Question ?!
Copyright © 2011 Ramez Elmasri and Shamkant Navathe