Studies concepts and applications in database management including the relational model, relational algebra, Structural Query Language (SQL), and application development. Prerequisite: C.S. 2116, C.S. 3126, or C.S. 2136 and C.S. 2146. (2nd)

A reflection paper is required for this course.

Expectations:

E1. Students are proficient in a programming language and have learned basic error-handling, testing and debugging techniques. (C.S. 2116, C.S.2136, C.S. 2146 and C.S.3126)

Course Outcomes:

R1. Students know the history, architecture, and capabilities of database management products. (CS/SE8)

R2. Students are aware of problems relating to information privacy, integrity, security, and preservation, understand the concept of information stewardship, and  wrote a paper on information stewardship and computer technology. (CS/SE1, CS/SE 5, CS/SE12)

R3. Students understand the purpose of data modeling and are able to model the logical data in a database. (CS/SE3, CS/SE4, CS/SE11, CS/SE15)

R4. Students understand the relational model and its significance and created a relational schema that incorporates key, entity integrity, and referential integrity constraints. (CS/SE15)

R5. Students understand the concepts of normalization, including the definition of Boyce-Codd Normal Form (BCNF), decomposed tables into BCNF, and determined when normalization should be applied. (CS/SE3)

R6. Students evaluated query processing strategies and selected the optimal strategy. (CS/SE3)

R7. Students understand the purpose and concepts of transactions. (CS6, SE6)

R8. Students are proficient with at least one database management product. (CS6, SE6, CS/SE15)

R9. Students can write basic Structured Query Language (SQL) data definition, data manipulation and data query statements. (CS6, SE6, CS/SE15)

R10. Students worked in teams to develop a database application for external clients, maintained a portfolio of the work and participated in a presentation of the database application to the class and to the clients. (CS/SE2, CS/SE4, CS/SE7, CS/SE10, CS/SE16)