IT 170
3 Credit Hours
Instructor: Chet Cunningham Semester: Spring 2002
Office: 261 JHG Lecture:
MW 2:30 3:45 p.m.
Office Phone: (270) 824-8699 Room: 214 JHG
Instructor E-mail: chet.cunningham@kctcs.net Home Phone: (270) 821-7909
Website: http://www.madcc.kctcs.net/ccunningham
|
Office Hours: |
|
Tuesday & Thursday: 1:30 p.m 3:00 p.m. |
|
Wednesday: 9:00 a.m. - 11:00 a.m. |
|
& others by appointment |
Textbook: Database Management Systems Designing
& Building Business Applications
2nd Edition. Gerald V. Post. McGraw-Hill Irwin. 2002.
This
course introduces the standards for designing relational databases. Design criteria include first, second, and
third normal forms to eliminate modification anomalies. Discussions review the capabilities of three
major types of data models -- hierarchical, network, and relational -- as they
apply to hypothetical sets of data objects.
Experiences include the creation of logical design and translation into
a physical database using the relational model. Interaction with the physical database will be conducted through
a graphical interface and Query-by-example.
Course Competencies
1. Define a database management system and describe the
services a DBMS provides for the user
2. Be familiar with the features of primary types of
models upon which databases are built: hierarchical, network, relational,
object-relational, and object-oriented.
3. Define and be able to use normalization in the
logical design of a database
4. Model a realistic business application using a
technology-independent data model with emphasis on data integrity
5. Define and be able to use a data definition language
6. Demonstrate an understanding of how relational
algebra relates to database operations
Across the Curriculum Competencies
Writing Across the Curriculum:
To
satisfy the new general education requirements of writing across the
curriculum,
"All faculty are expected to call
attention to and penalize for errors in English usage and require the rewriting
of papers which do not meet acceptable standards." (CCS Rules, Section V, 2.32)
Writing:
There will be exams, which will include questions that will require a written
response. A written report may be required at the end of the semester.
Reading:
Each homework assignment includes reading the appropriate section of the
textbook as well as completing the assigned problems.
Integrated Learning: On exams, the students will be required to
identify and solve problems that involve applying concept to particular
situations.
Creative Thinking: On exams, students will be required to solve
problems that integrating concepts to create appropriate processes.
Ethics/Values: All students are expected to comply with the MCC Code of Conduct.
Plagiarism and cheating, as well as sanctions of these offenses, are defined in
Article III of this Code.
Prerequisites
CIS
130 and the math component (MAH 125 or MA 109) or consent of instructor.
Supplies
Two
3 ½ floppy disks. Each student is required
to obtain an e-mail address for this course.
Grading
|
|
% of |
|
Grading Scale |
|
|
Announced examinations
(3) |
45 |
|
A |
90- 100% |
|
Laboratory and
out-of-class assignments |
25 |
|
B |
89 - 80 % |
|
Final Project |
25 |
|
C |
79 - 70 % |
|
Participation/Attendance |
5 |
|
D
|
69 - 60 %
|
|
Total: |
100% |
|
F |
Below 60% |
Instructional Methods
A combination of classroom
lectures/discussions, hands-on chapter practices, chapter tests, and end of
chapter exercises will be utilized to help you gain proficiency in the
application of computer concepts and principles.
Hands-on Chapter Projects
You will be responsible for
reading and understanding each assigned chapter. Additionally, most students
will have to spend time outside of class to complete hands on projects. Each
assignment should be properly labeled.
Make sure your name, and
exercise number appear in the upper-left corner. If an exercise has multiple
sheets, then staple them together. Do not staple different assignments
together. Disorganized assignments (pages out of order, mislabeled, unreadable,
etc.) will receive a grade of zero. If there are multiple sheets are to be handed
in, then sequence them according to the order you were told to print them in
the exercise.
Course Policies
Hands-on Classroom Rules:
This class will be held in
a computer classroom and the following rules must be understood and followed:
1. NO FOOD OR DRINK ALLOWED IN THE CLASSROOM AT
ANYTIME!!!!!!
2. Please arrive on time and expect to stay the entire
class period.
3. Please do not use your computer during class
discussions unless told to do so.
4. Turn in your assignments on time! Use the class time
wisely. If you miss class, it is your responsibility to get your assignments
done outside of class. However, excessive classroom assignments done outside of
class will not be evaluated.
5. Please pay attention during class instructions and
demonstrations.
6. Unless directed otherwise, use the same computer
each class.
7. Use courtesy when using the printer, it is shared.
8. If you have questions please ask the instructor
instead of disturbing your neighbor.
Examination Policy:
Three announced examinations will be given. No make-up exams will
be allowed without prior arrangements being made. Make-up exams must be taken
when scheduled.
Late Assignment Policy:
Laboratory assignments
should be handed in immediately BEFORE lecture begins on the
specified due date. Laboratory assignments handed in after lecture begins are
considered late. No assignments will be
accepted more than one week late. Late assignments receive a 50% penalty.
Cheating
Policy:
Students
are expected to uphold the schools standard of conduct relating to academic
honesty. Students assume full responsibility for the content and integrity of
the academic work they submit. The guiding principle of academic integrity
shall be that a student's submitted work; examinations, reports, and projects
must be that of the student's own work. Students shall be guilty of violating
the honor code if they:
1. Represent the work of others as their own.
2. Use or obtain unauthorized assistance in any
academic work.
3. Give unauthorized assistance to other students.
4. Modify, without instructor approval, an examination,
paper, record, or report for the purpose of obtaining additional credit.
5. Misrepresent the content of submitted work.
The penalty for violating
the honor code is severe. Any student violating the honor code is subject to
receive a failing grade for the course and will be reported to the Office of
Student Affairs. If a student is unclear about whether a particular situation
may constitute an honor code violation, the student should meet with the
instructor to discuss the situation.
For this class, it is
permissible to assist classmates in general discussions of computing
techniques. General advice and interaction are encouraged. Each person,
however, must develop his or her own solutions to the assigned projects,
assignments, and tasks. In other words, students may not "work
together" on graded assignments. Such collaboration constitutes cheating.
A student may not use or copy (by any means) another's work (or portions of it)
and represent it as his/her own. If you need help on an assignment, contact
your instructor, not other classmates.
Incomplete Policy:
Incompletes will only be
considered in the most extreme cases of hardship.
Make-up Policy:
Make-up exams will be given
ONLY in the most extreme cases of hardship or unavoidable interruption of
participation. These are handled on an individual basis.
Any
acts of classroom disruption that go beyond the normal rights of students to
question and discuss with instructors the educational process relative to
subject content will not be tolerated, in accordance with the Academic Code of
Conduct described in the Student Handbook.
Only
in extreme cases are children allowed in classroom or laboratory facilities,
and then only with approval of the instructor prior to class.
Cellular
phones, pagers, CD players, radios, and similar devices are prohibited in the
classroom and laboratory facilities. Calculators and computers are prohibited
during examinations and quizzes, unless specified. Reasonable laptop-size
computers may be used in lecture for the purpose of taking notes.
Attendance Policy:
Attendance is strongly
recommended. Good attendance will translate into better grades, higher retention
of subject matter, greater success. Since much of the work is done in class
under the supervision of the instructor, poor attendance will usually translate
into poor grades.
Withdrawal Policy:
The last day for a student
to officially withdraw from class with a grade of "W" at his or her
discretion is March 11, 2002. After March 11, the instructor may grant a W, WP,
or WF. Note: WFs are averaged into
you GPA the same as an F.
Inclement Weather Policy:
In cases of inclement
weather please listen to area radio and television stations for cancellations.
Any
student requiring individualized classroom accommodations due to a disability
should schedule a conference with the Disability Resource Coordinator (Valerie
Wolfe, Room 112 LRC) at your earliest convenience.
This syllabus is tentative and subject to change at the
discretion of the instructor to meet class needs.
Tentative Course Schedule
IT 170
Spring 2002
|
Class Meeting |
Reading Assignment |
Laboratory Assignment
|
|
1/14 |
Course Introduction |
|
|
1/16 |
Chapter 1: Introduction |
Q 1-8; Ex. #1 Due 1/28 |
|
1/23 |
Chapter 1: Introduction |
|
|
1/28 |
Chapter 2: Database
Design |
Q 1-10; Ex. # 2 Due 2/4 |
|
1/30 |
Chapter 2: Database
Design |
|
|
2/4 |
Chapter 3: Data Normalization |
Q 1-12; Ex. #3 Due 2/11 |
|
2/6 |
Chapter 3: Data
Normalization |
|
|
2/11 |
Chapter 3: Data
Normalization/Review |
|
|
2/13 |
Exam #1 Ch. 1-3 |
|
|
2/20 |
Chapter 4: Data Queries |
Q 1-11; Ex. 1-10 Due 2/27 |
|
2/25 |
Chapter 4: Data Queries |
|
|
2/27 |
Chapter 5: Advanced
Queries and Subqueries |
Q 1-15; Ex. 1-5 Due 3/6 |
|
3/4 |
Chapter 5: Advanced
Queries and Subqueries |
|
|
3/6 |
Chapter 6: Forms and
Reports |
Q 1-13; Ex. 1 Due 3/20 |
|
3/18 |
Chapter 6: Forms and
Reports |
|
|
3/20 |
Chapter 6: Forms and
Reports/Review |
|
|
3/25 |
Exam #2 Ch. 4-6 |
|
|
3/27 |
Chapter 7: Calculations
and Data Manipulation |
Q 1-10; Ex. 2 Due 4/3 |
|
4/1 |
Chapter 7: Calculations and Data Manipulation |
|
|
4/3 |
Chapter 8: Application
Development |
Q 1-12; Ex. 1 Due 4/10 |
|
4/8 |
Chapter 8: Application
Development |
|
|
4/10 |
Chapter 9: Physical
Design |
Q 1-10; Ex. 4 Due 4/17 |
|
4/15 |
Chapter 9: Physical
Design |
|
|
4/17 |
Chapter 9: Physical
Design/Review |
|
|
4/22 |
Exam #3 Ch. 7-9 |
|
|
4/24 |
Chapter 10: Database
Administration |
Q 1-16; Ex. 2 Due 5/1 |
|
4/29 |
Chapter 10: Database
Administration |
|
|
5/1 |
Lab Day |
|
|
5/6 |
Final Project Presentation |
|