Course Information: Database Systems

Computer Science Department
Course Competency Plan
COURSE: CpSc 323 Database Systems

Course Description: Database Systems is a study of relational database concepts as applied to comprehensive information systems. These concepts include data design; modeling; normalization; the use of Structured Query Language (SQL) to define, manipulate and test the database; programmatic access to a database; and practical issues faced by database developers. Prerequisites: CpSc 130, or 140, or 210. (3 credits)

Course Outcomes: This course and its outcomes support the Information Systems and Information Technology Learning Outcomes of Problem Solving and Critical Thinking (PS&CT), Communication and Interpersonal Skills (C&IS), and Ethical and Professional Responsibilities (E&PR). These Information Systems and Information Technology Learning Outcomes are tied directly to the University Wide Outcome of Critical Thinking and Problem Solving, Communication, and Values and Ethics.

DegreeProgram ObjectiveCourse Objective
IS I.a. Examine and analyze alternative solutions to a problem 1. Use a database query language for data definition, data manipulation, and data analysis.
IT I.d. Implement IT solutions that consist of system and application software written in various programming languages
IS II.d. Work cooperatively in teams and with others 2. Use modern modeling techniques and design principles to design & develop databases and database applications of moderate complexity
IS III.a. Plan for and ensure the security, integrity, and privacy of data and the confidentiality of the end user 3. Identify the issues, the concerns and the backup and recovery techniques prevalent in multi-user database processing.
IT III.d. Plan for and ensure the security, privacy, and integrity of data
IS III.e. Recognize the need for continuing professional development 4. Compare and contrast the techniques used in the past and present for data and information processing and how data and information processing may change in the future.
IT III.e. Recognize the need for continuing professional development

Additional Course Objectives include:
The student will be able to:

  1. Identify the advantages and the disadvantages of database systems vis-a-vis file processing.
  2. Use a graphical user interface to create/modify database structure.
  3. Use database query language to create/modify the user data.
  4. Design & develop database applications of moderate complexity from the user needs including menu-driven user interface for processing the database.