A practical approach to analysis, design, and implementation of database systems. This course covers topics such as: conceptual, logical and physical data models; relational database and relational algebra; building and mapping entity relationship diagrams (ERDs); normalization; basic and advanced Structured Query Language (SQL) for data retrieval and manipulation; functions, triggers, and procedures; transactions and concurrency control; security, backup, and recovery procedures.
Prerequisites: CPSC 130 or CPSC 146 (3 credits)
This course and its outcomes support the Computing Learning Outcomes of Problem Solving and Critical Thinking (PS&CT), Communication and Interpersonal Skills (C&IS), and Ethical and Professional Responsibilities (E&PR). These Computing Outcomes are tied directly to the University Wide Outcomes of Critical Thinking, Digital Citizenship, and Whole Personality.
| Learning Outcomes | Assessed Course Objectives |
|---|---|
| PS & CT d. Implement computing solutions that consist of system and application software written in various programming languages | 1. Use a database query language for data definition, data manipulation, and data analysis. |
| PS & CT e. Create efficient, user-friendly applications appropriate to the computing problems | |
| PS & CT b. Integrate design and implementation principles to develop effective applications | 2. Use modern modeling techniques and design principles to design & develop databases and database applications of moderate complexity |
| E & PR d. Plan for and ensure the security, privacy, and integrity of data | 3. Identify the issues, the concerns and the backup and recovery techniques prevalent in multi-user database processing. |
| E & PR 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. |
Additional Course Objectives include:
The student will be able to: