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
|