IS 623 - Database Management

Semester Spring 2005
Class Sessions Thursday 6:30 - 9:00 pm
Class LocationGullickson Hall - Room 206A
Huntington Campus
Course DescriptionReview of information structures and of relationships among data elements and objects. Relational database theory; design and organization of databases, retrieval structures, and query mechanisms.
PrerequisiteIS621 - Information Structures I (can be taken concurrently)
TextKroenke, David, Database Processing 9th Ed., Prentice-Hall
ISBN0-13-101514-1
InstructorJonathan Thompson
Office Phone304-696-6349
Office Fax304-696-5454
EMailThompsonJ@marshall.edu
Office LocationGullickson Hall - Room 116
Huntington Campus
Office HoursBy appointment

Discussion

The course covers the concepts of designing a database, normalizing the data structures, implementing the database design, retrieving data from the database, and understanding several of the core design issues that confront database management developers. Conceptual reading and lecture material is reinforced by hands-on in-class lab exercises. Narrated PowerPoint lectures are available on CD-ROM.

Attendance Policy

Attendance is expected; absences from class are not excused unless prior arrangements are made, or in the event of illness or hazardous driving conditions.

Grading Policy

Grade Components Grade Scale
Homework/Quizzes 15%   A - For achievement of distinction. 
Mid-Term Exam 20  B - For competent and acceptable work. 
Final Exam 15  C - For below average performance. 
Lab Exercises 25 D - For patently substandard work. 
Case Study 10  F - Failure, given for unsatisfactory work. 
Course Project 15   
Total

100%

   

Note: Lab assignments are due no later than the beginning of the next class.

Schedule of Topics (Subject to Change)

SessionIn-Class Activity CD Lecture TopicReading
1 13-Jan Course IntroductionE/R Diagrams2, 3
2 20-Jan Forming RelationsSQL Data Retrieval6
3 27-Jan SQL Data RetrievalSQL Tables and Views7
4 03-Feb SQL Tables and ViewsEmbedded SQL8
5 10-Feb SQL Code Multi-User Databases9
6 17-Feb SQL SecurityNormalization 4
7 24-Feb ER Diagrams/Normalization  
8 03-Mar Midterm Access Forms5
9 10-Mar Stand-alone Access DB SQL Server DBs 11
10 17-Mar Client/Server: Access/Oracle  12
  24-Mar Spring Break    
11 31-Mar Client/Server: Web/SQL Server  13
12 07-Apr Case Study    

13

 14-Apr XML    
14 21-Apr Course Project    
15 28-Apr Course Project   
16 05-May Final Exam  

13-Jan-2005