Jun 28, 2024
OHIO University Undergraduate Catalog 2023-2024
OHIO University Undergraduate Catalog 2023-2024
[Archived Catalog]
Add to Portfolio (opens a new window)
Add to Portfolio (opens a new window)
CS 4620 - Database Systems
Introduces fundamental concepts in data modeling and relational database systems. Begins with entity-relationship (ER) modeling technique as a tool for conceptual database design. Relational data model and relational algebra are introduced next, followed by the SQL query language for relational databases. Functional dependencies, normalization, and relational database design algorithms are then discussed.
Requisites: CS 3610
Credit Hours: 3
Repeat/Retake Information: May be retaken two times excluding withdrawals, but only last course taken counts.
Lecture/Lab Hours: 3.0 lecture
Grades: Eligible Grades: A-F,WP,WF,WN,FN,AU,I
Learning Outcomes:
- Students will be able to design and implement a database based on models.
- Students will be able to design an entity-relationship diagram to model an enterprise.
- Students will be able to use SQL in a host programming language to implement transactions against a database.
- Students will be able to express a database query as a relational algebra expression.
- Students will be able to express an interactive database query in SQL.
Add to Portfolio (opens a new window)