MIS 350 - Database Management - Fall 2016

Department of Mathematics and Information Technology

Dr. Angela Berardinelli

Important Dates for Fall 2016

  • Thursday, August 25: First day of class
  • Wednesday, August 31: Add/drop deadline
  • Thursday, September 15: Last day to conduct Project Phase 1 interview
  • Thursday, September 22: No class (Mass of the Holy Spirit)
  • Monday, September 26: Project Phase 1 Due
  • Thursday, September 29: No class (Professor Out of Town)
  • Thursday, October 13: Mid-semester break (no class)
  • Tuesday, October 18: Midterm Exam
  • Friday, October 21: Project Phase 2 Due
  • Tuesday, November 1: Advising Day (no class)
  • Monday, November 14: Project Phase 3 Due
  • Friday, November 18: Last day to withdraw
  • Thursday, November 24: Thanksgiving Day (no class)
  • Thursday, December 8: Last day of class
  • Saturday, December 10: Project Phase 4 Due
  • Tuesday, December 13: Final Exam 10:30AM-12:30PM

Course Description

This is a study of the concepts, procedures, design, implementation, and maintenance of a database management system. Topics include normalization, database design, entity-relationship modeling, performance measures, data security, concurence, integrity, and Structured Query Language. 3 credits.

Prerequisites: MIS 126.

Resources

Required Textbook: Custom Pearson Textbook available in the Mercyhurst Bookstore.

Or, instead of the required textbook: you may purchase/rent the components of the custom textbook separately. If you choose to do this, you must purchase/rent BOTH of the following:

  • Database Concepts, 7th Edition, by David Kroenke and David Auer
  • Database Processing: Fundamentals, Design, and Implmentation, 14th edition, by David Kroenke and David Auer.

Software: We will be building and querying databases using MySQL. All associated software is downloadable for free. More specific information will be provided in class and on Moodle.

Office Hours: The perfect opportunity to ask general questions about course material, specific questions about homework problems or in-class examples, questions about your grade, questions about majoring in math or information technology, etc. My office location and office hour schedule are on my home page. You can also e-mail me to set up an appointment outside of office hours if that suits your schedule better.

Grading Information

If you have a weighted average of at least... You will earn a(n):
93% A
88% B+
82% B
77% C+
70% C
65% D+
60% D

Your final course grade will be the weighted average of four components: In-Class Quizzes and Exercises (34%), Course Project (36%), Midterm Exam (15%), and Final Exam (15%).

There will be no makeup exams. Please ensure you will be in class on exam days.

Assigned Homework Problems

  • Chapter 1 Review Questions 6, 7, 8, 13, 22-24
  • Chapter 2 Review Questions 2, 4, 5, 8, 10, 12, 13, 15, 18, 19, 22
  • Appendix B Review Questions B14, B15, B17, B18, B19
  • Chapter 3
    • Review Questions 1-3, 4-9, 12-16
    • Washington State Patrol Case Questions
  • Normalization
    • Chapter 2 Review Questions 23, 25, 26
    • Chapter 2 Exercises 41 and 43 (Note: For exercise 41, use BCNF instead of 4NF.)
    • Chapter 4 Review Questions 11, 13, 38, 50
    • Chapter 4 Regional Labs Case Questions
  • Chapter 5
    • Review Questions 4-6, 9, 11, 14, 15, 19-21
    • Exercises 36, 37
    • Washington State Patrol Case Questions
  • Chapter 6 Review Questions 3, 17-20, 23-25, 30, 32, 36, 40, 41, 47
  • Chapter 7
    • Read the information in purple and blue on page 391 before continuing with the assigned homework.
    • Review Questions 7-9, 14, 17, 22, 23, 31, 38
  • Chapter 8 Review Questions 10, 14, 15, 25, 26, 28-32, 36-39
  • Chapter 9 Review Questions 7, 8, 10, 17, 38, 44