Database Management

Overview

Program Description

The Associate in Applied Science Degree in Database Management is designed for persons interested in database programming, design and management.  Database management duties include some or all of the following: installation and configuration of database software, database programming and design, user-training, application software maintenance, performance tuning, system evaluation, and interaction with users and management requiring sound verbal and written skills.

Career Opportunities

Job opportunities span small businesses, large organizations, and international settings in both public and private sectors. See Information Technology » Database Management for more career and employment information.

Program Outcomes

At the completion of the Database Management Program, the successful student will be able to:

  • Demonstrate the ability to access, evaluate, apply and convey technical information with their peers
  • Demonstrate the ability to effectively plan, create, and debug effective solutions to problems through the programs they write
  • Evaluate quantitative and symbolic data in translating user and organization needs into usable software and data solutions
  • Recognize ethical issues and evaluate consequences
  • Collaborate with diverse groups across a variety of knowledge and skill levels and perspectives

In addition, students who complete the program will demonstrate the following skills standards specific to Database Management:

  • Effectively plan and implement database systems
  • Apply database and programming concepts to various situations
  • Use industry standard database systems and techniques

Additional Program Information

Educational Plan

Associate in Applied Science Degree

91-93 credits

Program Requirement

Students entering the program are required to have successfully completed MATH 097 or the equivalent.
Students must also successfully complete one of the following options:

  • The Accuplacer CSP Basic exam with a composite score of 75% or higher
  • OFTEC 101 and OFTEC 108

An AAS will be awarded upon successful completion of all core and general education requirements.

Program Information

Admission: Students are accepted into the Database Management program every quarter.
Length of Program: Full-time students typically complete this program in seven quarters, after basic skills and/or pre-college are complete.

1st Quarter Fall


CIS 145 Introduction to Access 5 Credits Search Schedule
An introduction to relational database concepts and applications using Microsoft Access. Database concepts and practices are introduced and discussed using business-related examples. Includes building tables, forms, queries, and reports. CIS 101, 108 or CIS 123 recommended, or comparable competencies. Prerequisite: CIS 141 or MATH 097 with a "C" or better.
CIS 160 Introduction to Programming 5 Credits Search Schedule
Introduces programming structures, concepts, techniques and terminology using the Visual Studio development environment and the C# programming language. Prerequisite: MATH 097 and CIS 101 and CIS 108. A composite score of at least 75% on the Accuplacer Computer Skills Placement (CSP) Basic exam can serve in lieu of CIS 101 and CIS 108.
Distribution: AA, AS, DTA
CIS 168 Programming Logic 5 Credits Search Schedule
Introduces the mathematics of computer programming. Covers symbolic logic, set theory, truth tables, number systems, algorithm design, and flowcharts. Prerequisite: MATH 097.
Distribution: AA, AS, DTA
Recommended Elective
MATH&146 Introduction to Statistics 5 Credits Search Schedule
Covers basic probability, descriptive and inferential statistics. Prerequisite: Appropriate placement or a "C" or better in MATH 097 or higher.
Distribution: AA, AS, DTA, NATURAL SCIENCE, QUANTITATIVE, AA-AAS-T-QUANTITATIVE, AA-AAS-T-NATURAL SCIENCE

2nd Quarter Winter


CIS 182 Structured Query Language (SQL) 5 Credits Search Schedule
An introductory Structured Query Language (SQL) course which emphasizes techniques for writing efficient standard SQL. Students practice with commercial implementation of SQL. A thorough overview of relational data base concepts, including database design, concepts and practices, establishes a basis for pursuing SQL. Fundamental knowledge of data base concepts is required. Prerequisite: CIS 145 and CIS 160 or instructor's permission.
CIS 166 Programming Business Objects 5 Credits Search Schedule
Concepts and techniques of object-oriented programming. Design and coding of structures and classes to validate and store business data. Creation and management of arrays, lists and collections to work with data sets of different sizes and complexity. Use of a variety of user forms and controls to interact with user. Prerequisite: CIS 160 and CIS 168.
CIS 184 Creating Web Pages 5 Credits Search Schedule
Creating web pages with HTML 5 (Hypertext Mark-Up Language version 5) and CSS (Cascading Style Sheets). Emphasis on HTML tags for text, images, links, lists, simple layouts, complex layouts, tables, style, internal style sheets, and external style sheets. Also an introduction to XHTML. CIS 108, CIS 110, and CIS 123 recommended. Prerequisite: MATH 097.

3rd Quarter Spring


CIS 282 SQL Projects 5 Credits Search Schedule
Developing relational database applications using Structured Query Language in a client-server environment using Microsoft SQL Server. Topics include database design and implementation, defining and using stored procedures, indices, rules, and database security and administration. Measures to improve performance including transaction processing and database optimization will be explored. Prerequisite: CIS 182 and CIS 166 or instructor's permission.
CIS 266 Developing Database Applications 5 Credits Search Schedule
Developing business applications using relational databases and object-oriented programming. Emphasis is placed on the planning process, database design and implementation, and understanding customers' business rules. Practical application of common tools focus on database manipulation using both data-bound controls and programmatic connections. The process of turning data into useful information will be explored using Structured Query Language and interface design. The database techniques are demonstrated with Access and/or SQL Server, and apply to other database products. Prerequisite: CIS 166 and CIS 182 or instructor's permission.
CNA 120 Command Line Interface 5 Credits Search Schedule
Introduces the use of the Windows command line and PowerShell interfaces to manage and manipulate Windows Operating systems. Prerequisite: Eligible for MATH 090 and ENGL 090.
Recommended Elective
CIS 185 JavaScript 5 Credits Search Schedule
Create, design, write, test, debug and document programs to run on client machines using JavaScript. Use scripting for pop-up windows, validating forms, generating dynamic information, cookies, browser detection/redirect, and interactive menus. Use of proper programming techniques. Prerequisite: CIS 184 and CIS 166.

4th Quarter Fall


CIS 284 Web Application Development 5 Credits Search Schedule
Create interactive web pages using ASP.NET server-side programming. Integrate web programming with SQL databases and address security issues. Prerequisite: CIS 184, (CIS 166 or CIS 185), CIS 145, CIS 182 recommended.
CIS 169 Requirements Analysis 5 Credits Search Schedule
Introduces planning, analysis, and design of software, with an emphasis on development methodologies, design process, and communication techniques. Prerequisite: CIS 168 AND CIS 145 AND (CIS 166 OR CS 142 or instructor's permission).
CNA 122 Microsoft Server 5 Credits Search Schedule
A technical introduction to the Microsoft Windows server operating system and Microsoft Client-Server networks. Includes implementation of a core Windows Server Infrastructure into an existing enterprise environment by installing and configuring Active Directory, networking and other core services. Prerequisite: CNA 120 or instructor's permission.
Recommended Elective
CIS 189 XML 5 Credits Search Schedule
Understand and apply XML (extensible markup language) as a component in computer programming. Includes learning proper structure for XML documents, document type definition (DTD), and XML schemas. Manipulation of the document object model (DOM) using JavaScript is emphasized, and creating alternate output using extensible stylesheets (XSL/XSLT) will be explored. Students will gain knowledge of XML through hands-on experience. Prerequisite: CIS 184, CIS 185.

5th Quarter Winter


CIS 245 Developing Applications in Access 5 Credits Search Schedule
Provides an introduction to application development using Microsoft Access. Emphasis is on understanding customers' needs and translating data into useful information. Students will work with Visual Basic for Applications (VBA) and ActiveX Data Objects (ADO) to create a responsive user experience using queries, forms and reports. Prerequisite: CIS 182.
BUS& 101 Introduction to Business 5 Credits Search Schedule
Provides an overview of current concepts and structures of American business. A general look at the functions of business: forms of ownership, management, personnel, marketing, production, finance, and the economic picture. Prerequisite: Eligible for ENGL& 101.
Distribution: AA, AS, DTA, SOCIAL SCIENCE, NURSING SOCIAL SCIENCE, AA-AAS-T-SOCIAL SCIENCE

Choose courses from the General Education Requirement list
Recommended Elective
CIS 286 Java for Business Applications 5 Credits Search Schedule
Introduces object-oriented programming with Java. Prerequisite: CIS 166.
CNA 210 Introduction to Network Security 5 Credits Search Schedule
Introduction to securing network resources. Evaluation of network security from a global perspective. Incorporates media security, network vulnerabilities and authentication protocols. Basic cryptography, operating system security and Internet security practices. Preparation for the CompTIA Security+ Exam. Prerequisite: CNA 101 and either CNA 121 or CNA 122.
CS 142 Object-Oriented Programming I 5 Credits Search Schedule
Introduces the design and implementation of computer programs, including basic object-oriented programming with functions, classes, and objects. Prerequisite: "C" or better in MATH 097 or higher.
Distribution: AA, AS, DTA

6th Quarter Spring

BUS 289 Integrated Business Applications 5 Credits Search Schedule
A capstone course that integrates accounting, data processing and business concepts to create solutions to complex business problems. Teambuilding, ethics and presentation techniques are considered. Ability to use a spreadsheet program is required. NOTE: BUS 289 should be taken by business and accounting students who are within two quarters of graduation. Prerequisite: Completion of two of the following with "C" or better: BUS& 101 or BUS 101, ACCT& 201 or ACCT 201, ACCT& 203 or ACCT 203.

Choose courses from the General Education Requirements list
 

Electives 

MATH&146 Introduction to Statistics 5 Credits Search Schedule
Covers basic probability, descriptive and inferential statistics. Prerequisite: Appropriate placement or a "C" or better in MATH 097 or higher.
Distribution: AA, AS, DTA, NATURAL SCIENCE, QUANTITATIVE, AA-AAS-T-QUANTITATIVE, AA-AAS-T-NATURAL SCIENCE
CS 142 Object-Oriented Programming I 5 Credits Search Schedule
Introduces the design and implementation of computer programs, including basic object-oriented programming with functions, classes, and objects. Prerequisite: "C" or better in MATH 097 or higher.
Distribution: AA, AS, DTA
CIS 185 JavaScript 5 Credits Search Schedule
Create, design, write, test, debug and document programs to run on client machines using JavaScript. Use scripting for pop-up windows, validating forms, generating dynamic information, cookies, browser detection/redirect, and interactive menus. Use of proper programming techniques. Prerequisite: CIS 184 and CIS 166.
CIS 189 XML 5 Credits Search Schedule
Understand and apply XML (extensible markup language) as a component in computer programming. Includes learning proper structure for XML documents, document type definition (DTD), and XML schemas. Manipulation of the document object model (DOM) using JavaScript is emphasized, and creating alternate output using extensible stylesheets (XSL/XSLT) will be explored. Students will gain knowledge of XML through hands-on experience. Prerequisite: CIS 184, CIS 185.
CIS 269 Software Maintenance 5 Credits Search Schedule
Responsibilities and techniques of the maintenance programmer. Emphasis on use of version control software, teamwork, and software testing. A significant, existing software project is used as a case study. Appropriate code commenting and documentation is discussed. Unit tests are created and applied. Understand project requirements to estimate resource needs and identify security issues. Prerequisite: CIS 284 and CIS 169 or instructor's permission.
CIS 286 Java for Business Applications 5 Credits Search Schedule
Introduces object-oriented programming with Java. Prerequisite: CIS 166.
CNA 210 Introduction to Network Security 5 Credits Search Schedule
Introduction to securing network resources. Evaluation of network security from a global perspective. Incorporates media security, network vulnerabilities and authentication protocols. Basic cryptography, operating system security and Internet security practices. Preparation for the CompTIA Security+ Exam. Prerequisite: CNA 101 and either CNA 121 or CNA 122.

General Education Requirements
Communication 

ENGL&101 English Composition I 5 Credits Search Schedule
Develops writing skills by focusing on strategies and techniques writers use to convey ideas, evaluate information, make a point, and participate in multiple discourse communities. Emphasizes both the process and the product of writing. This course was formerly known as WRIT 101, College Writing I. Prerequisite: Appropriate placement test scores OR appropriate completion of ENGL 095, ENGL 095X, or ENGL 098 OR concurrent enrollment in ENGL 110 with instructor's permission.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, GER-CIS, AA-AAS-T-COMMUNICATION, AAS-COMMUNICATION: Reading/Writing, AAS-READING-WRITING

Additional Communication Choose one of the following:
OFTEC260 Business Communication 5 Credits Search Schedule
Principles of effective communication in business emphasizing the human relations factor, through correspondence, report writing, and an oral presentation. OFTEC 160 (formerly CIS 106) recommended. This course was formerly known as CIS 210. Prerequisite: Completion of ENGL& 101.
CMST&101 Introduction to Communication 5 Credits Search Schedule
Investigates the theory and practice of intrapersonal, interpersonal, small group, organizational, intercultural, and public speech communication. Human communication processes and barriers are explored. Development of communication skills useful for workplace, family, friendships, educational, and community contexts. Prerequisite: None.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, AAS-SPEAKING-LISTENING, AA-AAS-T-COMMUNICATION
CMST 105 Introduction to Online Journalism 5 Credits Search Schedule
Introduction to two forms of mass media writing: writing to inform (print and online) and writing to persuade (public relations, advertising and business). Newsgathering and news writing techniques including interviews, news judgment, story development, use of basic resource material, writing style and editing. Development of skills in audio and visual storytelling. Explores relationship between news, newsmakers, citizen journalists, social media networking, and ethics. Computer/word processing skills are essential to being successful in this course. This course was formerly known as MCOM 101, Introduction to Journalism. Prerequisite: Eligible for ENGL& 101 (formerly WRIT 101).
Distribution: AA, AAS, AS, DTA, HUMANITIES, NURSING HUMANITIES, AAS-SPEAKING-LISTENING, AA-AAS-T-COMMUNICATION, AA-AAS-T-HUMANITIES
CMST&220 Public Speaking 5 Credits Search Schedule
Introduction to oral communication theory and to public speaking/listening practice as applied to a variety of settings and audiences. Students will learn to verbally inform and/or demonstrate and persuade an audience using a variety of speech types. Covers speech preparation, critical listening and thinking, and individual and group presentation techniques. This course was formerly known as SPCH 101, Introduction to Public Speaking. Prerequisite: None.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, AAS-SPEAKING-LISTENING, AA-AAS-T-COMMUNICATION
CMST&230 Small Group Communication 5 Credits Search Schedule
Studies communication in small groups to help students understand group processes and to be effective participants in problem-solving groups at home, in the community, and at work. Develops skills in decision-making, creative and critical listening and thinking, interpersonal and intercultural communication, conflict management, and leadership as applied to small groups. This course was formerly known as SPCH 115. Prerequisite: None.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, AAS-SPEAKING-LISTENING, AAS-HUMAN RELATIONS, GER-CIS, AA-AAS-T-COMMUNICATION
CMST 260 Communication and Conflict 5 Credits Search Schedule
Investigates interpersonal communication conflict theory and participates in class activities to build skills. Study of communication processes and strategies applicable to conflict in family, friend, school, work, and community relationships. Examines how communication patterns and behaviors contribute to conflict, escalation, destructive and constructive management approaches, resolution, and reconciliation. Prerequisite: Eligible for ENGL& 101.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, AAS-SPEAKING-LISTENING, AA-AAS-T-COMMUNICATION
ENGL&235 Technical Writing 5 Credits Search Schedule
The study of effective technical and professional communication. Development of skills in proposal writing, technical report writing, business correspondence, oral presentations, online communication, group problem solving, professional portfolio development and basic research techniques. This course was formerly known as TCOM 106, Technical and Professional Communication. Prerequisite: ENGL& 101 (formerly WRIT 101). Word processing skills recommended.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, AAS-SPEAKING-LISTENING, GER-CIS, AA-AAS-T-COMMUNICATION

Human Relations Choose one of the following:
BUS 260 Principles of Management: Diversity 5 Credits Search Schedule
Analysis of the functions of management, including planning, problem solving, decision making, organizing, leading, directing, motivating and controlling. Special emphasis will be on current management issues including the importance of valuing diversity. Students will be expected to employ critical thinking skills to analyze and address typical workplace challenges. The case method, role playing, practical applications and exercises will be used. Prerequisite: Eligible for ENGL& 101. Completion of ENGL& 101 (formerly WRIT 101) is strongly recommended.
Distribution: AA, AAS, AS, DTA, DIVERSITY, AAS-HUMAN RELATIONS
OFTEC109 Human Dimensions in the Office: Diversity 3 Credits Search Schedule
Theory behind effective interaction on the job. Includes problem solving, conflict resolution, communication styles and climates, motivation, effective group participation, and adapting to a changing work environment, which includes understanding workforce/workplace diversity. This course was formerly known as CIS 109. Prerequisite: None.
CMST&210 Interpersonal Communication: Diversity 5 Credits Search Schedule
Investigation into the theory and practice of interpersonal communication. An experiential approach is used as students participate in a variety of class activities designed to apply and build skills through the speech communication process. Examines how a diversity of communication styles can affect formation and maintenance of school, co-worker, family, friendship and romantic relationships. This course was formerly known as SPCH 103. Prerequisite: None.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, DIVERSITY, AAS-SPEAKING-LISTENING, AAS-HUMAN RELATIONS, AA-AAS-T-COMMUNICATION
CMST 240 Intercultural Communication: Diversity 5 Credits Search Schedule
The study of intercultural communication theory and cultural adaptation processes, and the development of skills in transmitting and receiving oral and written messages within a cross-cultural context. Covers selecting a communication style and strategies appropriate to a specific audience and setting. Examines how differences in cultural background influence communication patterns in families, communities, schools, and the workplace. This course was formerly known as SPCH 105. Prerequisite: ENGL& 101 eligible or instructor's permission.
Distribution: AA, AAS, AS, DTA, COMMUNICATION, DIVERSITY, HUMANITIES, NURSING HUMANITIES, AAS-SPEAKING-LISTENING, AAS-HUMAN RELATIONS, AA-AAS-T-COMMUNICATION, AA-AAS-T-HUMANITIES
PSYC 116 Psychology of Human Relations: Diversity 5 Credits Search Schedule
An introduction to the study of human relations, self-concept and the internal influences on one's thoughts, feelings and behaviors. An examination of the external and sociocultural influences on our personal and professional relationships. Prerequisite: Eligible for ENGL& 101.
Distribution: AA, AAS, AS, DTA, DIVERSITY, SOCIAL SCIENCE, NURSING SOCIAL SCIENCE, AAS-HUMAN RELATIONS, AA-AAS-T-SOCIAL SCIENCE

 


Effective Catalog Year 2017-2018, Revised March 21, 2017