• Computer Science
• Overview
• Degrees & Options
• Placement & Careers
• Accreditation
• Faculty & Staff
• Resources
• Courses
• Industry Advisory Board
• Program Assessment
• Student ACM Club

• Tech Links
• Future Students
• Current Students
• Alumni & Giving
• Career Services

C.S. 2656

Database Management

3 Cr. (Hrs.:3Lec.)

 

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)