MIS 710 Database Management

* Home  * Description  * Overview  * Schedule *
* Projects  * Grades  * discussions *


Course: BUS MIS710 (4.0 CR)
Quarter:Winter 2006 Title: Database Management

Instructor: Arijit Sengupta (Jit)

Office: Rike 254A
Tel. no: 937-775-2895 .

Office Hours: Thursdays 1-4 PM and by appointment. I will also announce special office hours when deliverables are due which would be held either at my office or in the Union cafetaria.

GA: TBA

Classes:

Section      Instructor        Meeting Times           Room
-------      ----------------  --------------------    -------
MIS710-01     Sengupta         T 6:05PM-9:25PM         067 Rike

Texts

Required:

Database System Concepts, Fifth Edition. A. Silberschatz, H. Korth and S. Sudarshan. McGraw Hill Higher Education, ISBN 0-07-295886-3.

Recommended Reference:

Data Modeling Essentials, Third Edition. G. Simsion, G. Witt. Morgan Kaufmann Publishers, ISBN 0-12-644551-6

Other References

You can (and should) use other books and online material to supplement the textbooks whenever necessary. Primarily since this course is not simply about databases, but about the effective use of databases in business, and development of database applications. As such, I will be using focusing part of the class on the process of developing database applications using Java, JDBC and JSP. I will not be teaching you how to write code in Java, but expect that you already know how to do it. If you do not know Java, you may want to pick up a Java book and pick up as much as you can by mid-quarter when the programming project will start.

Software

The primary software that we will use in this course is Oracle. If you have your own computer, I would expect you to install the personal edition of Oracle 10g - I will show part of the process in class. If you do not have access to your own computer, please see me about getting an account on a central unix server which has Oracle installed (unfortunately its only Oracle 8i) and you can use that account for this class. However, I strongly recommend installing Oracle yourself, which will give you a good idea about some of the administration aspects that we will learn in this class. You may need some other software for developing the project application, some of the following may be useful:

  1. The standard Java development environment from Sun. Available for free download from http://www.java.sun.com
  2. Textpad is a powerful text editor for windows - nicely menu driven and has support for developing Java programs. You will need the Java development environment from Sun (See item #1). Available for download from http://www.textpad.com
  3. Emacs - a powerful text editor - available as a free (GPL) download from http://ftp.gnu.org/gnu/windows/emacs/. Also needs the Java SDK.
  4. Borland Jbuilder 2005 (The foundation version is available for free download from http://www.borland.com/downloads/download_jbuilder.html) - a powerful IDE for Java - almost too powerful for this class.
  5. Any other software that you have used or come across that would help in the development work of this course.