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.
|Degree||Program Objective||Course 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:
- Identify the advantages and the disadvantages of database systems vis-a-vis file processing.
- Use a graphical user interface to create/modify database structure.
- Use database query language to create/modify the user data.
- Design & develop database applications of moderate complexity from the user needs including menu-driven user interface for processing the database.