---

Class Location & Times: This is a three-credit course that meets three hours per week for sixteen weeks – from 3 September through 17 December. Class meets once each week (on Thursdays) from 6:00 PM to 8:50 PM in room C 133 on the West Charleston campus.

Catalog Description: Basic concepts of data modeling and relational database design. Hands-on learning of Structured Query Language. Prerequisite: IS 115 or equivalent programming experience or permission of instructor.

Required Textbooks: Beaulieu, Alan, Learning SQL, 2^nd edition, ISBN 9780596520830, and Herzog, Joe, Database Design in Plain English, ISBN 9781419670275.

Computers and Software: This class will use MySQL as the platform for learning SQL. The computers in the classroom and one pod in each of the Campus Computer Labs are loaded with MySQL. MySQL 5.1 Community Server is available for download to your home computer from http://dev.mysql.com/downloads/mysql/5.1.html.

Documentation is available

• for download from http://dev.mysql.com/doc/
• for viewing on-line at http://dev.mysql.com/doc/refman/5.1/en/index.html

Other Requirements: A removable data storage device, a 3-ring binder for your lecture notes and printed exercises, paper and pen or pencil for taking notes.

Course Objectives: This course will provide you with a solid understanding of the relational model and of the theory behind SQL. Furthermore, it will address the needs of both the user and the developer. From the user's standpoint you will become proficient at translating information needs into appropriate SQL statements. From the developer's standpoint you will gain experience in designing databases which conform to the relational model. Specifically, when you successfully complete the course, you will be able to

• explain the fundamental concepts of relational database design
• demonstrate how relations (tables) can be normalized
• use the operations of relational algebra to create new relations from existing relations
• explain the implementation of relational algebra in SQL
• use SQL commands to create tables and to insert, update and delete data in tables
• embed SQL commands in a program
• using normalized database tables, formulate SQL queries of varying complexity to extract information
• design and implement an SQL-based information system to meet the requirements of a case study or of an actual user.

Measurement of Objectives: You will know you are meeting the course objectives stated on the previous page as you successfully

• complete the exercises in the textbook that teach and reinforce the skills and techniques covered in the course,
• attend class and participate in classroom activities, and
• pass tests and complete projects that require you to demonstrate mastery of concepts and skills.

All of these activities result in points that are accumulated during the semester. The final point total determines the grade you earn.

Grading Policy: The following are the requirements of the course, their weights and the minimum accumulated points for each letter grade:

Requirements	Points	Letter Grade	Minimum Points
3 In-class Exams @ 50	150	A	360
Take-home Exam	75	B+	330
Database Design Project	100	B	300
In-class Activities	75	C+	270
Total	400	C	240
Comprehensive Final	50	D	200

Exams: There will be three in-class, 90-minute exams and one take-home exam. The dates of the in-class exams are given in the Weekly Schedule. Every effort should be made to take the exams at the announced times. No make-ups will be given. At the end of the semester there will be a 90-minute comprehensive final exam covering all of the course material. Your score on the final exam may be used to replace your score on one of the in-class exams. All exams will be open-book and open-note. All exams will require the use of MySQL.

In-class Exercises: Class time will be used to expand upon, refine and practice techniques presented in the textbook, as well as to develop new material. In preparation for each class you should complete the reading assignment and associated exercises; review previously covered material; bring textbook, paper, binder, writing implement and data storage device to each class. If you miss class, you are still responsible for the material. So, you will have to get notes from another student.

Database Design Project: You will design and implement a normalized database to meet the needs of a case student and write queries to answer specific questions of the database. The due date is given in the weekly schedule. No late projects will be accepted.

Homework: There are no graded homework assignments in this course, although assignments may be made that should be completed for the next class. Obviously, “doing your homework” is the only path to success in this course. Your homework in this course consists of

• completing any assignments;
• reading the textbook very carefully and completing any hands-on exercises;
• repeating each skill until the skill is second nature to you; and
• experimenting with new features encountered each week.

Most of your homework will have to be completed using a computer and the appropriate software. Before each class meeting you should set aside a couple hours when you can focus on this work only (no phone, no TV, no kids). For each hands-on exercise in the textbook read each step carefully, execute the instruction and check the result. Do this until you have mastered the skill.

Student Behavior

Ground Rules: You and your fellow students want to get the most out of this course. This will be possible only if everyone follows these guidelines:

• Treat fellow students and your professor with courtesy and respect.
• Arrive to class on time and ready to get to work and to learn.
• Turn off cell phones and beepers during class. Cell phones and any other “messaging” devices must be put away during class time.
• Safeguard classrooms and computers by not eating or drinking in the classroom.
• Use classroom computers for class work – no surfing the Internet, no reading e-mail, no playing games, etc. during class time.

Academic Honesty: According to the Schedule of Classes, “CSN demands a high level of academic behavior. Acts of academic dishonesty including plagiarism and cheating, are regarded as very serious offenses.” In this class any academic irregularities will result in a grade of ZERO for the specific test/assignment.

Note: If you have any concerns about this course and/or me, please contact me first. If I cannot resolve your issue, please contact the CET department office at 651-4660 and speak to the department chairman. You will remain anonymous and all communications will be strictly confidential. Please DO NOT wait till the last minute to make your concerns known to me and/or to the department chairman.

Student Resources

Disability Resource Center: If you have a documented disability that may require assistance, you will need to contact the Disability Resource Center (DRC) for coordination of your academic accommodations. The DRC is located in Student Services on each campus. The phone numbers for each DRC office are: West Charleston 651-5644, Cheyenne 651-4045, and Henderson 651-3795. For students that would like to perform community service or earn extra money, stop by the DRC to fill out a job interest card. This office hires students as note takers, proctors, scribes, and lab assistants as needed.

The Reentry Program: This program assists students pursuing an Associate of Applied Science Degree and/or Certificate programs at CSN with a special emphasis on individuals pursuing non-traditional occupations. To be eligible the student must complete a FASFA each year, declare an AAS degree or certificate program, participate in required meetings, maintain adequate academic progress & have demonstrated financial need. Services include: Career guidance & exploration, information on non-traditional occupations, mentoring and academic advisement, community assistance referrals, Academic & Life Strategies workshops, employability workshops, scholarships for tuition and books, assistance with transportation, uniforms and tools, Textbook Assistant Loan Program. The ReEntry Program phone numbers are Cheyenne 651-4700; Charleston 651-5089; Henderson 651-3174.

Tutorial Services: All CSN students are allowed 4 hours of free tutoring per one credit of coursework. Students enrolled in this course are entitled to 12 hours of free tutoring. To make arrangements for this benefit, you must take your semester schedule to Tutorial Services at the campus of your choice. The earlier you apply for help, the more likely that you will succeed.

Retention/Student Success Services: The Office of Student Retention (651-2626 at Cheyenne, 651-7367 at West Charleston, and 651-3103 at Henderson) offers a wide array of services and programs to help make your experience at CCSN a successful and rewarding one. Among them are:

• Coyote Student Coaches - Free Tutoring on a walk-up basis during posted hours. Student Coaches are available in the D lobby at the West Charleston campus, in the student Lounge at the Cheyenne campus, and in the C building at the Henderson campus.
• Success Planning Appointments - The staff of the Retention Office is committed to helping you succeed at CSN by sitting down with you, assessing your needs and getting you plugged in to CSN's many resources.