Empire State College:  State University of New York Skip navigation Home | MyESC | Site Index

DATABASE SYSTEMS (SMT-273984)

Online Learning Home > Online Learning Catalog > Science Math & Technology >

Course 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.


This online course is offered through Online Learning. You can take this as an individual course or as part of an online degree program, with term starts in March, May, September, November and January. View current term offerings and all online courses. Click here to register for online courses.

spacing 
bar---------------------------------------------------------------
Other Areas: The Arts | Business, Management & Economics | Community & Human Services | Communications, Humanities & Cultural Studies | Educational Studies | Historical Studies | Human Development | Labor Studies | Nursing | Science, Math & Technology | Social Science
spacing 
bar---------------------------------------------------------------
Upper Level
Credits: 4
Term(s) Offered (Subject to Change) : Spring 1. Spring 2. Summer. Fall 1. Fall 2.

For Books and Materials List Go to the Online Bookstore