80 likes | 101 Views
Introduction To The Course. Prepared by: Mr. Mahmoud Rafeek Alfarra. 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
E N D
Introduction To The Course Prepared by: Mr. Mahmoud Rafeek Alfarra
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: M.farra@cst.ps • Site: http://staff.cst.ps/mfarra • Office Hours: Tues. & Thur. (11:00- 12:00)
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.
Resources • Fundamental of database systems, elmasri and Navathe. • Slide of the text book. • Oracle’s slides of SQL part • Notes of lectures
Assessment • 40 % : Final Exam • 20%: Mid • 10%: practical • 10 %: Projects • 10%: Home works & Quizzes • 10%: absent and activity
Assignments: submission policy • All assignments must be send by your college mail (user@cst.ps ) • Send your assignments to m.farra@cst.ps • On Time.
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
Thank You… Question ?!