CPIS240

Textbook

• Ramez Elmasri, Sham Navathe, "Fundamentals of database systems", Addison-Wesley; 5 edition (2007)

Course Objectives:

This course is the first in a series of courses on designing and implementing database information systems. The objective of this course is to prepare students to become able to implement a working database system using one of the popular commercial DBMSs, such as Oracle or MS SQL Server. The course introduces students to the concepts of databases and database modeling and design. It, in particular, provides students with a three-stage methodology for designing relational database applications, namely, conceptual, logical, and physical database modeling and design. In the first stage students will build a conceptual data model that is independent of all physical considerations. They will then transform this model in the second stage into the relational database logical model. In the third stage, students will translate the logical data model into a physical design for the target DBMS. Topics include basic concepts of databases, the 3-stage modeling and design methodology, the concepts of the relational database, conceptual data modeling using ERD, from ERD to RDB and reverse engineering, data normalization, SQL:DDL, SQL: manipulation and query languages, and relational algebra for querying.

Student Assessment:

Topics Coverage Duration: