MIS 322

Database Systems II

Winter 2007




Edward J. Williams


B-14 FCS

Office Phone


Department Phone


Day Phone

(313)-441-4460 x1031





Web Site


Course Schedule

12:00 noon-2:40 P.M. Tuesday

Office Hours

3:00pm-6:00pm Tuesdays; 5pm-6pm Thursdays


E-Mail Address:  williame@umich.edu, the preferred method of contact, and checked daily except when I am attending a conference.  Questions explicitly pertinent to the course material and hence of likely interest to the entire class (e.g., how to undertake a certain task in Oracle®) should be posted on the VLT web site Question Board).  More individual questions or issues (e.g., notifying me of a problem such as illness, business travel, or bereavement) should be handled via electronic mail or a message to my daytime telephone number.


Course Description


This course examines the processes and tools used to develop and administer database systems in business.  Database systems used to support both transaction processing and decision-making in organizations are studied.  The conceptual, logical, and physical designs studied in Database Systems I serve as the blueprints for the database systems developed in Database Systems II.  A class project involving the development of a database using a client/server database management system is performed.  Topics include database development, client/server databases, concurrency control, database security, administration of database privileges, complex data retrieval commands, and database programming.  Students will be prepared to pass professional database certification exams.  Students are strongly encouraged to enroll in this course the semester after Database Systems I is completed.  Students who do not immediately enroll in Database Systems II should review the material on conceptual database design, logical database design, and physical database design from Database Systems I before the first day of class.  All students should plan to spend a minimum of three hours per week outside of class working in on-campus computer labs.


Prerequisite:  (MIS 301 or MIS 210) and MIS 321


MIS 322 contributes to the following BBA Desired Student Outcomes:

Have a basic knowledge of economics, accounting finance, marketing, workforce management and organizational behavior, operations management, information systems, statistics and decision analysis, strategy development and implementation and the legal environment of business.

Communicate effectively verbally and in writing.  (Writing a required term project and presenting results orally in class.)

Develop effective interpersonal skills that will enable them to work with other individuals and within teams as either leaders or participants.  (Homework assignments, plus the term project, will be done in self-selected teams.)

Know how to gather, use, and critically evaluate electronic and other information.  (Design of an Access® database to use and analyze business data.  Preparing the term paper will require interviewing businesspeople on their data-processing needs within an overall business context.)

Use critical thinking skills to solve real or hypothetical business problems.  (Design of relational databases to analyze and mine business data.)

Develop a knowledge and appreciation of ethical principles as applied to business.  (Students are introduced to ethical issues and responsible action relative to the design, implementation, and usage of relational databases.)


Course Goals and Objectives


Students in this course will learn about client/server databases using a database management software package called Oracle.  Students will study the database language SQL in depth.


During the first part of the course, we will review the principles and tools of conceptual, logical, and physical database design.  We will then study the database manipulation language components of SQL in depth.  Topics covered include the SELECT statement, the WHERE statement, the ORDER BY statement, JOINs, single-row functions, group functions, and subqueries.


During the second part of the course we will learn how to take a design for a database and implement it in Oracle using the database definition language components of SQL.  Topics include table creation and management, constraints, and data manipulation. 


During the third part of the course we will learn about views, sequences, and indexes.


By the end of the class, students should understand most of the material needed to pass an Oracle certification exam.


Communication skills will be emphasized in this course.  You will verbally present and defend your ideas during each class session.  A group project will encourage you to practice your written and oral communication skills.


Skills needed to work effectively in small teams will also be emphasized in this course.  In addition to the group project, you will work in ad-hoc groups to complete in-class exercises.



Required Course Materials


1.                  Hoffer, J.A., Prescott, M.B, and McFadden, F.R.  2007.  Modern Database Management, 8th Edition.  Upper Saddle River, New Jersey:  Prentice Hall.

2.                  Morris-Murphy, L. L.  2003.  Oracle 9i:  SQL with an Introduction to PL/SQL.   Cambridge, Massachusetts:  Course Technology.


Be sure to purchase both books during the first week of the semester.  The bookstore will return books that they do not sell early in the term.


Recommended reference:

            Elmasri, Ramez, and Shamkant B. Navathe.  2007.  Fundamentals of Database Systems, 5th ed.  Boston, Massachusetts:  Addison-Wesley.



Course Web Site


Lecture slides and other course materials are available on the course web site under VLT (Virtual Learning Technology).


Course Format


The class is designed to provide a forum where issues related to the development and use of database systems are discussed.  Such a forum requires that each student be prepared to be an active participant in the discussion.


The course material will be discussed in both large and small groups.  A variety of small group exercises will occur during class sessions to provide the opportunity for all participants to actively assimilate the course material.  Instruction related to the development of team building skills will be provided to ensure that small group exercises provide an opportunity for all students to learn the course material.


Students will demonstrate their understanding of the course material in three ways:  class participation, online quizzes, and a group project.


1.  Class Participation.  Some of the factors that will be considered in the evaluation of class participation include presence in class, preparation for class, enthusiastic and thoughtful participation in class activities, and persistence while working on class activities.  Participation that helps other people learn the class material is especially valued and rewarded.  The general description of what constitutes A, B, C, D, and E work in the class will be applied to the evaluation of class participation.  (Please see the section of the syllabus titled “Grading” for more information.)


Helpful comments and questions are always welcome.  However, please do not feel that you need to frequently interrupt the lecture portion of the class sessions in order to receive a good mark for class participation.  If you must miss part or all of a class, it is important to avoid asking questions about material that has already been covered once you return to class.


2.  Team Homeworks.  Homework will be assigned approximately weekly and is to be done in teams of your choice.


3.  Group Project.  The group project allows you to demonstrate that you have synthesized the materials covered in the course.  The group project is an opportunity for you to design, implement, and use a database system using Oracle.


Groups will present their systems in a written paper and in a presentation to the class.  The class presentation should highlight those aspects of the system likely to be of greatest interest to the class.


Students will self-select the project groups early in the semester.


An individual’s grade on the group project will be a function of the quality of the project, a set of peer reviews, and an individual project journal.  Each project will be assigned a grade based on the quality of the work.  This grade will be the maximum grade that group members may receive on the project.  A set of peer reviews and an individual project journal will be used to evaluate each individual’s contribution to the group project.  An individual’s grade on the group project may be lowered if these materials indicate problems with the quantity or quality of the individual’s work on the project.


Peer Reviews.  Each member of the group will write a peer review paper in which he or she describes and evaluates the contribution of each member of the project group.


Individual Project Journals.  Each member of the group will keep an individual project journal throughout the course.  The following are guidelines for the project journal.


1.      Make a journal entry whenever you work on the project individually or in the group.  What was accomplished?  What did you do?  What did your teammates do?

2.      At least once a week, make an entry reflecting on your experience working on the project.  What is going well?  What is not going well?  What do you like about the project?  What do you dislike?  How might you participate more effectively as a member of the group?

3.      At least once a week, make an entry about a technical problem that your group faced.  What was the nature of the problem?  What process was used to solve the problem?  What was the solution?  These entries will probably address design problems in the early stages of the project and system problems in the later stages of the project?  Your objective in these entries is to demonstrate that you have an excellent understanding of the technical details of your group’s project work. 

4.      Please be sure to date each journal entry.

5.      The individual journal may be typed or handwritten (if your handwriting is easy to read).


4.  Exams.  There will be two examinations, a midterm and a final.  The examinations will consist of short-answer essay questions and problems.  I will announce examination coverage before each examination and post a review-sheet guideline on VLT.




Your performance will be evaluated in four areas:  class participation, homework assignments, a group project, and an exam.  Each of these will be weighted as follows:


Class Participation




Group Project


Midterm Examination


Final Examination



The letter grading system (A, B, C, D, E) used in the School of Management will be used in this course.  The following interpretation of this grading scale will be used. 


            A = Excellent work.  (Assigned work is clearly-presented, thoughtful, insightful, and creative.  The student has demonstrated that the course material has been thoroughly learned.  The student has demonstrated the creative application of the course material to novel situations.)


            B = Good work.  (Assigned work is clearly-presented and thoughtful.  The student has clearly demonstrated that the course material has been learned.)


            C = Acceptable work.  (Assigned work is completed and course standards are met.  The student has clearly demonstrated that much of the course material has been learned.)


            D = Marginally acceptable work.  (Most of the assigned work is completed in a way that meets the course standards or all of the assigned work is completed in a way that almost meets the course standards.  The student has clearly demonstrated that some of the course material has been learned.)


            E = Unacceptable work.  (The student has not clearly demonstrated that the course material has been learned.)


Grades of + and - may be used to recognize performance slightly different than these interpretations.


All of your work in this course will be compared against an absolute standard.  Your work will in no way be compared to that of your peers when grades are assigned.  The objective of this approach is to encourage all students to concentrate on both their individual learning and the learning of their classmates.


Course Administration


Accommodations for Students with Disabilities.  The University will make reasonable accommodations for persons with documented disabilities.  Students need to register with Disability Resource Services every semester they are taking classes.  DRS is located in Counseling and Support Services, 2157 University Center (593-5430).  To be assured of having services when they are needed, students should register no later than three weeks after the first day of classes. 


Course Attendance.  An underlying assumption of this course is that students will attend and actively participate in all classes.  Please plan to arrive on time and remain in class until the end of the class session.


Late Assignments.  A ten percent penalty will be imposed for every day that the group project is late.  Group projects turned in more than a week late will receive no credit.  I retain the right to make ad-hoc adjustments to these rules in the face of circumstances I deem sufficiently extenuating.


Examination Procedures.  Students should plan to remain in the classroom until they have completed their examinations.  Students who arrive late will be permitted to take the examination provided no one has completed the examination and left the examination room.  However, such a student will be given no extra time.  Students should refrain from communicating with other people during the examination.  Electronic devices (e.g., cellular phones, calculators) known to be useful for illicit collaboration during examinations must be inaccessible during examinations.  Additional procedures (e.g., seat assignments) may be added at any time in response to perceived threats to the integrity of the examinations.


Make-Up Examinations.  If a student is unable to take the midterm examination because of a severe medical problem, he or she should submit documentation of the problem.  If the medical documentation is accepted, a comprehensive make-up examination will be offered immediately following the second examination.  The comprehensive make-up examination will include items from all of the course material.  There is no guarantee that the difficulty of the make-up examination will be identical to the difficulty of the first examination.


If a student is unable to take the final examination because of a severe medical problem, he or she should submit documentation of the problem.  If the medical documentation is accepted, the student will be offered the opportunity to take an “X” in the course.  A make-up examination will be offered at a time mutually convenient to the professor and the student, subject to the University proviso that “X” grades must be resolved quickly.  There is no guarantee that the difficulty of the make-up examination will be identical to the difficulty of the final examination.


Statement of Academic Integrity.  The University of Michigan-Dearborn values academic honesty and integrity.  Each student has a responsibility to understand, accept, and comply with the University’s standards of academic conduct as set forth by the Code of Academic Conduct, as well as policies established by the schools and colleges.  Cheating, collusion, misconduct, fabrication, and plagiarism are considered serious offenses.  Violations will not be tolerated and may result in penalties up to and including expulsion from the University.  Here are links to UMD and SOM policies on academic integrity.


Grade Changes.  Once grades are submitted to the registrar, a grade change is permitted only to correct an error in computing or recording the grade.  There are no opportunities to redo work or to do extra work in order to receive a higher grade.  Also, a student’s work cannot be reevaluated after the grades for the class have been submitted.


A great deal of care is taken in calculating final grades.  Mistakes are, therefore, very rare.  However, if you believe a mistake may have been made, please request that the calculation of your final grade be rechecked.  Please do not request a grade change for any other reason.  Please also recognize that certain elements of the final grade in any course are subjective.  It is normal to believe that your course performance is better than or worse than your instructor’s evaluation of your work.    


Cancelled Classes.  The university may occasionally close because of inclement weather.  If a class session is cancelled because of a university closure, all assignments, activities, and exams will be postponed until the next regular meeting of the class.  The University of Michigan-Dearborn maintains an “Inclement Weather Campus Closure Information Line” at 313-436-9157.


Class Schedule and Assignments


The readings listed for each class should be completed prior to the beginning of that class session.  Homeworks must be completed by the beginning of class on the due date.







Class 1

(January 9)

Introduction to the course.


Recapitulation of MIS 321

Class 2

(January 16)

Review of database design.

H – Review chapters 3, 4, 5, and 6.


Class 3

(January 23)

SELECT Statements.

MM – Chapter 1 and 2, Appendix A.

H – pages 308ff.

Class 4

(January 30)


MM – Chapter 3 and 4.

H – page 310ff, 319ff, and 334ff.

Class 5

(February 6)

Single-row functions.  Group functions.

MM – Chapter 5 and 6.

H – pages 352-353

Class 6

(February 13)

Subqueries.  Table creation and management.

MM – Chapter 7 and 8.

H – pages 340ff

Class 7

(February 20)




Class 8

(March 6)

Midterm examination



Class 9

(March 13)

Constraints.  Data manipulation.

MM – Chapter 9 and 10.

“An ounce of prevention is worth a pound of cure.”

Class 10

(March 20)

Project workshop.



Class 11

(March 27)

Views.  Additional database objects.

MM – Chapter 11 and 12

Views, sequences, indexes, and synonyms.

Class 12

(April 3)

Project workshop.



Class 13

(April 10)

Project presentations.


Group Project due.

Peer Reviews due.

Project Journals due.

Class 14

(April 17)




(April 24 3pm)

Final examination





(1)     H = Hoffer, Prescott, and McFadden; MM = Morris-Murphy

(2)     Please note that the class schedule is subject to change.  Changes will be announced in class and posted to the course website.