-
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:
-
-
Phone Number:
-
(413) 782-3111
-
Regional Accreditation:
-
New England Association of Schools and Colleges
-
Calendar System:
-
Semester
Detail Course Description Information on CollegeTransfer.Net
Copyright 2006 - 2025 AcademyOne, Inc.