COMP 230

This course covers the theoretical foundations that are necessary to design and implement a database, and to use database management systems effectively. The database approach is introduced and major models are reviewed. Relational models are considered in more detail. Data modeling techniques are used as a tool for design. Students will study data manipulation languages such as relational algebra and SQL. Normalization and practical design considerations are covered. Note: Students with credit for CIS 230 cannot take this course for further credit. -- Prerequisite -- COMP 155 or (admission to the Data Analysis Post-degree certificate program and one of the following: STAT 106 [formerly MATH 106] or MATH 270/STAT 270). -- Corequisite -- None. -- Pre or Corequisite -- None.