home

Youngstown State University Department of Computer Science & Information Systems CSIS 3722 A Guide to SQL 8e Spring 2013 Syllabus toc

** General Course Information **
**Instructor:** Trevor Watkins **Office:** 108 **Office Hours:** T, TH 6:30 - 7:30pm, Skype, or by appointment **Phone:** 330-301-7172 **E-mail:** tuwatkins@gmail.com **Web Sites:** [|www.engrade.com] csis3722.wikispaces.com

**Prerequisites:** CSIS 1590

**Textbook:** Pratt & Last, A Guide to SQL, Eighth Edition, Cengage Learning, 2009,

ISBN 0324597681

Course Objectives
The objective of this course is to provide an understanding of the basic structure, design, development, implementation, and modification of databases for use in management information systems and a comprehensive introduction to the SQL language. This course not only covers the syntax of SQL, but also shows how it can be used in Oracle Database 10g Express to create and maintain a database and retrieve information from it. It also provides an introduction to relational database concepts. In addition to explaining concepts, the course uses a variety of assignments and exercises to reinforce the material in each chapter.

Engrade and Wiki
Supplementary information for the course is available at the Wiki. The Wiki contains class notes, PowerPoint slides, class announcements, the course syllabus, test dates, and other information for the course. Answers to the end of chapter review questions, student assignment files, and hands-on projects also can be obtained from the Wiki. Your homework, projects, etc. will be uploaded into Engrade.

E-Mail
All students are requested to obtain an e-mail account. If you have any questions about the course or need assistance, please contact me in person or by telephone during office hours or by e-mail at any time.

Attendance Policy: Attendance is required and expected if you are to have success in this
class, however, I do not take attendance. If you miss a day, it is up to you to get the information from another student that was there doing that day.

**Preparation and Participation:** This course involves significant in-class discussion of the reading and related consulting problems. Each student is expected to possess the required textbook, to have completed all reading prior to class, and to have thought about the issues. Each student is expected to have reflected on the meaning of the reading and have attempted to apply the knowledge and be ready to discuss them during the class period.

**Cell Phone Policy:** To avoid disruption to the class, all cell phones, pagers, and other electronic communications devices must be turned off or silenced while class is in session.

Academic Honesty: Students are reminded of the University’s policy on Academic Honesty. This provides, in part as follows: An instructor may give a failing grade and/or refer for disciplinary action any student who participates in acts of academic dishonesty. The failing grade may be either for the test or paper on which the cheating or plagiarism occurred, or for the entire course.

Disabilities:In accordance with University procedures, if you have a documented disability and require accommodation to obtain equal access in this course, please contact me privately to discuss your specific needs. You must be registered with CSP Disability Services, located in Wick House, and provide a letter of accommodation to verify your disability. You can contact CSP Disability Services at 330-941-1372.

Assignments, Projects & Examinations: The student is responsible for all assigned readings and class lectures. Assignments will be due at the beginning of class on the dates established. Assignments must be handed in on time. No homework or labs will be accepted after it is due. Projects will be accepted late, but at a penalty of 10% of the project for each calendar week late. There will be two equally weighted exams. All the exams will be over all material covered up to that point. Material for exams will be drawn from class discussions, assigned readings and problems. No makeup tests will be given…unless….

Grading and Evaluation Criteria


 * 40% of the grade is based on a midterm and final examination. Both examinations are cumulative and given in a multiple-choice format. An in-class review will be held prior to each examination.


 * 30% of the grade is based on completing the end of chapter case project assignments. An electronic version of the case project assignments can be downloaded from the course’s Wiki.


 * 30% of the grade is based on answering the review questions, and in class assignments.

Projects: Projects are to be done individually. You are free to give general help to others in the course, however you are not allow to work together on the projects unless otherwise instructed to do so. Turning in identical work (or work that is substantially similar) will result in a zero grade for the assignment. Multiple offenses will result in a zero for the course.

Schedule Subject to Change: This schedule is tentative and subject to change. Revised schedules will be distributed as appropriate.

**16-Week Course Outline**
To be posted on Wiki ||  ||   || SQL Commands/Syntax || Chapter 1 ||  ||   || Final Project given || Final Exam is 05/06/2013 ||  ||   || Final Project due ||
 * **Week Starting** || **Topics** || **Chapter****Readings** || **Hands-On Projects****Notebook** || **Exams** ||
 * **1 1/14** || Introduction to class, syllabus, etc. ||  ||   ||   ||
 * **2 1/21** || Introduction to Databases: Concepts, Database types, SQL Versions, Commands/Syntax || <span style="font-family: Times New Roman,Times New Roman,serif;">Handouts and
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**3 1/28** || <span style="font-family: Times New Roman,Times New Roman,serif;">Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**4 2/04** || <span style="font-family: Times New Roman,Times New Roman,serif;">Database Design Fundamentals || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 2 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapters 1, 2 ||  ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**5 2/11** || <span style="font-family: Times New Roman,Times New Roman,serif;">An Introduction to SQL || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 3 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**6 2/18** || <span style="font-family: Times New Roman,Times New Roman,serif;">An Introduction to SQL || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 3 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 3 ||  ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**7 2/25** || <span style="font-family: Times New Roman,Times New Roman,serif;">Single-Table Queries || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 4 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**8 3/04** || <span style="font-family: Times New Roman,Times New Roman,serif;">Single-Table Queries || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 4 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 4 || <span style="font-family: Times New Roman,Times New Roman,serif;">Midterm Exam
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**9 3/11** || <span style="font-family: Times New Roman,Times New Roman,serif;">Spring Break || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 5 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**10 3/18** || <span style="font-family: Times New Roman,Times New Roman,serif;">Multiple-Table Queries || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 5 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 5 ||  ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**11 3/25** || <span style="font-family: Times New Roman,Times New Roman,serif;">Updating Data || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 6 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**12 4/1** || <span style="font-family: Times New Roman,Times New Roman,serif;">Updating Data || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 6 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 6 ||  ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**13 4/8** || <span style="font-family: Times New Roman,Times New Roman,serif;">Database Administration || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 7 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**14 4/15** || <span style="font-family: Times New Roman,Times New Roman,serif;">Database Administration || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 7 || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 7 ||  ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**15 4/22** || <span style="font-family: Times New Roman,Times New Roman,serif;">SQL Functions and Procedures || <span style="font-family: Times New Roman,Times New Roman,serif;">Chapter 8 ||  ||   ||
 * <span style="display: block; font-family: 'times new roman','times new roman',serif; text-align: center;">**16 4/29** || <span style="font-family: Times New Roman,Times New Roman,serif;">Final Week of class: Preparation for Final Exam, Finish Final Project Due 05/06/2013
 * ||  ||   ||   || <span style="font-family: Times New Roman,Times New Roman,serif;">Final Exam ||