TITLE: Database Concepts
Lead Instructor: Dr. Frank Chao (see Wake Tech course schedules, class and section, for the actual instructor)
Office: PLM 351G
Phone: (919) 773-4736

Office Hours:
Posted on Blackboard

     Title: A Guide to MySQL
     Author: Philip J. Pratt, Mary Z. Last
     ISBN: 1-4188-3635-4
     Publisher: Thomson Course Technology

Special Instructions: Students MUST BE proficient in the use of a personal computer.
Software used to complete coursework: Use MySQL 5.0 (downloadable from http://www.mysql.com/)
Other required equipment:

Credit Hours: Three (3) Semester Hours
Pre-requisites: none
Co-requisites: none
Course Description:
This course introduces database design and creation using a DBMS product. Emphasis is placed on data dictionaries, normalization, data integrity, data modeling, and creation of simple tables, queries, reports, and forms. Upon completion, students should be able to design and implement normalized database structures by creating simple database tables, queries, reports, and forms.

Course Goals:
  1. To provide the student with a basic understanding of database terminology, types and usage in industry.
  2. To provide the student with the basic concept of current trends in database technology.
  3. To provide the student with the basic skills needed to create and query a particular DBMS product.
  4. To provide the student with basic knowledge of database system design, creation, I/O and update.
  5. To expose the student to Database Management as a possible field of study.
Course Objectives:
Upon successful completion, students will be able to demonstrate (through completion of classwork and assignments):
  • a basic understanding ! of database terminology.
  • a basic understanding of the role of DBMS in the business world.
  • a basic understanding of the database functions (table creation, query and data manipulation) in a particular DBMS product.
  • an awareness of current DBMS trends.
The Core Values of Wake Technical Community College
Respect Instructor and students will foster an environment that is respectful of all.
Responsibility Instructor and students will foster an environment that promotes taking responsibility for one's actions and obligations.
Critical Thinking Instructor and students will strive to improve the critical thinking skills of analysis, synthesis, and evaluation.
Communication Instructor and students will strive to ensure that both written and oral communications are clearly understood.
Collaboration Instructor and students will strive to develop collaborative skills.

Grading Is As Follows:
Exams 60 30% of each
Labs 30 About 10 homework assignments
Attendance 10 Attendance is required

Classroom Policies:
  • Students are responsible for all of the information presented in the Wake Technical Community College Student Handbook.
  • Please note that computers are to be used at all times for official course purposes. Use of computers for general web surfing, email, chat rooms, etc. is not allowed. Violation of this rule will result in a grade deduction and possible loss of computer privileges.
  • The college forbids the use of audible electronic equipment (cell phones, pagers, etc.) during instructional time.
  • If you miss a lecture or arrive late, you are responsible for the material presented, handouts distributed, and any announcements made that day. The instructor will not provide notes for missed classes.
Tentative Schedule
Note: This schedule is subject to some changes/modifications per Instructor -- This offered as only a study guide. The pace of each class differs according to the instructional needs of the students in the class. Always consult with your instructor. Note** A Final Project may be assigned in lieu of a Final Exam.
Unit Coursework Textbook/Assignments
Installing MySQL for MS Windows
Chapter 1
An introduction to SQL
Chapter 3
Simple Queries and WHERE clause
Chapter 4
Functions in SQL
Chapter 4
Grouping in SQL
Chapter 4
Multiple-Table Queries
Chapter 5
Data Manipulation
Chapter 6
Table Structure and Transaction
Chapter 6
Database Administration
Chapter 7
Database Concepts and Design
Chapter 2
Database Normalization
Chapter 2
MySQL Special Topics (Part I)
MySQL Special Topics (Part II)
MySQL Special Topics (Part III)

Disability Support Services is available for students who require academic accommodations due to any physical, psychological, or learning disability. To determine eligibility, contact the office at 108-S Holding Hall or call
662-3405 (TDD 779-0668)

Copyright 2006/2007 Wake Technical Community College All Rights Reserved