COT 301 - Database Management Essentials

Fall 2006

Credits: 1
Instructor: Cindy Hyslop
Office: HTC 128
Phone: 753-2307 (office with voice mail)
E-mail: mailto:nickel@gbcnv.edu
Class Web Page:


Textbooks: There is no textbook for this class, handouts will be provided in class.
Course Description: A working overview of Access database. The main emphasis will be on analyzing previously established data, using table searches, queries, and reports. Excel will be used for further data analysis. A discussion of table design will be included. Students will start work on individual portfolios of their achievements during this degree program. (Prerequisite: a GBC AAS in COT with either CADD/GIS, Graphic Communications, Network Specialist, Office Technology, or Web Specialist Emphasis; or equivalent degree from another community college)

SYLLABUS:

Welcome to CIT 301, Database Management Essentials. This course provides the essential information for digital information technology management students with a strong IT background but who do not have much background in database management. A GBC AAS in COT with either CADD/GIS, Graphics Communications, Network Specialist, Office Technology, or Web Specialist Emphasis; or equivalent degree from another college is the prerequisite for this class. Various database management principles, best practices for managing data systems, and the tools to manage databases will be introduced in each lesson with some time allotted for a hands on evaluation of each. You will need additional time each week outside of scheduled class time to complete readings and assignments. Some of the computers available in the GBC High Tech Center have the software used in class for your use outside of class. If you have the necessary hardware and software, doing your assignments at home is acceptable.

I can be reached at the phone number listed above or you can make an appointment to see me during office hours or at other times. Office hours are posted on my office door and on the class website. The schedule of readings, assignments, homework, and tests is found below. Additional assignments may given verbally or as handouts in class. Office hours are posted on my office door and on my website. Additional assignments may given verbally or as handouts in class.

MAJOR OBJECTIVES OF THIS CLASS

The primary objective of this class is to provide students with a strong information technology background but little in database systems with a working knowledge of database concepts, terminology, and principles. Students who successfully complete this class should be conversant in essential database concepts, software, and hardware. The more important topics include:

LEARNING OUTCOMES

The successful student in this class will be able to:

  1. comprehend and interpret discussions and readings of database management issues;
  2. explain key database management principles and techniques;
  3. evaluate the validity and comprehensiveness of a database proposal;
  4. create a basic database with appropriate relationships.
Student Outcome Assessment
Assessment Method Learner Outcomes
Class Discussion 1, 2, 3, 4
Hands-on Exercises 1, 2, 3, 4
Term Paper or Mini Project 1, 2, 3, 4

This is a pass/fail class a P=70-100%, F=69% or less or W=Official Withdrawal by the official withdrawal date. Your grade will be based 30% on class participation and discussion, 30% on the hands-on exercises, and 40% on your term paper or mini project. Any excused absences must be agreed to by the instructor in advance unless there are strong extenuating circumstances. One (1) unexcused absence will result in an Failing grade. The code of conduct stated in The Rules and Disciplinary Procedures for Members of the University Community will be enforced.


 

COURSE SCHEDULE

You should have read and be prepared to discuss these topics by the beginning of each class. We will have significant hands on experiences during most lessons.

Topics & readings by lesson:
Lesson 1: Database terminology
Lesson 2: Essential database management principles
Lesson 3: Principles of data relationships
Lesson 4: Database management & security concepts
Lesson 5: Term Paper or Mini Project is due