Course Descriptions & Student Learning Outcomes

CENT 280 - Database Systems I (3)

  • Prerequisite: CENT/ICS 110 and CENT 132

CENT 280 is a prerequisite for the CENT APC Program. CENT and ICS majors only. This course will introduce the student to the field of database systems. Students will learn concepts, principles, and types of database models including: fl at file, relational, object relational and object-oriented. Extensive coverage of modeling and design of common database systems like relational databases will be the major focus of this course. Students will learn concepts and principles of database query languages, such as structured query language (SQL).

2 hrs. lect.; 3 hrs. lab. per week

Student Learning Outcomes

Upon successful completion of CENT 280, the student will be able to:

  • Explain the concepts of different database models.
  • Identify and explain the differences between different database models.
  • Define the steps required in the analysis for the development of a new database.
  • Design and implement relational databases involving at least three underlying tables.
  • Design and implement SQL queries for both Data Manipulation and Data Definition tasks.
  • Create an Entity-Relationship diagram based upon a fixed set of requirements.
  • Explain the purposes of and differences between conceptual, logical and physical database design.

Back to Main List