CDL COURSE ENTRY FORM


Author: Bernice Kennedy/SUNY
Last modified by: Laura Wait/SUNY
Composed: 09/24/2002 09:40 AM
Curriculum Committee Approval Date:
Modified: 04/13/2016
-----------------------------------------------------------------
Course Number: (prefix) SMT (number) 273984 ESC 2.0 Course number: INFS-3010 INFS-3010Database Systems

Name: Database Systems
Datatel Title: (30char) Database Systems

Area Coordinator: Diane Shichtman Department Code: 10IS Team: SMT

Liberal Study? NO Level: UPPER Credits: 4 Prerequisite? YES
General Education Course? NO GenEd Approval Term/Year:

GenEd Area 1: Fully or Partially:
GenEd Area 2: Fully or Partially:



Pre-registration Information?
Course will be offered (for online course descriptions, proposed offerings for by term views and web views)
Spring 1, Spring 2, Summer, Fall 1, Fall 2		Course will be offered (for final term listings, online registration, online bookordering, web views)
Spring 1, Spring 2, Summer, Fall 1, Fall 2
First Term Offered: (Required Format: YearTerm - i.e., 2005SP)
Last Term Offered in Print Version:
Title Changes:
AC Changes:
BK Number: 25

Description: Data modeling and the implementation of data models will be a major component of the course, with students studying normalization and formal modeling conventions. The model will be implemented using SQL. Metadata is also covered as well as some aspects of database administration. Larger picture topics such as ethics and implementation will be addressed as well. Students will use Visio modeling software and an Oracle database (see Note). A group modeling project will allow students to develop their ability to work as a team, a common practice in the industry. Students will complete an individual project involving the design and implementation of a database.

Note: Students in this course are required to install and use Microsoft Visio on their personal computer. The Oracle DBMS is designed for PCs. It is possible to run it on a Mac using a virtual machine (it is highly recommended that Mac users have experience with the multi-OS virtual environment before signing up for this course; no support for setting this up and installing Oracle is available). Alternately, students may access Oracle DBMS online through a college virtual desktop system.

Prerequisites: A basic understanding of databases. Knowledge of systems analysis and design is helpful but not required.

Generic:



Major Course Area
Science Math & Technology		Minor Course Area
Computers and Information Systems		SLN Disciplines
Computer Information Systems
Additional Course Requirements
WWW Computer Conference		 Undergrad Certificate Association:


2




Required Booknote:

Optional Booknote:


Archive Course:

genedcode for dpplanner:

genedfull area for dpplanner: