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)
CTCH 2850 - Database Management Systems
Introduction to concepts and principles of database management. Focuses primarily on relational databases and includes database design, normalization, SQL, object-oriented theory, and database administration using both a desktop database management application and an enterprise level database management system.
Requisites: C or better in CTCH 1250 and (C or better in MATH D005 or Math Placement Level 1 or higher)
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:
- Create databases using desktop database management software and enterprise level software.
- Describe when a database is an appropriate solution to a business problem.
- Design a relational database in which all tables are in Third Normal Form.
- Design simple reports and data entry screens using a desktop database management system.
- Know the attributes of a relational database including but not limited to normalization, referential integrity, and constraints.
- Know the job functions of various database professionals.
- Recognize and discuss ethical considerations in the use of databases.
- Understand basic concepts and techniques related to security and privacy of databases.
- Understand the use and protection of distributed databases.
- Write SQL statements to query databases and to create and alter tables and views.
Add to Portfolio (opens a new window)