Mar 29, 2024  
OHIO University Graduate Catalog 2020-21 
    
OHIO University Graduate Catalog 2020-21 [Archived Catalog]

Add to Portfolio (opens a new window)

CS 5620 - 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:
Credit Hours: 3
Repeat/Retake Information: May not be retaken.
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)