COMP 3673 is an intensive course intended for applicants to the Bachelor of Technology degree in Computer Systems. The primary focus of this course is systems analysis, design and implementation in a relational database environment. The course introduces the students to concepts and techniques used in project development lifecycles which include: (1) gathering user requirements, (2) ascertaining feasibility and practicality of projects, planning, and (3) managing and monitoring projects. These will serve as foundation to more in depth understanding of database design, modeling, implementation and maintenance. Topics to be covered will include: 1)Basic Relational Database Design concepts (Use case and use case considerations, Relational Schemas, Relational algebra, Entity (ER) and Enhanced Entity Relationship (EER) modeling, & Normalization); 2)Structured Query Language (Data Definition Language (DDL), & Data Manipulation Language (DML)); and 3)Database Maintenance (Use of views, Database security, & Concurrency Control and Transaction Management). Students will be required to use Relational Database Management Systems, such as MS SQL Server or MySQL, to complete the assignments and project.
Upon successful completion, the student will be able to:
Effective as of Fall 2003
COMP 3673 is offered as a part of the following programs:
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 3673 - Computer Systems Technology Foundations 3? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.