MIS415 Business Database Systems

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

Instructor: Arijit Sengupta (Jit)

Office: Rike 255 / Rike 291
Tel. no: 937-775-2895 x 2115.

Office Hours: Wed and Thursdays 4-5:30 PM and by appointment. I will also announce special office hours and help sessions when deliverables are due which would be held either at my office or online..

GA: Nicole Seissinger

Classes:

Section            Instructor        Meeting Times           Room
-------           ----------------  --------------------    -------
MIS415-01(22662)   Sengupta          W 6:05PM-9:25PM        Rike 072

Texts

T. Connolly, C. Begg, R. Holowczak; Business Database Systems; Addison Wesley/Pearson Education; ISBN 978-1-4058-7437-3.

R. Earp, S. Bagui; Learning SQL - A Step-by-Step Guide using Oracle; Addison-Wesley; ISBN 0-201-77363-5

Sara Baase; A Gift of Fire, Third Edition; Prentice Hall, NJ; ISBN 0136009488 (Chapter 2 only)

References

You can (and should) use other books and online material to supplement the textbook 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 own your own computer, you are welcome to download and install a copy of Oracle 10g personal edition, which will be enough for all the work that we will do in class, and at the same time allow you to learn some of the database administration skills that we will only touch in the class. However, we will provide you an account in a central Oracle server through the Wright State University central Unix machine unixapps1. The details on this account will be given to you within the first two weeks. We will spend one lab working on this Unix database account, getting everyone familiar with the accounts. For the purpose of the group project, you may need other software for developing Java applications, some of the following may be useful:

1. Oracle 10g - account will be provided to you free of cost that you can use and connect to from labs in the University or from home. To connect to Oracle, click on the Apex Link in Pilot.
2. MySQL - to get an alternative view of an open source database (strangely enough, now with Sun acquiring MySQL and Oracle acquiring Sun, MySQL also belongs to Oracle - it will be interesting to see where it goes). You will need to get MySQL Community server version 5.1 (5.1.45 at the time of preparing this syllabus) and GUI Workbench 5.2 (5.2.16 beta at the time of writing this syllabus - do not get version 5.1 - it does not have SQL development tools). Everything can be downloaded from http://www.mysql.com/
3. Dia - a diagramming tool for Windows and Unix. Available from http://www.gnome.org/projects/dia/
4. Microsoft Visio 2003 or later - includes some facilities for creating ER diagrams. Find more information from http://office.microsoft.com/en-us/FX010857981033.aspx
5. A Java EE container - we are going to use Tomcat - a Tomcat environment will be provided for you, but if you wish to download it for your own use, you can do so from http://tomcat.apache.org/
6. An editor for editing and uploading JSP files. In the lab, we are going to use Adobe Dreamweaver CS3. You can also use NetBeans if you are looking for something available for free. Netbeans is available from http://www.netbeans.org/
7. Any other software that you have used or come across that would help in the development work of this course.