Course Search
Courses may be offered in one of the following modalities:
- Traditional in-person courses (0–29 percent of coursework is delivered online, the majority being offered in person.)
- Hybrid/blended courses (30–79 percent of coursework is delivered online.)
- Online courses (100 percent of coursework is delivered online, either synchronously on a designated day and time or asynchronously as a deadline-driven course.)
- Hyflex (Students will be assigned to attend in-person or live streamed sessions as a reduced-size cohort on a rotating basis; live sessions are also recorded, offering students the option to participate synchronously or view asynchronously as needed.)
If you are enrolled in courses delivered in traditional or hybrid modalities, you will be expected to attend face-to-face instruction as scheduled.
CSC 565: Database Management Systems
3 credits
Students will design and implement databases. Students will learn about a variety of database paradigms, including relational, document and XML databases and study database internals such as architecture, transaction management and logging, in distributed and non-distributed environments.
Learning Goals
Students will:1. Students will: Refresh their knowledge of relational algebra and relational calculus, and will be able to apply that knowledge to relational databases. This will be assessed by Quiz 1 and the final exam. 2. Design and implement relational databases, object-relational databases, and document databases. This will be assessed by Quiz 1 and the final exam.3. Understand, explain and apply the ramifications of horizontally scaled (distributed) databases, and be familiar with common problems and solutions that are unique to the distributed environment. This will be assessed by Quiz 3 and the final exam.4. Understand, explain and have meaningful discussion about database internals, such as system architecture, transaction processing, query processing and indexing. This will be assessed by the final exam.
*The learning goals displayed here are those for one section of this
course as offered in a recent semester, and are provided for the purpose of
information only. The exact learning goals for each course section in a
specific semester will be stated on the syllabus distributed at the start
of the semester, and may differ in wording and emphasis from those shown
here.