Syllabus+Spring+2013

School of Business, University of Kansas

Spring 2013
 * IST 326 – Database Management Systems **

Mondays / Wednesdays 4:00 – 5:15 p.m. SUM 502
 * Instructor: || Neal J. Hannon (See Linkedin.com profile for more information) ||
 * Office: || Summerfield Hall 318 ||
 * Office hours: || M / W 11:00 to 1 PM; by appointment ||
 * Email: || hannon@ku.edu ||
 * Telephone: || 660-888-8526; Skype nealhannon ||


 * Course description: ** Characteristics and objectives of database management systems. Topics include: entity-relationship models, relational models; normalization to avoid modification anomalies; data manipulation languages such as SQL. We will also examine big data, cloud computing including cloud data storage.

 **Goals and objectives:** > ISBN: 978-0-13-266225-3 Jeffrey A. Hoffer, V. Ramesh, & Heikki Topi (available as E-Book, [|www.pearsonhighered.com])
 * Understand the pitfalls related to traditional files vs database.
 * Be able to perform data modeling using relational data models.
 * Be able to perform data normalization.
 * Understand and be able to perform a translation of a logical design to a physical design using the relational information models.
 * Understand and be able to implement a physical relational design using a database tool.
 * Demonstrate the ability in query development.
 * Understand recent industry trends about data management techniques
 * Textbook **
 * Title: //Modern Database Management,// 11th Edition; Pearson

<span style="font-family: 'Cambria','serif';"> **Email/Blackboard/Wikispaces/Dropbox.com**

<span style="font-family: 'Cambria','serif';"> We will use Blackboard to send out emails to the class. Please make sure you have registered with KU the email account you would like to use. (You can use your KU email or a personal email account; you just have to register with KU the one you want to use). To Update Your E-mail address, go to [|http://www.ku.edu/computing,] click on KU Online Services Registration, enter your ID # and birth date in the spaces provided, and then update your officially registered e-mail address.

<span style="font-family: 'Cambria','serif';"> We will use Wikispaces and Blackboard to keep track of administrative tasks for the class. Please go to http://ist326.wikispaces.com/ and request access to the course wiki. I will approve your request to join promptly. Contributions to the course wiki count as class participation for Assignments points.

<span style="font-family: 'Cambria','serif';"> If you do not have a Blackboard ID, please go to [|http://courseware.ku.edu] and follow the steps in the Logon Help section. (Note you must have a KU Online ID to access Blackboard.)

<span style="font-family: 'Cambria','serif';"> We will use dropbox.com for the delivery of course material, including posting of student projects and daily assignments.


 * <span style="font-family: 'Cambria','serif';">Grading **
 * **<span style="color: #000000; font-family: 'Cambria','serif';">Deliverable ** ||||  |||| **<span style="color: #000000; font-family: 'Cambria','serif';">Points ** ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Exam 1 ||||  ||  <span style="color: #000000; font-family: 'Cambria','serif';">100   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Exam 2 ||||  ||  <span style="color: #000000; font-family: 'Cambria','serif';">100   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Final Exam ||||  ||  <span style="color: #000000; font-family: 'Cambria','serif';">130   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Quizzes |||||| <span style="color: #000000; font-family: 'Cambria','serif';">130   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Assignments |||||| <span style="color: #000000; font-family: 'Cambria','serif';">220   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Project 1 |||||| <span style="color: #000000; font-family: 'Cambria','serif';">160   ||
 * <span style="color: #000000; font-family: 'Cambria','serif';">Project 2 |||||| __<span style="color: #000000; font-family: 'Cambria','serif';">160 __  ||
 * **<span style="color: #000000; font-family: 'Cambria','serif';">TOTAL POINTS ** |||||| **<span style="color: #000000; font-family: 'Cambria','serif';">1000 **  ||


 * <span style="font-family: 'Cambria','serif';">940 or more A ||
 * <span style="font-family: 'Cambria','serif';">900 A- ||
 * <span style="font-family: 'Cambria','serif';">870 B+ ||
 * <span style="font-family: 'Cambria','serif';">820 B ||
 * <span style="font-family: 'Cambria','serif';">780 B- ||
 * <span style="font-family: 'Cambria','serif';">760 C+ ||
 * <span style="font-family: 'Cambria','serif';">720 C ||
 * <span style="font-family: 'Cambria','serif';">670 C- ||
 * <span style="font-family: 'Cambria','serif';">600 D ||
 * <span style="font-family: 'Cambria','serif';">590 or less F ||

<span style="font-family: 'Cambria','serif';">**Contesting a Grade** <span style="font-family: 'Cambria','serif';">Students can question the validity of a grade for up to two weeks after the grade has been posted to Blackboard. After two weeks have passed, any grade posted to the grade-sheet is permanent.

<span style="font-family: 'Cambria','serif';"> **Exams**

<span style="font-family: 'Cambria','serif';"> Three exams will cover material from the textbook and lectures. The final exam is given during finals week. Basically, no makeup exams will be provided. If you miss one exam, you will be required to take the remaining two exams. A makeup will only be given for (1) unexpected circumstances beyond your control, documented by a signed note from a physician or equivalent. I expect all students to inform me prior to missing an examination. Lack of contacting me will forfeit your ability to re-take an exam.

<span style="font-family: 'Cambria','serif';"> **Quizzes**

<span style="font-family: 'Cambria','serif';"> There will be a quiz with each chapter per the class schedule. The quiz will consist of questions related to the reading material from the current chapter. There will be no makeup quizzes offered but the two lowest quiz scores will be dropped. **Missed quizzes count as zero.**

<span style="font-family: 'Cambria','serif';"> **Assignments**

<span style="font-family: 'Cambria','serif';"> There will be 12 or so homework assignments during the semester. You are required to submit your homework in hard copy. Please keep an electronic copy for your personal backup. Penalty for //late submission of homework//: 10% per day. Assignments can also include writing assignments and mini projects, reports on white papers, contributions to course wiki and other items as discussed in class. Preliminary breakout of assignment points is as follows:


 * <span style="font-family: 'Cambria','serif';">Homework || <span style="font-family: 'Cambria','serif';">130 ||
 * <span style="font-family: 'Cambria','serif';">White Paper Reviews || <span style="font-family: 'Cambria','serif';"> 60 ||
 * <span style="font-family: 'Cambria','serif';">Contributions to Wiki || <span style="font-family: 'Cambria','serif';"> 20 ||
 * <span style="font-family: 'Cambria','serif';">Attend KU Lectures or webinars as assigned || <span style="font-family: 'Cambria','serif';"> 10 ||


 * <span style="font-family: 'Cambria','serif';">Projects **

<span style="font-family: 'Cambria','serif';"> There will be two group projects during the semester. Students will be randomly assigned into groups. If you have a preference, please let me know early in the semester. More details on the projects will be made available during the semester. See the course http://ist326.wikispaces.com for more detail.

<span style="font-family: 'Cambria','serif';"> **Students with Special Requirements**

<span style="font-family: 'Cambria','serif';"> If you have a special requirement for which you may request accommodation in classes or on exams please let me know at least one week in advance. For international students, if you need to use an electronic dictionary during exams, please sit in the first row and let me check it before the exams


 * <span style="font-family: 'Cambria','serif';">Withdrawal Policy **

<span style="font-family: 'Cambria','serif';"> This course is offered by the School of Business. The rules of the School of Business apply to withdrawals.

<span style="font-family: 'Cambria','serif';"> **Intellectual Property of KU Course Materials**

<span style="font-family: 'Cambria','serif';"> “Course materials prepared by the instructor, together with the content of all lectures and review sessions presented by the instructor are the property of the instructor. Video and audio recording of lectures and review sessions without the consent of the instructor is prohibited. On request, the instructor will usually grant permission for students to audio tape lectures, on the condition that these audio tapes are only used as a study aid by the individual making the recording. Unless explicit permission is obtained from the instructor, recordings of lectures and review sessions may not be modified and must not be transferred or transmitted to any other person, whether or not that individual is enrolled in the course.”

<span style="font-family: 'Cambria','serif';"> **Conduct in the Classroom**

<span style="font-family: 'Cambria','serif';"> The University statement of academic misconduct includes disruption of class by a student. Leaving class early, noisiness, checking email, receiving and or answering text messages, receiving phone calls, falling asleep in class are examples of class disruption. A student’s first instance of class disruption may result in class dismissal and a 20 point deduction of his/her final point total. A class dismissal bars a student from receiving any points available during that class (including exam credit). Each subsequent incident results in class dismissal and a 100 point deduction.
 * <span style="font-family: 'Cambria','serif';">Exception: If you arrive late to a class, you must do so quietly. You will not receive a point deduction if you are quiet and courteous to your fellow students.
 * <span style="font-family: 'Cambria','serif';">WARNING: Refusal to leave class or protestations / disruptive attitude upon dismissal of the class will result in an F for the course. University Senate Rules and Regulations §§ 2.6.1 - 2.6.4. Further misconduct will result in referral for expulsion of the student. University Senate Rules and Regulations § 2.6.5.

<span style="font-family: 'Cambria','serif';"> **The School of Business Honor System**

<span style="color: #000000; font-family: 'Cambria','serif';">The School of Business Assembly has adopted an Honor System proposed by its students and faculty to promote academic integrity and has enacted the following code: “We, the faculty, instructors, and students of the School of Business pledge to fulfill our mutual responsibilities to each other and the academic community at large with honor and integrity in order to build and maintain a climate of respect and trust that will enhance our research, teaching, and learning. We will support the Honor System of the School and will not tolerate activities that undermine academic integrity.” As a student in a School of Business class, you will be protected by and expected to conduct yourself in accordance with this Honor System. For a complete description of the system, see: <span style="font-family: 'Cambria','serif';">[] <span style="color: #000000; font-family: 'Cambria','serif';">. This is required reading for students in all business courses.

<span style="font-family: 'Cambria','serif';"> With the exception of the group projects and software training, **all work in this class is to be performed on an individual basis**. This includes homework assignments, software tests, and lecture exams. If you receive help from another student, copy someone else’s work, copy material from other sources (i.e. the web or work from previous semesters) or offer help to another student in the form of answers, copied files, etc., you are violating the Honor Code, and will be reported to the Honor Council for academic misconduct. **All academic misconduct cases will be filed with the Dean of the Business School and the Provost's Office.**

<span style="font-family: 'Cambria','serif';"> The requirement of individual effort is not intended to discourage the exchange of ideas among students or to prevent students from assisting others. Some students will be more knowledgeable than others as the course begins. You are encouraged to help your classmates learn the concepts or skills needed to complete the tasks. As a guide, if your assistance helps a classmate learn a technique or course element, it's acceptable and encouraged. If your assistance is so focused or directed that it takes the form of showing a student how to accomplish a specific exercise element (in other words, "do it this way"), it enables that student to "cut corners"... obtaining the needed answer, output, etc. but likely lessening his/her learning. Such assistance is not acceptable and might constitute academic misconduct. Please ask at any time if questions arise or if you need clarification.