Up Computing Inro to  Program Programming I Programming II Operating Systems Databases Prof  Practice



Georgia Gwinnett College

The School of Science and Technology


Introduction to Databases

ITEC 3200

 Spring 2008



 Dr. Anatoly Kurkovsky

Classes: Thursdays 18:00-20:30 at ……

Office Availability: Mutually agreed time between professor and student by appointment at C-2153

Telephone: 678 407 5732


 Catalog Course Description:

Prerequisite: ITEC 1201.

Introduction to fundamental concepts of database management including: schema design and refinement, query languages, transaction management, security, database application environments, physical data organization, overview of query processing, physical design tuning.

 Course Goals: 

Upon a successful completion of this course the students will:


Understand data, metadata, and database systems core concepts


Understand logical/physical data organization and transaction management fundamental concepts


Understand the relational database model


Understand and use entity relationship (ER) modeling for conceptual design


Understand and use normalization of database tables technique to reduce data redundancy


Understand and use the core portion of structured query language (SQL) for data manipulation


Design, test, and use databases within the course scope and in framework of Microsoft Access database application environment

 Textbook and references:

 Required textbook:


Database Systems: Design, Implementation, and Management, Seventh Edition by Peter Rob and, Carlos Coronel. Course technology. 2007. ISBN 13: 978-1-4188-3593-4.

 Optional textbooks:


Microsoft Office Access 2007: Comprehensive Concepts and Techniques by Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt, Mary Z. Last. Course technology. 2008. ISBN 13: 978-1-4188-4341-0

Grading policy:

 Your performance in this class will be measured by three written tests (50%), several assignments (30%), and your class participation (20%). Questions on the tests may include the following:

bulletmultiple choice answer selection,
bullettrue-false answer selection.

The types of assignments may include:

bullet small in-class (laboratory) programming projects,
bullet take-home (it may be SQL programming) assignments.

You will receive a grade of 0 for assignments submitted after the deadline. When you submit your assignment: include your class, name, assignment number and appropriate file names.

 Evaluation of your class participation will include:

bullet attendance,
bullet understanding of the course material,
bullet responsibility to answer professor’s questions.

 The final grade will be derived from your performance on the tests, assignments and class participation as follows:

bullet A: 90-100
bullet B: 80-89
bullet C: 70-79
bullet D: 60-69
bullet F: below 60

Tentative Schedule:

(These dates could be changed depending upon the pace of the course.)




Lecture Topic

Student Projects & Labs




Jan 7


Introducing the database, historical roots of the DB





Jan 14


A file system critique, DB systems





Jan 21


DB models

Project 1. Creating a DB Using Design and Datasheet Views




Jan 28


Degrees of data abstraction


Assign. 1



Feb 4


The data dictionary, relationships within the relational DB





Feb 11


Data redundancy revisited, indexes

Project 2. Querying a DB Using The Select Query Window

Assign. 2



Feb 18


The Entity Relationship (E-R) Model: cardinality, relationship participation, week entities.



Test 1


Feb 25


E-R Model: relationship degree, composite entities.





Mar 3


DB Tables and Normalization: 1NF, 2NF, 3NF, BCNF





Mar 10


Spring Break – No Classes





Mar 17


Normalization and DB Design, Denormalization

Project 3. Maintaining DB Using the Design and Update Features of Access

Assign. 3



Mar 24


Introduction to SQL, Data Definition Commands: tables and their components, creating table structure. Basic Data Management: data entry, listing table contents, making correction



Test 2


Mar 31


Queries: partial listing of table contents, logical operators (AND, OR, NOT), special operators, Advanced Data Management Commands





Apr 7


Advanced Data Management Commands. More Complex Queries and SQL Functions: ordering a listing

Project 4. Administering a Database System (SQL Query)

Assign. 4



Apr 14


More Complex Queries and SQL Functions. Converting an E-R model into a DB structure, general rules converting relationships among tables





Apr 21


Discussion and exercises. Preparation to exam





Apr 28


Apr 28 is the last Day of Classes before Final Exams





Apr 30

May 6


Final Examinations



Test 3


May 9


Grades Due





Final Exam date:

 May 5th, 2008.

 Student Policy Statement:

 Students are expected to abide by all policies in the catalog of Georgia Gwinnett College and School of Science and Technology as well as all policies posted on the official web site of Georgia Gwinnett College.

College Policies:

 Regent’s policy statement

The University System of Georgia requires that all students enrolled in undergraduate degree programs in University System institutions (including Georgia Gwinnett College) successfully complete all parts of a competency examination in reading and English composition.  This competency examination is commonly called "the Regents' Test", and it is free of charge.  A student has two attempts to pass this test before accumulating 45 hours of collegiate credit.  Please sign up for the Regents' Test when you enroll in English 1102.  Do this in time to have two attempts before accumulating 45 credit hours.

 Americans with disabilities act statement

If you are a student who is disabled as defined under the Americans with Disabilities Act and require assistance or support services, please seek assistance through the Center for Disability Services.  A CDS Counselor will coordinate those services.

Equal opportunity statement

No person shall, on the grounds of race, color, sex, religion, creed, national origin, age or disability, be excluded from employment or participation in, be denied the benefits of, or otherwise be subjected to discrimination under any program or activity conducted by Georgia Gwinnett College.

Affirmative action statement

Georgia Gwinnett College adheres to affirmative action policies designed to promote diversity and equal opportunity for all faculty and students.

Academic respect

The college exists to foster educational excellence.  To this end, a classroom atmosphere that supports learning must be maintained.  Students are expected to be active, attentive participants in the class.  Students are also expected to abide by class policies and procedures and to treat faculty and other students in a professional, respectful manner.  Students are expected to be familiar with the student conduct code published in the Student Handbook.

Academic integrity

All portions of any test, project or final exam submitted by you for a grade must be your own work.  Cheating includes any attempt to defraud, deceive or mislead the instructor in arriving at an honest grade assessment.  Plagiarism is a form of cheating that involves presenting as one's own, ideas or work of another.  Violation of the Academic Integrity Policy will result in a grade of "0" for that test, project or exam.  The second offense will result in assignment of a grade of "F" for the course and a formal charge of Academic Dishonesty will be lodged with the Vice President for Academic and Student Affairs.  Policies have been established by Georgia Gwinnett College to insure due process in charges of cheating or plagiarism. A copy of these procedures can be found in the GGC Student Handbook.

School of Science and Technology Policies:

Absence/Make-up Policy

You are expected to attend each class meeting.  Attendance may be taken by various methods that could include clicker or written quizzes in the first 5 minutes of class, or sign in sheets. This information will be taken into account at the end of the semester when grades are calculated, if you are on the borderline.

Special arrangements to take a regular exam early must be made in advance and in writing, if a pressing obligation prevents you from taking an exam.

Students must notify Professor THE DAY of the exam if an emergency arises and they miss the exam. Notification may be by email, text or phone message is acceptable. A makeup will be scheduled within two days of the original exam. Makeup exams may not be the same format as the regular exam. Other formats include essay or oral exams to a faculty panel. A valid written excuse for missing the regular exam is required. (Police report, ER forms, doctor's note, etc.)

 Instructor/Course Policies:

 Drop for non-attendance

Students who never attend a class by the end of the first two weeks of the term will be reported for non-attendance. Students who do not drop a class during the schedule adjustment period and are reported for non-attendance will be automatically dropped from that course.

 Course Absence

You will not get a good grade in the course without an excellent attendance. If you miss a class, you are responsible for all lecture notes, slides, assignments, and other.  All students are allowed 3 absences from class in the semester with no penalty for crisis or non-crisis reasons. Students who miss four or five class sessions will be subject to a substantial grade deduction of 5 points.  After six absences, it is recommended that you drop the course.

Course changes

This course syllabus provides a general plan for the course. The professor reserves the right to make changes to the syllabus, including changes to assignments, projects, examinations, etc., in order to accommodate the needs of the class as a whole and fulfill the goals of the course.  

 Some common sense notice

bulletPlease do not be late for classes,
bulletPlease do not wear hats in the classroom,
bulletPlease turn off all cell phones, beepers, pagers, buzzers, and other noisy electronic devices during class time,
bulletPlease do not bring children, parents, friends, etc. into the class,
bulletPlease show common courtesy to your fellow classmates and professor.


horizontal rule

This Web site is © 2003 - 2012 by Anatoly Kurkovsky

Last updated: June 01, 2012