CSC 150 Database Applications and Design Using SQL

Spring 2010


Connecticut Community Colleges Gateway Community College Student Info System Contact Instructor



Term Project

Course Textbook

 SQL Fundamentals, Third Edition
John J. Patrick
Prentice Hall, 2009
ISBN 0-13-712602-6

Students must be prepared for each class and must bring all necessary materials and computer files. Students not prepared for the class will be asked to leave the class until they are prepared.

The following links provide excellent information on how to read a textbook and other study guides:

P-R-R: How to Read Your Textbook More Efficiently -
Study Guides and Strategies -
Reading Your Textbooks -
Taking Lecture notes -

Time Requirements

Each student will need a different amount of time to complete reading and homework assignments based upon his/her previous experience. The following is a general guideline of the time that will be required outside of the 5 hours per week of class time.

Reading course material: 1 to 2 hours per week
Written/Computer work: 1 to 2 hours per week.

Plan on spending 4 hours, possibly more, per week outside of class time.

Students with Disabilities

Students with physical or learning disabilities who may require accommodations are encouraged to contact the Counseling Office. After disclosing the nature of the disability, students are urged to discuss their needs with individual instructors. This should be done at the beginning of each semester. Instructors, in conjunction with appropriate college officials, will provide assistance and/or accommodations only to those students who have completed this process

Course Outcomes

By the end of the semester, students should meet the following objectives:

Course Requirements

Students are expected to attend all classes and to complete all course work in a timely manner. Course work will consist of reading and understanding course materials, preparing materials for the hands-on portion of the course, and completing homework assignments. Students are expected to complete textbook readings and any preliminary assignments before attending class.

Academic Integrity & Classroom Behavior

Open discussion of ideas among students is encouraged, but each student is expected to do his or her own work. Plagiarism, turning in work derived from someone else's work without full attribution of anyone else's work, will result in a failing grade. Two students turning in the same assignment will both receive a failing grade on the assignment. It is the responsibility to each student to protect his or her own work.

The instructor is available via e-mail 24/7 to answer any questions students may have regarding any aspect of this course.

Gateway Community College statement on academic honesty & Classroom Behavior:

At Gateway Community College we expect the highest standards of academic honesty. Academic dishonesty is prohibited in accordance with the Board of Trustees' Proscribed Conduct Policy... This policy prohibits cheating on examinations, unauthorized collaboration on assignments, unauthorized access to examinations or course materials, plagiarism, zero tolerance for threatening, intimidating, and violent behavior, and other proscribed activities.

Plagiarism is defined as the use of another's idea(s) or phrase(s) and representing that/those idea(s) as your own, either intentionally or unintentionally.

Attendance, Assignments, & Exams

Students are expected to attend all classes and attendance will be taken at each class. If a student cannot attend class, he or she must contact the instructor either by note in the instructor's mailbox or via e-mail. Students missing class are still responsible for any materials covered in that class. Homework is still due on the given date, even if the student is not physically present in class, and maybe submitted via e-mail or in the first class attended after an absence. Missing classes will result in a lower grade or failure of this class.

Students missing more than 25% of classes will not be given college course credit for this class.

Students leaving early will not receive credit for attending class that day

Assignments are due on the given date, unless arrangements are made in advanced with the instructor. A hard copy (print-out) of all assignments must be turned in during class, even if the assignment also requires the student to submit the assignment via e-mail. If a student cannot attend a class, the hard-copies of any missed assignments must be turned in at the next class the student attends. Late assignments will not be accepted unless arrangements have been made with the instructor. The leading cause of poor grades in this class is the lack of homework!!

There will be two one hour tests and one cumulative final exam. All exams are closed book. Requests to make-up a missed exam must be made, in writing or via e-mail, prior to but no more than twenty-four hours after the scheduled time for the exam.

Failure to complete reading and home work assignments is the major cause of bad grades!!

Grading Standards

Please Note: Percentages may fluctuate slightly

Final grade for this class will be based on the following:

Cellular Phones & Pagers in the Classroom

Students are hereby notified that cellular phones and beepers are allowed in the class only if they are turned off or turned to silent mode. Under no circumstances are telephones of be answered in class. Students who ignore this policy may be asked to leave class. When there are extenuating circumstances that require a student to be available by phone or beeper, the student should speak to the instructor prior to class, so that together they can arrive at an agreement concerning the devices.

Test #1
Test #2
Take Home Final
In Class Final

Last Updated: 1/7/10