Professor: Dr. Kate Pulling
E Mail: Use Canvas course mail
Office Hours (using Canvas Conferences): Wed: 4:00 – 6:00 PM; Thurs: 3:00 – 6: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 24 August through 13 December. Class meets virtually Mondays, 2:00 PM to 4:50 PM. Classes will be conducted through Canvas Conferences.
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.
Joel Murach, Murach’s MySQL, 2nd edition, ISBN 978-1-890774-82-0.
Allen, Gove, Jackson, Robert, Hansen, Gary, Essentials Plus of SQL: Extracting Data (e-book), ISBN 978-1-7339969-7-6.
Other Requirements: A 3-ring binder for your lecture notes and printed exercises, paper and pen or pencil for taking notes.
Resources (Software): This class will use MySQL as the platform for learning SQL. The electronic book by Allan, Jackson and Hansen includes a Database Management system. Each student has his or her own personal database sandbox. You will be able to use the MySQL dialect of SQL to create tables and populate them with data, to change the structures of tables and to query tables. You will be able to access the ebook and the data tables using a browser and the internet.
MySQL Workbench will be used to aid in the design of databases. Version 8.0 is available for download to your home computer from MySQL’s Workbench websitehttp://www.mysql.com/downloads/workbench/ ). Go to the section Other Downloads to download only Workbench (mysql-workbench-community-8.0.21-winx64.msi).
No additional resources are required.
Course Objectives: This course will provide you with a solid understanding of the relational database 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: Sept 28||70||A||360|
|Exam 2: Nov 2||70||B+||330|
|Exam 3: Nov 30||70||B||300|
|Database Design Project Due: Dec 7||100||C+||270|
|In-class Weekly Activities||90||C||240|
|Comprehensive Final Exam: Dec 7||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.
You are strongly encouraged to discuss your decisions with an academic counselor, academic adviser or success coach AND Student Financial Services, because these decisions may affect your financial aid and Satisfactory Academic Progress. Students receiving financial aid may find their awards reduced.
The Fall 2020 deadlines for the 16-week session 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 require the use of MySQL, some will also require use of MySQL Workbench.
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. For each class, have the Murach textbook, paper, binder, a writing implement available. 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.
Required Extra- or Co-curricular Activities: All activities are based on class activities, projects and exams assigned throughout the course. There are no required extra activities for this class.
Additional Fees: There are no additional fees for this course.
(Complete reading assignment BEFORE class)
|1||Aug 24||Introduction (Murach: Ch. 1; Allen, et al.: Ch. 1)|
|2||Aug 31||Single-table queries (Murach: Ch. 3; Allen, et al.: Ch. 2)|
|3||Sept 7||Labor Day holiday, class does not meet.|
|4||Sept 14||Single-table queries, continued;
Multi-table queries (Murach: Ch. 4; Allen, et al.: Ch. 3)
|5||Sept 21||Multi-table queries, continued|
|6||Sept 28||Exam 1|
|7||Oct 5||Insert, update, delete data (Murach: Ch. 5; Allen, et al.: Ch. 6)|
|8||Oct 12||Database design (Murach: Ch. 10)|
|9||Oct 19||MySQL Workbench, Data types (Murach: Ch. 8)|
|10||Oct 26||Create databases, table, indexes (Ch. 11)|
|11||Nov 2||Exam 2|
|12||Nov 9||Summary queries (Murach: Ch. 6; Allen et al.: Ch. 4);
Database Design Project distributed.
|13||Nov 16||Subqueries (Murach: Ch. 7; Allen, et al.: Ch. 5)|
|14||Nov 23||Functions (Murach: Ch. 9)|
|15||Nov 30||Exam 3|
|16||Dec 7||Comprehensive Final Exam
Database Design Project Due
Disclaimer: This syllabus is subject to change as deemed appropriate by the instructor and with advanced notification.
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.
CIT/CS/IS101/IS115 Software Lab: The lab are a service of the CIT Department to provide specialized help for your CIT, CS or IS classes. The lab will open on August 31, 2020. For location/date/time information, please visit the CIT-Information webpagehttps://at.csn.edu/cit-information. Click on "Networking and Software Lab Hours."
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.
CSN Libraries: The library provides support for students completing assignments that require research and the use of information. Librarians are available to students for one-on-one assistance locating and citing quality information either on-line on-line at https://library.csn.edu/ask/ or at any of the campus libraries. To find more information, go to the CSN Libraries’ websitewebsite https://library.csn.edu/.
“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://library.csn.edu/, 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.
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:
Students’ Rights and Responsibilities: When you choose to become a student at CSN, you accept the rights and responsibilities of membership in CSN’s academic and social community. You can find policies covering students, such as the Student Conduct, Students’ Right to Know, Students’ Academic Integrity, and Disruptive and Abusive Student in the following locations:
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.
CSN Student Email: All students enrolled at CSN have a CSN Student Email account. Beginning February 1, 2020, all information from the college will be sent to your CSN-issued student email address (enrollment information, financial aid information, cashier information, college events, etc.). It is extremely important that you check your student email daily. You can access your student email through GoCSNhttps://www.csn.edu/gocsnlogin.
Once you validate your student email address you will have access to Microsoft Office 365 for up to five devices and 1TB of OneDrive storage. CSN email has more information, including tutorials for Office 365 apps.
Public Health Directives (COVID-19) Students must follow all active CSN public health directives while enrolled in this class. Properly worn face coverings are mandatory for all faculty and students in the classroom as well as on campus. Review CSN’s public health directives. Review CSN’s public health directives at https://at.csn.edu/covid-19. Students who do not comply with these directives will be asked to leave the classroom. Refusal to follow the guidelines may result in further disciplinary action according to the CSN Student Conduct CodeCSN Student Conduct Code https://www.csn.edu/sites/default/files/documents/student_conduct_code_policy_1.pdf, including being dropped from the course.
Counseling & Retention Services: Counselors
For more information about Counseling & Retention Services, please visit the Counseling website https://www.csn.edu/counselingdepartment.
Early Alert Referral Program: This is a referral program to connect students with college resources when assistance is needed to achieve success. Referrals may be initiated by faculty and staff, as well by students themselves, through MyCoyotePLAN. After a referral is submitted, students will receive an email notification and will be contacted by the department to which they were referred to offer assistance.
Centers for Academic Success: Centers for Academic Success (CAS) provide quality DROP-IN academic assistance to all students enrolled in for-credit courses at CSN. CAS Tutors are available on-line through Smarthinking, which is accessed in the Canvas on-line learning management system. View a tutorial video on how to access CSN Tutors/Learning Assistants on-line: How to Access CSN Tutors in Smarthinking How to Access CSN Tutors in Smarthinking: https://youtu.be/uJB9po-mRFk .
You may choose “Submit a Question” if you don’t have time for a live session. A Tutor responds to offline questions within 24 hours. Contact us at one of campus phone numbers, and we will assist you with accessing all learning support.
Academic learning support includes assistance with
CAS Tutors also provide support in facilitating study groups.
You may experience embedded learning assistance in one of your first-year courses. Professors and CAS Staff will make you aware of how to access services as part of your course curriculum.
CAS is open Monday through Sunday to be more accessible to all students – Monday – Thursday 9:00 a.m. to 6:00 p.m. and Friday – Sunday 11:00 a.m. to 4:00 p.m. Smarthinking tutors are available 24/7. You may visit our webpageour webpagehttps://www.csn.edu/centers-academic-success for more details, or contact us at one of our offices during our regular operational hours:
*Students will receive notification as on-ground tutoring services resume.
Disability Resource Center: The College of Southern Nevada is committed to making physical facilities and instructional programs accessible to students with disabilities. If you have a disability that may have some impact on your work in this class and for which you may require accommodations, please visit the Disability Resource Center (DRC) so that such accommodations can be considered. All discussions will remain confidential.
The Disability Resource Center (DRC) has offices at all three campus locations as the focal point for coordination of services for students with disabilities. If you have a physical, emotional, or mental disability that “substantially limits one or more major life activities (including walking, seeing, hearing, speaking, breathing, learning and working),” and will require accommodation in this class, please contact the DRC at
Students that receive accommodation letters, please meet with me to discuss the provisions of those accommodations as soon as possible.
Important Dates in the College Calendar:
Safety: This class does not have an experiment lab and, therefore, we will not be concerned about following specific safety strategies.
Excess Credit Fee Information: Information about the Excess Credit Fee may be found hereat https://www.csn.edu/excess-credit-information.
Title IX Resources: Information is available hereat https://www.csn.edu/institutional-equity.
Note: The page you are viewing is not sanctioned by CSN.
Updated: 17 August 2020