• SAU
• CIS
• Blackboard
• Success
• Dr. Ning Zhang

Dr. Ning Zhang

425 Ambrose Hall
zhangningsau.github.io
ZhangNing@sau.edu
563-333-6144

Office Hours

Please check my schedule .
Feel free to stop by my office.
You can also make an appointment to meet me at a specific time.

Course Description

This course introduces the role of databases and database management systems in contemporary organizations. Relational database design, implementation, and maintenance techniques are introduced through the use of Entity-Relationship diagrams, structured query language.

Objectives

Upon completion of this course students will be able to:

• Conceptually design complex database systems.
• Use Structured Query Language to
  • Implement conceptual database designs
  • Develop both simple and complex database queries
• Understand the technical and managerial issues surrounding
  • Transaction Processing
  • Concurrency
  • Web Applications and
  • Database Administration
  • Data management developments and their organizational implications.
• Write clearly and concisely

Prerequisites

CSCI 140 with a minimum grade of C

Schedule

The class meets on Tuesday and Thursday from 12:30 to 1:45PM in room 413C of Ambrose Hall. There will be no class on the following days:

• Tuesday, March 2
• Thursday, March 24

For other important dates, please check the academic calendar

Textbook

Learning MySQL: Get a Handle on Your Data

Seyed M.M. (Saied) Tahaghoghi, Hugh Williams ISBN-13: 978-0596008642 ISBN-10: 9780596008642 Amazon Bookstore

Fundamentals of Database Systems (7th Edition) (Optional)

Ramez Elmasri, Shamkant B. Navathe ISBN-13: 978-0133970777 ISBN-10: 0133970779 Amazon SAU Bookstore

Class Web Site & Blackboard

A class web site has been created for this class. A link to the class web site can be found at ZhangNingSAU.github.io. Students should check the class web site regularly throughout the semester. The Blackboard course management system (blackboard.sau.edu) will be used to post grades for this class. All other course information will be provided through the class web site.

Communicating with Me

You are welcome to ask me questions by e-mail. I will try to answer your e-mails within 12 hours from the time they are received. You should make sure to include "CSCI-360" in the subject line to help me get to your e-mail quickly. I will occasionally send e-mail announcements to all students in the class and you are responsible for all official correspondence sent to your St. Ambrose address (@sau.edu). Make sure that you check this e-mail account regularly. I would also prefer receiving e-mails from your sau account, rather than from commercial e-mail providers such as hotmail, gmail etc. I will try to call you by your preferred name. As a matter of professionalism, I’d prefer you call me "Prof. Zhang" or "Dr. Zhang". I will insist that we all start our e-mails with the recipient’s name (not "Hey" or just blank) and end our e-mails with the sender's name.

How Your Grade is Determined

Your grade for this class is determined by the following:

Midterm Exam	15%
Final Exam	25%
Quizzes	15%
Attendance	5%
Homework	40%

Midterm Exam The midterm exam will be on Thursday, March 17. This will be a closed book and open notes exam. No electronic devices may be used. All personal electronic devices must be stored under your seat during the exam. This includes calculators, cell phones, watches, and all other electronic devices. Lab computers may not be used on the exam.

Final Exam The final exam will be on Thursday, May 19, from 10:00 — 11:50 AM (double check here). The final exam will comprehensive and will include all topics covered during the semester. This will be a closed book and open notes exam. No electronic devices may be used. All personal electronic devices must be stored under your seat during the exam. This includes calculators, cell phones, watches, and all other electronic devices. Lab computers may not be used on the exam.

Quizzes There will be several quizzes throughout the semester. Each quiz will be announced in advanced. The lowest quiz will be dropped when computing your final grade for the class. Quizzes are closed book and open notes. No electronic devices may be used. All personal electronic devices must be stored under your seat during the quizzes. This includes calculators, cell phones, watches, and all other electronic devices. Lab computers may not be used on the quizzes.

Homework Assignments Each assignment will be given a date and a time when the assignment is due. You are expected to complete all assignments on time, no assignments will be accepted after the due time. Your homework must:

• Be ziped as one single archive file if there are more than 1 file
• Have the course number, homework number, your name and BeeCard number in the file name(csci360_homework1_JohnDoe(0123456).pdf for example).

Attendance Attendance is mandatory. You are expected to attend all classes and to arrive on time. I will take attendance most days, but not every day. Your attendance grade is based on those days when I take attendance.

Letter grades will be assigned based on the following:

Grade	Min Score	Grade	Min Score	Grade	Min Score	Grade	Min Score
A+	98	B+	87	C+	77	D+	67
A	93	B	83	C	73	D	63
A-	90	B-	80	C-	70	D-	60

In determining borderline grades, I reserve the right to consider perceived student initiative and class participation.

An incomplete will be given only when a student meets the requirements of the latest St. Ambrose University policies. Earning a low grade is not a valid reason for an incomplete.

Make-Up Policy

Exams Make-up exams will only be given in the event of a documented excused absence (for example, medical absences required a signed note on letterhead paper from your doctor.) You must notify me of an excused absence within 48 hours after the missed exam or no make-up will be allowed. Normally make-up exams are somewhat more difficult that the original exam.

Quizzes Quizzes cannot be made up. You must be present in class on the day of the quiz in order to receive credit for the quiz.

Homework Assignments Homework assignments cannot be turned in late. You must turn in the assignment when it is due.

Academic Integrity

You are encouraged to discuss homework and other parts of the class with other students. Such discussions about ideas are not cheating, whereas the exchange of finished, written answers is cheating. Never give finished answers to someone else or use someone else’s finished answers. Plagiarism and cheating are both considered grounds for a failing grade for that particular piece of work. Furthermore, they would weigh heavily in the final grade, possibly resulting in a failing grade for the entire course. Please see the St. Ambrose Academic Integrity Policy for further details.

Students with Disabilities

Students with disabilities who believe that they may need accommodations in this class are encouraged to contact the Accessibility Resources Center (ARC) at 333-6275 as soon as possible to better ensure that such accommodations are implemented in a timely fashion. Students may also want to visit ARC on line at: www.sau.edu/Accessibility_Resource_Center.html.

Student Succes Center

If you feel you need additional support for this class, you are encouraged to go to the Student Success Center on the first floor of Ambrose Hall or to call 333-6331 for information regarding tutoring in this class. The SSC provides free peer tutoring for most 100 and 200 level courses, writing tutorials for papers in all classes, and study strategy advice. The center staff suggests that students seek help early, although drop in and contractual tutorials are arranged throughout the semester.

How to Succeed in this Class

Attend Class Showing up on time for every class is the easiest way to improve your grade — not merely because of the credit for attendance, but also because of exposure to the content presented in class.

Level of Effort Normally a student can expect to spend about two hours of work, outside of class, for each credit unit. Thus a typical expected workload would be about six hours per week outside of class. This is not a course where students read or write essays. Most of your time will be spent experimenting with programs and studying programming language conventions and techniques to understand concepts.

Prepare for Class Read the chapter sections ahead of time for each class. When reading the material, enter and compile as many of the sample programs as possible. You may be surprised at how much this reinforces the chapter material. Reading ahead of time will make it easier to follow the lecture and it will help you decide what to ask about in class.

Do the Homework Start working on the homework problems as soon as possible. Often, a problem that stumps you one day will seem obvious a day later. You should view the homework assignments as preparation for the exams. It is imperative that you understand and complete the homework.

Manage Your Time I encourage you to develop a system to actively manage you priorities and time. You should schedule time each week to complete assignments and to complete readings in advance of class. Effective time management will help you not only in this class but also in the rest of your studies and in your career. Poor time management and late completion of assignments will be detrimental to your learning experience and will be reflected in your grade for the class.

Stay Organized Organize your class notes and save all of your graded homework assignments. These will be a great resource when studying for the exams. Also be sure to keep your computer files organized. You will write a plethora of programs for this class; it is easy or them to quickly become disorganized.

Visit Me If you have problems during the semester that affect your coursework, please see me as soon as possible so we can discuss your options for the course. If you find yourself falling behind in the class, please see me. It is likely we can work together to get you back on track.