| CRN | 2632-101 | |
| Semester | Fall - 2001 | |
| Dates | Wednesdays, August 22 through December 12 | |
| Location/Times | 4:00 to 6:20 PM, Room GC 136, South Charleston |
Texts and Study Materials |
||
| Required Text(s) | ||
| David M. Kroenke, Database Processing: Fundamentals, Design & Implementation (7th Ed), 1999, Prentice Hall | ||
Instructor |
||
| Name | John Biros | |
| Office | GC 331
100 Angus E Peyton Drive South Charleston, WV 25303 |
|
| Office Hours | By Appointment | |
| Phone | 304-746-1941 | |
| 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 @20 | 300 | Scale | ||
| Research Project | 200 | 721-800 | A | |
| Class Participation | 100 | 641-720 | B | |
| Mid-Term | 100 | 561-640 | C | |
| Final | 100 | 481-560 | D | |
| Total | 800 | 0 - 480 | F | |
Schedule of Classes (Subject to Change) |
|||
| No | Date | Topic(s) | Chapter |
| 1 | 22-Aug | General Review
Introductions Introduction to Database Processing |
1 |
| 2 | 29-Aug | Introduction to Database Development
Data Structures for Database Processing |
2
Appendix A |
| 3 | 05-Sep | E/R Model (Including Project A)
Semantic Object Model |
3
4 |
| 4 | 12-Sep | Relational Model and Normalization | 5 |
| 5 | 19-Sep | Database Design using E/R models (Including
Project A)
Database Design With Semantic Object Models (Project A) |
6
7 |
| 6 | 26-Sep | Foundations of Relational Implementation | 8 |
| 7 | 03-Oct | SQL | 9 |
| 8 | 10-Oct | Using SQL Server 7.0 | Appendix B |
| 9 | 17-Oct | Database Application Design | 10 |
| 10 | 24-Oct | Database Applications Using Internet Technology | 11 |
| 11 | 31-Oct | Managing Multi-User Databases
Accessing Database Servers (ODBC, OLE, DB, ADO) |
12
13 |
| 12 | 07-Nov | Sharing Enterprise Data | 14 |
| 13 | 14-Nov | Relational Implementation with DB2 | 15 |
| 14 | 21-Nov | Thanksgiving Break | |
| 15 | 28-Nov | Object Oriented Database Processing | 17 |
| 16 | 05-Dec | Project Presentations: Final Exam | |
| 17 | 12-Dec | Project Presentations: Final Exam | |