This course the student explores the fundamental concepts necessary for designing, using, and implementing database systems. The goal of this course is for students to become well-grounded in basic concepts necessary for understanding db and their users, DBMS concepts, architecture , the concepts of the Entity Relationship(ER) model, the data abstraction and semantic modeling concepts leading to EER data model, describe the basic relational model, its integrity constraints and update operations, and the operation of relational algebra, describe relational schema design, and it covers the normalization and functional dependency algorithm.
Textbook:Peter Rob, Carlos Coronel, Database Systems: Design, Implementation, and Management, 8th Edition. Course Technology Incorporated, 2009, ISBN 10: 1-4239-0201-7. ISBN-13: 978-1-4239-0201-0