IT 300 - Database Management Systems

Institution:

Western New England University

Subject:

Description:

Prerequisite: BIS 210/IT 240. This course is a study of the concepts, theory, design techniques, and information retrieval methods, emphasizing the relational database model and structured query language (SQL). It incorporates database design and application development CASE (computer aided software engineering) tools, with emphasis on the entity-relational (E-R) model and unified modeling language (UML). Topics include data modeling and organization, database architecture, SQL, and database connectivity technologies. Design and implementation projects are required. The course contributes to fulfilling BIS-major objectives 1, 4, and 5. Specific learning objectives include: (1) understanding managerial aspects of data and information; (2) designing relational data models with emphasis on data normalization; (3) using query techniques using SQL and query-by example (QBE); (4) understanding database architecture and implementation methods; (5) maintaining data integrity, security, and privacy; (6) understanding program-data independence in applications; (7) an introduction to object-oriented database solutions and emerging database technologies; and (8) understanding transactions and their role in database recovery. The objectives are assessed based on projects, tests and class participation. This course is equivalent to CS 364. 3 cr. Laboratory fee $50.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.wne.edu

Phone Number:

(413) 782-3111

Regional Accreditation:

New England Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.