CSC (0145) 565 - Data Base Management Systems

Credits: 3.00

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.

Prerequisite 1: CSC 530
Free Note: Open only to Students in Computer Science and the MS in Mathematics

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.