Course

code	ES211
credit_hours	3
title	Databases
arbic title
prequisites	ES111, ES121
credit hours	3
Description/Outcomes	This course introduces the fundamental concepts necessary for the design, use, and implementation of database systems. The course emphasizes on the relational data model. The entity-relationship model is used for conceptual design and the SQL is used for physical design.
arabic Description/Outcomes
objectives	•Introduce the fundamentals of database (DB) and database management systems (DBMS).rn•Explain the database system development process.rn•Provide the students with the fundamentals of data modeling.rn•Provide in-depth knowledge of structured query language (SQL) and how it can be used to create and manipulate databases.rn•Train the student on designing and implementing relational database using MS Access software.rn
arabic objectives
ref. books	-Elmasri, R., and Navathe, S., Fundamentals of Database Systems (Pearson Education, Inc., 2004) fourth Edition (Internaltional Edition).rn-C. J. Date, An Introduction to Database Systems, seventh Edition, Addison Wesley, Massachusetts, 2000.rn
arabic ref. books
textbook	Jeffery Hoffer, Mary Prescott, and Fred McFadden. Modern Database Management, 8th Edition. ISBN: 0-013-127388-4. Prentice Hall, New Jersey. 2005rnhttp://www.prenhall.com/hoffer rn
arabic textbook
objective set	bullets
content set	bullets

Course Content

content serial	Description
1	Introduction to the database technology and its environment
2	Database development process
3	The Entity-Relationship (E-R) model
4	The Entity-Relationship (E-R) model- continued
5	The relational model
6	Transforming ER model into relational model
7	7th week Exam
8	Structured Query Language (SQL)
9	SQL – DDL, DML and DCL
10	SQL – more on Select statements
11	Normalization
12	Active database and triggers
13	Data and database administration
14	Client/server databases
15	Revision
16	Final Exam