Course Objective:

This course covers relational databases and the efficient design of these databases. The course will include the definition of tables and indexes, logical and physical design, the E-R model, and transaction management. The use of Structured Query Language (SQL) will be emphasized.

Upon successful completion of this course the student will be able to create, design, and implement a database using MySQL and SQL commands. The student will have demonstrated proficiency in creating and setting up databases, and interfacing with those databases using command-line SQL.

As this course will be a blended class, using D2L in addition to other web-based systems, internet access from outside the classroom will be a requirement.

Course Credits:
Credit Type: lecture
Credits: 4

Textbooks and references:

All textbooks are available in the bookstore.

Course Prerequisites:

CCIS 1000, CCIS1101, and one semester in a procedural programming language

Special Accommodations:

Any student who has any need for special accommodations in this course is encouraged to contact the instructor at the beginning of the course.

Supplies:

A number 2 lead pencil will be required for all exams. It is recommended that students have access to a USB thumb drive with capacity greater than 8 MB.

Course Requirements and Evaluation:

Grading:

Final grades for this course will be computed by adding the student's total points and dividing that sum by the total available points. Final grades will be determined as follows:

A = 90% +

B = 80% - 89%

C = 70% - 79%

D = 60% - 69%

F = 0% - 59%

Point Distribution:

2 tests @ 100 pts 200 pts

6 labs @ 25 pts 150 pts

Total Points: 350 pts

Exam Information:

All quizzes and exams are open book / open computer.

ALL MAKEUP EXAMS MUST BE ARRANGED IN ADVANCE AND MUST BE COMPLETED WITHIN ONE WEEK AFTER THE EXAM! ALL MAKEUP EXAMS MUST BE COMPLETED BEFORE THE LAST SCHEDULED CLASS SESSION.

Homework Information:

All homework must be done on an individual basis. There are no team projects.

Studying together is strongly encouraged, however collaborating on homework or assignments is not.

ALL homework is due at the end of the following class period. Unless otherwise specified in the assignment, homework is due at the end of the class period following that in which it was originally assigned. Late homework will receive no credit. Illegible homework will receive no credit. Homework which does not have the student's name clearly marked will be discarded.

Example:

Assignment is given on Monday 1/19/2006.

Homework is due in class by the end of class on 1/26/2006 or

online by 11:59pm (central) on 1/26/2006.

NO HOMEWORK WILL BE ACCEPTED AFTER THE LAST SCHEDULED CLASS.

Tentative Course Overview (subject to change)

Other Information:

Information regarding dropping or adding classes, academic misconduct, HTCs incomplete policy, and withdrawing from a course can be found in the student handbook. Free copies of the handbook are available at the Student Bookstore.

Classroom expectations:

Please set cellphones and pagers to "off", "vibrate" or "silent" and turn off any headsets during class hours.

Please feel free to ask questions during lectures. I am here to help you learn, it is your responsibility to ask a question if you do not understand a topic. Remember, if you have a question, odds are 3 – 4 other people are wondering the same thing. Active participation will help you and other students.