Professor: Dr. Kate Pulling
Office: West Charleston Campus, Building C, 151 B
Office Phone: (702) 651-5702
E Mail: Use Canvas course mail
Office Hours: Tues: 5:00 PM – 6:00 PM; Wed: 4:30 PM – 6:00 PM; Thurs: 2:30 PM – 5:00 PM; and by appointment.
Class Location & Times: This is a three-credit course that meets three hours per week for the sixteen weeks of the semester, which runs from 26 August through 15 December. Class meets in room C 133 on the West Charleston campus. Meeting days and times are:
Catalog Description: Basic principles of data modeling and relational database design. Hands-on learning of Structured Query Language (SQL). Prerequisite: IS 115 or Instructor approval.
Required Textbook: Joel Murach, Murach’s MySQL, 2nd edition, ISBN 978-1-890774-82-0.
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.
Computers and Software: This class will use MySQL as the platform for learning SQL. In the classroom and in the campus computer labs, MySQL (MariaDB) is available as part of XAMPP, a PHP development environment. XAMPP is available for download to your home computer. XAMPP is available for download from https://www.apachefriends.org/index.html.
MySQL documentation is available on-line at
MySQL Workbench will be used to aid in the design of databases. Version 8.0 is available for download to your home computer from http://www.mysql.com/downloads/workbench/. Note that installation on Windows requires two libraries. Scroll down the webpage to the “Generally Available (GA) Releases.” and select your computer’s operating system.
The computers in the classroom, and at least one pod in each of the Campus Computer Labs, are loaded with MySQL, as part of XAMPP, and MySQL Workbench.
Data Files: Data files needed for textbook examples and exercises are available
CSN Library Services offers extensive in-person and online resources to help you complete assignments, including research and citation workshops, online articles and books, and drop-in research assistance at the Reference Desk inside each campus library and online at https://sites.csn.edu/library/.
“Safari Books Online” is of special interest to students in CIT courses. To access this digital library of technical books and videos, click on the Browse Databases button on the Library’s homepage, homepage at https://sites.csn.edu/library/, then click on the letter S to filter the databases. The link to “Safari Books Online” should be at or near the top of the resulting list.
Initially, you will have to enter your student email address, then create an account with Safari. Subsequently, you will use your email address and your Safari password to access the Safari resources.
Printing @ CSN: Printing in CSN classrooms, computer labs and libraries falls under the Print Wise initiative, designed to help save natural and fiscal resources. Print Wise provides each CSN student with a $10 credit toward printing at the start of each semester, which will provide for up to 200 black and white copies at 5¢ a page, or 40 color copies at 25¢ a page. After that, you may put money into your account online or at a CSN Cashier’s Office to purchase additional prints at the same rate. It is your responsibility to maintain your printing accounts to cover printing expenses during each semester. Exams in this course will require printed output.
More information about the Print Wise system may be found at https://at.csn.edu/printwise.
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
Measurement of Objectives: You will know you are meeting the stated course objectives as you successfully
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|
|Exam 1: Oct 1 | Oct 2
(Chs. 1, 3 & 4)
|Exam 2: Nov 5 | Nov 6
(Workbench, Chs. 5, 8, 10 & 11)
|Exam 3: Dec 3 | Dec 4
(Chs. 6, 7 & 9)
|Database Design Project Due: 10 Dec | 11 Dec||100||C+||270|
|Comprehensive Final Exam: 10 Dec | 11 Dec||70||F||0|
Note: Instructors do not have the option of withdrawing students. If you wish to receive a W in lieu of a grade, you MUST withdraw yourself officially from the class. Once you have withdrawn (dropped), you must discontinue attending class. Alternatively, you may wish to change from Credit to Audit and continue to attend the class.
Either of these actions may have implications for financial aid.
The deadlines are as follows:
Exams: There will be three in-class exams. The dates of the exams are given above and 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 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, some will also require use of MySQL Workbench. Exams will require printed output.
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 reading assignment and any assigned exercises; review previously covered material. Bring the textbook, paper, binder, a writing implement and a data storage device to each class. If you miss class, you are still responsible for the material. 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 study and write queries to answer specific questions of the database. No late projects will be accepted.
Homework: There are no graded homework assignments in this course. However, some assignments will be made that should be completed for review in the next class.
CIT/CS/IS101/IS115 Software Labs: The labs are a service of the CIT Department to provide specialized help for your CIT, CS or IS classes. No appointments are necessary.
The Software Lab monitors can assist with understanding of key concepts covered in your classes. A lab monitor may not be able to answer all questions, but he/she can refer you to external resources or to your instructor for additional help. A lab monitor cannot provide direct assistance with work related to assignments. Alert the lab monitor if your questions are specific to your homework assignments.
Remember that the Software Labs (dedicated rooms at West Charleston and North Las Vegas campuses) are completely separate from the OPEN computer labs at all CSN locations. The OPEN computer labs provide access to general software; the lab monitors at the OPEN labs will not be able to answer any programming-related questions.
|Week||Tues | Wed||Planned Topic/Activity
(Complete reading assignment BEFORE class)
|1||27-Aug | 28-Aug||Introduction (Ch. 1)|
|2||3-Sep | 4-Sep||Single-table queries (Ch. 3)|
|3||10-Sep | 11-Sep||Single-table queries, continued|
|4||17-Sep | 18-Sep||Multi-table queries (Ch. 4)|
|5||24-Sep | 25-Sep||Multi-table queries, continued|
|6||1-Oct | 2-Oct||Exam 1 — Chs. 1, 3 & 4|
|7||8-Oct | 9-Oct||Insert, update, delete data (Ch. 5)|
|8||15-Oct | 16-Oct||Database design (Ch. 10)|
|9||22-Oct | 23-Oct||MySQL Workbench, Data types (Ch. 8)|
|10||29-Oct | 30-Oct||Create databases, table, indexes (Ch. 11)|
|11||5-Nov | 6-Nov||Exam 2 — Workbench; Chs. 5, 8, 10 & 11|
|12||12-Nov | 13-Nov||Summary queries (Ch. 6); Database Design Project distributed.|
|13||19-Nov | 20-Nov||Subqueries (Ch. 7)|
|14||26-Nov | 27-Nov||Functions (Ch. 9)|
|15||3-Dec | 4-Dec||Exam 3 — Chs. 6, 7 & 9|
|16||10-Dec | 11-Dec||Comprehensive Final Exam
Database Design Project Due
Disclaimer: This syllabus is subject to change as deemed appropriate by the instructor and with advanced notification.
Important Dates in the College Calendar:
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:
Academic Honesty: 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.
You are expected to have read and understood the current issue of the student handbook (published as part of the College Catalog) regarding student responsibilities and rights, the intellectual property policy, procedures and what constitutes acceptable on-campus behavior.
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 CIT Department Office at 702-651-5976. You will be directed to the appropriate Program Director or to the Department Chair. You will remain anonymous, if possible, and all communications will be strictly confidential. Please DO NOT wait until the last minute to make your concerns known to me and/or to the CIT Department.
Academic Counseling: If you are a new student or have not declared your major, you will meet with a CSN success coach for all your advising needs, including course planning and career exploration services. Success coaches are located in student services areas and their contact information is available at https://www.csn.edu/advising.
Students with DECLARED majors go to https://www.csn.edu/academic-counseling for instructions for scheduling an appointment with an academic counselor.
Centers for Academic Success: Centers for Academic Success (CAS) provide quality DROP-IN ONLY academic assistance to all students enrolled in for-credit courses at CSN. Tutors are available for most general education courses and some historically challenging courses. Academic learning support includes assistance with learning strategies, Canvas, Smarthinking on-line tutoring, Microsoft Office, reading, writing, oral presentations, math, and science. CAS tutors also provide support to study groups and assistance for placement test preparation in reading, writing, and math.
CAS are open Monday through Sunday to be more accessible to all students. Hours for all locations are: Monday – Thursday 9:00 am to 6:00 pm and Friday – Sunday 11:00 am to 4:00 pm. Visit https://www.csn.edu/centers-academic-success for more details on locations and hours. Contact any of the CAS offices: Charleston Centers (702 651- 5732), North Las Vegas Learning Commons (702 651-4232), and Henderson Learning Commons (702 651- 3125).
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 the DRC offices are: Henderson: 702-651-3795, North Las Vegas: 702-651-4045 and West Charleston: 702-651-5644
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.
Note: The page you are viewing is not sanctioned by CSN.
Updated: 2 August 2019