NATS115

LeMoyne-Owen College
Division of Natural Science, Mathematics & Computer Science

Course:            COSI 445 DATABASE MANAGEMENT
Semester:         FALL 2005 T TH 8:00 - 9:20 GOH 103
Instructor:         Dr. VIVEK SAVUR
Office:              GOH 100 B
Office Hours:     Office Hours
Phone:              435-1385 or ext. 1385
For schedule, click here:    Schedule
For Evaluation and grading, click here:    Evaluation and Grading
For the reference index, click here:     Reference Index
For Announcements about home works, tests, finals etc., please click here:     Course Announcements
Student Presentations Spring 2003
Text:
(Lab Manual) Microsoft Access 2002 Complete Concepts and Techniques by Shelly, Cashman, and Pratt. September 12, 2001, Thompson Course Technology. ISBN 0-7895-6281-2

COURSE DESCRIPTION:

The course emphasizes the concepts and structures necessary for the design and implementation of database management systems, data models, data normalization, file organization, and index organization. Three hours of lecture per week, which includes hands on lab experience

OBJECTIVE:

The students should understand the database environment, advantages over traditional file processing, evolution of database process, database analysis, the entity-relationship models, entity types, object-oriented modeling, database design. The lab exercises will include creating databases using design and datasheet views, querying, publishing to the internet using data aces pages enhancing with OLE fields, hyperlinks and using macros.

COMPETENCIES

On completion of the course, the student should be able to prepare database using Access..

CLASSROOM POLICIES:

There will be classes on Tuesdays and Thursdays 8:00 TO 9:20. The class will consist of discussions with the instructor initiating the topics and the students sustaining the dialogue. Points will be given for class participation. Students are expected to read from the textbook following the schedule, research topics to discuss from web pages, newspaper articles, magazines, etc. In the lab students will have to produce a report and a presentation on a topic of their particular interest dealing with data base.. The presentation can be on the web page or by power point. The presentation can be used as a basis for the report.

A. Attendance:

If as many as 3 classes are missed without excuse, the course grades will be reduced by one letter. If as
many as 5 classes are missed without excuse, the student will fail the course. An absence will be excused only if a doctor's written certificate for illness or a written statement concerning a death in the family is supplied. Other valid excuses are provided by coaches or other faculty for legitimate events.

B. Evaluation:

Tests 45 points
Daily Quizzes 15 points
Presentation on the day of the final 40 points

C. Grading Scale:     88 to 100       "A"
                                    75 to 87         "B"
                                    62 to 74         "C"
                                    50 to 61         "D"
                                      0 to 49         "F"

Comprehensive final: Tuesday April 27 8:00- 9:50

Tentative Schedule

Week Material

Textbook Lab Manual

    1        Introduction to Information Technology                        Creating a Database using design and datasheet views
    2        Internet Information Systems                                        Creating a Database using design and datasheet views
    3        Representing Information with data models                   Querying a database using select query window
    4        Data Modeling with Entity-Relationship diagrams          Querying a database using select query window
    5        Developing Relational Models                                       Maintaining a database using update features
    6        Defining Relational Databases                                        Maintaining a database using update features
    7        Improving Relational Schemas and Normalization          Publishing to the Internet
    8        Manipulating Database Content                                    Reports, Forms, and Combo Boxes
    9        Using SQL to manipulate Database                               Reports, Forms, and Combo Boxes
   10       Presenting Information on the web with HTML            Enhancing forms with OLE Fields, Hyperlinks, and Subforms
   11       Creating Interaction between users and servers            Enhancing forms with OLE Fields, Hyperlinks, and Subforms
   12       Developing Database applications for the web            Creating an application system using Macros, Wizards
   13       Designing an Interactive Web site                               Creating an application system using Macros, Wizards
   14       Implementing Bighit online in ASP and Javascript        Sharing Data Among Applications
   15       *** Final *** Tuesday April 27 8:00 - 9:50

Student Presentations Spring 2003