IS 623 - Database Management
CRN 3654-101
Semester Spring - 2002
Dates Wednesdays, January 16 through May 8
Location/Times 4:00 to 6:20 PM, GH Room 206A – Huntington

 

Texts and Study Materials
Required Text(s)
David M. Kroenke, Database Processing: Fundamentals, Design & Implementation (8th Ed), Prentice Hall

 

Instructor
Name John R. Biros
Office GC 331
100 Angus E Peyton Drive
South Charleston, WV 25303
Office Hours By Appointment
Phone 304-746-1941
E-mail jbiros@marshall.edu

 

Course Description
Review of information structures and of relationships among data elements and objects. Relational database theory; design and organization of databases, retrieval structures, and query mechanisms.
Credits 3 semester hours
Prerequisites IS-622 or consent

 

Course Discussion
This course is directed towards advanced students in the Information Systems program. It assumes the student is familiar with the basic concepts of information systems, has a firm grasp of the concepts covered in Information Structures, has a good programming background, and understands file structures and file processing techniques. 

The course is designed to cover the concepts of designing a database, normalizing the data structures, implementing the database, and being able to retrieve the data with effective database queries.

While the course is a theory course designed to cover the concepts of database management, there will be a significant number of projects that will require hands-on experience. For the personal databases the class will use Microsoft Access. For larger databases the class will use Microsoft SQL Server v7.0. In addition there may be some hands-on use of an Oracle database.

Each student is expected to select a system to analyze, document, and implement during the course of this semester. This system will be presented to the rest of the class as part of the final exam.

Attendance at the class is not mandatory, but highly recommended. Class discussion will be a significant part of the course and all students are encouraged to participate in the discussion.

 

Grading
15 Homework Assignments @15 225 Scale
15 Chapter Quizzes @ 5 points 75 721-800 A
Research Project 200 641-720 B
Class Participation 100 561-640 C
Mid-Term 100 481-560 D
Final 100 0 - 480 F
Total Points 800

 

Schedule of Classes (Subject to Change)
      8th Edition 7th Edition
No Date Topic(s) Chapter Assign Chapter Assign
1 16-Jan Introduction 1   1  
2 23-Jan Data Structures for Database Processing 2
App A		 A21 - A24 2
App A		 A21 - A24
3 30-Jan E/R Model and Semantic Object Model 3
4		 3.25-3.28
Project A		 3
4		 3.25-3.28
Project A
4 06-Feb Normalization 5 5.24-5.26 5 5.24-5.26
5 13-Feb Database Design 6
7		 6.37, 7.26 6
7		 6.31, 7.22
6 20-Feb Relational Implementation 8 8.28 8 8.28
7 27-Feb SQL 9 Proj A-S 9 Proj A
8 6-Mar Database Application Design 10 10.49-10.52
Project B		 10 10.47-10.50
Project B
9 13-Mar Managing Multi-User Databases 11 Project A 12 Project A
10 20-Mar SQL Server and Oracle 12

13

   App B Appendix B
11 27-Mar Networks, Multi-Tier and XML 14 Proj A-G 11 Project A
12 3-Apr Spring Break - No class        
12 10-Apr ODBC, OLE DB, ADO, and ASP 15 Proj A-E 13 Proj A, B, C
13 17-Apr JDBC, Java Server Pages, MYSQL 16 16.50-16.51    
15 24-Apr Sharing Enterprise Data 17 17.58 14 14.58
16 1-May Object Oriented Databases 18 18.42-18.48 17 17.42-17.43
17 8-May Final Exam - Presentations