CSCI2050 — Database Management Systems
CSCI 2050 - Database Management Systems CSCI 2050 - Database Management Systems Hours/Week: Lecture 4 Lab None Course Description: The course covers the concepts and techniques for designing, creating, and managing databases. The relational model is emphasized, along with its associated design techniques, such as E-R Model, normalization, and decomposition. Structured Query Language (SQL) is covered in depth and used to implement, query, and modify databases. Topics include query optimization, transaction management, backup, security, and privacy, as well as additional architectures such as distributed, object-oriented, and client/server. Additional architectures such as distributed, object-oriented database, and client/server are explained. Course activities include the creation of front-end database applications that use modern interface design, using an industry-current database such as MySQL. An industry current database such as MySQL will be used in the course. This course requires thorough knowledge of an object-oriented programming language such as Java or C++ . MnTC Goals None apply the appropriate design process and techniques (such as normalization) to create an optimal database use SQL to create, modify, and query relational databases. demonstrate principles for effective transaction management, concurrency control, and recovery. describe techniques for creating data warehouses and mining them for information. compare different database architectures including rela
Prerequisites: CSCI1081, CSCI1082