This course continues with database concepts introduced in COMP 3610: Database Systems. Students begin with a review of database design and implementation principles, and progress to discussions about the relational database model, designing for optimization, and normal forms. Topics include domain/ key normal form; relational database strategies for Database Manipulation Languages (DMLs); database administration and multi-user database issues (control, security, optimization and related); and distributed database systems with an emphasis on Client/Server, data warehousing, object-oriented database systems, and web-based database issues. Prerequisite: COMP 3610 (min. grade of C) or COMP 3611 (min. grade of C)
This course continues with database concepts introduced in COMP 3610: Database Systems. Students begin with a review of database design and implementation principles, and progress to discussions about the relational database model, designing for optimization, and normal forms. Topics include domain/ key normal form; relational database strategies for Database Manipulation Languages (DMLs); database administration and multi-user database issues (control, security, optimization and related); and distributed database systems with an emphasis on Client/Server, data warehousing, object-oriented database systems, and web-based database issues. Prerequisite: COMP 3610 (min. grade of C) or COMP 3611 (min. grade of C)