ST. Gregory’s UNIVERSITY

COURSE SYLLABUS For Spring 2001

                                                                                                      

COURSE

Database Structures, CS 3323 - 1

TIME/LOCATION

MWF 1:00 - 1:50, Room 308

PREREQUISITE

CS 1823 Microcomputer Applications

INSTRUCTOR

Mrs. Connie Farthing

OFFICE

Room 442b, 878-5150, csfarthing@sgc.edu

HOURS

MWF 12:00-1:00 or by appointment

 

COURSE DESCRIPTION:

Designed to provide the student with basic knowledge of database structures.  Emphasis will be on methodologies for planning, designing, constructing, implementing, and maintaining databases including Enterprise Databases and applications using Internet technology. Prerequisite: CS 2103

 

Objectives:

Upon completion of this course the student should:

·         Use entity-relationship diagrams, data dictionaries, and other common design tools to develop a database design.

·         Understand and learn the role of database applications in the business environment.

·         Learn and discuss the importance of database technology in the 21st century.

·         Design and implement a personal computer relational database management system to include tables, queries, forms and reports

·         Learn to adequately use macros for mundane tasks.

·         Work with a team to design and implement a database, using Access 2000.

·         Write Structured Query Language

·         Database Technology using the Internet

·         Accessing the Database Server

·         Understanding and utilizing Data Warehousing

 

These objectives can only be achieved through joint effort.  I will work to stimulate your interest and learning, but you are to display initiative and a program of self-study.  In that sense, a complementary objective is to provide you with an environment that will encourage and reward your intellectual effort, while simultaneously maintaining rigorous standards that identify those who are motivated to pursue excellence in their own educational preparation for a business career.

 

ACADEMIC HONESTY

Students are advised that cheating and plagiarism are not tolerated at St. Gregory’s University.  Students are expected to abide by the University's academic regulations and policy and are responsible for awareness of the University's definition of these activities. The consequences of violating the academic honesty standard may include a grade of "0" on the assignment/exam, a grade of "F" in the course, and, possibly, expulsion from the University.

 

TEXTS:

Database Processing Fundamentals, Design, and Implementation, Kroenke, 7th Edition, Prentice Hall, 2000.

Advanced Applications Development in Microsoft Access 2000, Baldwin/Paradice

 

Other Reference Material:

Modern Database Management, 6th Edition, McFadden, Hoffer, & Prescott, 1999

 

METHODS OF ASSESSMENT AND STUDENT EVALUATION

Exams

 

30%

Paper

 

30

Presentation

 

30

Attendance

 

  10

     Total points

 

100%

 

EXAMINATIONS AND PRESENTATIONS

·         If any exam question is left unattempted, the value of that question will be subtracted from the exam score. 

·         Being prepared and present for the exams and presentations is your responsibility. The exam and presentation will be given on schedule.  Mark your calendars now.

 

HOMEWORK

Each homework assignment must be e-mailed.  It is your responsibility to see that the e-mail was received.  Late homework will not be accepted.

 

COURSE OUTLINE

The schedule is flexible.  Much material is required.  It is not possible for an instructor to cover all the course material without student independent study.  As students are interested in a particular topic or as test scores warrant review, more time will be spent on a chapter, or as may be required.

 

Class Schedule

Week

Chapter

Topic

1

 

Introductions

2

1

Introduction to Database Processing

3

2

Introduction to Database Development

4

3
5

The Entity-Relationship Model

The Relational Model and Normalization

5


6

Exam 1-3. 4
Database Design Using Entity-Relationship

6

8

Foundations of Relational Implementation

Individual Database Projects

7

 

Introduction to Group Project

8

9

Structured Query Language
Group Projects

9

11

Database Applications Using Internet Technology
Group Projects

10

12

Exam 6, 8-9, 11
Managing Multi-User Databases

11

13

Accessing the Database Server: ODLC, OLEDB, and ADO

Group Project

12

14

Sharing Enterprise Data
Group Project

13

16

The Hierarchical and Network Data Models
Group Project

14

 

Object-Oriented Database Processing
Group Project

15

 

Group Project Presentations

16

 
Final Chapter 12-14. 16