CPIT 240

Course Name

Course Code

Databases I

CPIT 240

Prerequisite

Credit Units

CPCS 204

Theory

Practice

Training

Credit

3

1

0

3

Course Description

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 Contents

§ Introduction to Relational models and entities relationship models.

§ Association model.

§ Algebra and numeric links

§ Methods of analysis and design of databases.

§ Normalization and analysis of data structure of the relational units.

§ Storage and physical models for data storage.

§ Indexing and performance.

§ Structural query language

Course Outcomes

Upon finishing this course, the student should:

§ Know the concepts of databases analysis and design.

§ Understand association algebra and how to apply the concepts in the databases analysis and design.

§ Extract relationships and apply normalization.

§ Use the structural query language.

References

• Elmasri and Navathe, "Fundamentals of Database Systems", Fifth Edition 2006, Addison Wesley.

• C.J. Date, “An Introduction to Database Systems,” Eighth Edition 2003, Addison Wesley. Prentice-Hall, 2007, ISBN 0132212110.

• J. Harrington, "Relational Database Design Clearly Explained", 2nd Ed., Morgan Kaufmann, 2002, ISBN 1558608206.

• R. Toledo, P. K. Cushman, "Schaum's Outline of Fundamentals of Relational Databases", McGraw Hill, 2000, ISBN 007136188X.