Databases 1

Course Objectives:

This course gives an introduction to the concepts of data modeling and database design principles. It focuses on the methods of building models and the entities relationships. It also focuses on understanding the databases decision models and data matching. The course covers the basic rules of structural query language. 

Course Content:

1. Introduction to Relational models and entities relationship models.
2. Association model.
3. Algebra and numeric links
4. Methods of analysis and design of databases.
5. Normalization and analysis of data structure of the relational units.
6. Storage and physical models for data storage.
7. Indexing and performance.

1. Structural query language

Skills expected from this course:

Upon finishing this course, the student should:

1. Full knowledge of the concepts of analysis and design of databases.
   2. Comprehensive knowledge of Relational algebra and how to apply the concepts in the analysis and design databases.
   3. Basic skills to extract relational relations and resolution.
   4. Knowledge of the medium in ways that building and the use of Structured Query Language.

Textbook:
Elmasri and Navathe, "Fundamentals of Database Systems", Fifth Edition 2006, Addison Wesley.
 Reference:
C.J. Date, "An Introduction to Database Systems," Eighth Edition 2003, Addison Wesley.Prentice-Hall, 2007, ISBN 0132212110