Distributed Data Bases

IS-262   Instructor:  Paul Lecoq

Time Monday through Friday, 7:30 to 8:30 AM

Return to Paul Lecoq's page

An in-depth investigation of database management in distributed E-Commerce environments.  Students are required to understand Data Base Theory and to be able to use SQL prior to entry to this class.  Students are also required to have a working knowledge of one or more network programming languages (Java, Java Script, Visual Basic, VB Script, or Perl prior to beginning this course.  Students will learn how to manage a professional DBM system and exercise its capabilities.  Students will also learn the fundamentals of distributed access to data bases via two-tier and n-tier architectures.  to be familiar with an applications data base manager (Access) and with Visual Basic.  The course will be segmented into two threads:

Major course task List:
The instructor will lead regular discussions in class, giving out assignments as appropriate.  In addition to these class related study tasks you are expected to complete the  assignments in a timely manner.
 





Learning Objectives:

To become effective in managing data base systems as used in E-Commerce environments, applying them to appropriate corporate needs.


Data Base Management Software management
In this thread the students will learn how to operate, manage, and create data bases in a professional DBMS such as SQL Server 7 or SQL Server 2000.  Instruction will be in-depth on the chosen DBMS but the students will be instructed on competitive DBMS such as Oracle.
Students will learn advanced techniques using SQL on appropriately normalized data bases.
Students will learn how to set up the DBMS for remote access.


Principles and applications of distributed Data Base Access.

Students will learn the principles of n-tier distributed Data Base systems and will implement representative 2 tier and n-tier access modules.  Students will use Visual Basic, VB-Script, Java Script, and/or Perl.

 

 

Course Schedule for the quarter

INSTRUCTIONS

EVALUATION CRITERIA:

One Midterm and one Final exam. The primary evaluation criterion will be how well you perform the assigned tasks.


Back to this quarter's courses

Back to Computer & Network Support Certificate







Major Course Tasks

Back to task list==Back to weekly schedule



Assignments

    Class problem:

    You will be given a scenario with an incomplete set of business rules and objectives.  As a group (or groups) you will evaluate the companies organization and needs and propose a specific distributed database solution for them.

    Both a written and oral report on the solution are required.

    The basic Scenario:
    A new dot-com company is being formed to provide a unique service to a broad client base.
    The precise description of the business will be disclosed in class after everyone has signed a simulated non-disclosure agreement.
    The Company will require an interactive Web page with lots of CGI/ASP access to data bases describing their products and keeping track of the client base.
    Client interaction will be by E-mail, threaded discussions, and direct connection to a human specialist.  The class will design a seamless system for accessing all modes of interaction.

    The class will:

    • Analyze the problem:
    • Interact with Corporate representatives to define precise requirements
    • Research for off-the-shelf systems to do the job.
    • Design in-house developed system.
    • Perform cost/benefits tradeoff between development and purchase of the system
    • Implement the most effective solution
    • Test the solution under simulated real world conditions.

      Back to task list==================Back to weekly schedule


    Research Assignment

    You will be given a list of topics from which to choose.  Working in pairs or by yourself, you will explore books, the web, and anything else you can find to give a diffinitive oral report on your chosen subject.
    Show your notes at the time of your report for full credit
     

    Back to task list==================Back to weekly schedule



Course Schedule

Instructor: Paul E. Lecoq Winter 2000

Text: Undecided at this time.  Text will include an SQL Server text and probably one on programming for the Internet.
Week - DATES
 
Week - DATES Data Base Management Software management 


Principles and applications of distributed Data Base Access.

Practical Exercises
Assignments
TBD after selection of texts
-1- 
 
 
Review  entire text
What is SQL Server?  What major DBMS are being used
Data Base Models.


The Two Tier distributed Data Base Model
----------
-2- 
 
 
Basic Queries

Establishing a useful Data Base Client
College Course Database. Quick Case Study
-3- 
 
 
Queries in-depth

ADO and COM
Exercise the client with SQL Queries
Research on data base concepts
-4- 
 
 
CASE STUDY  Data Base for an E-Commerce Company


CASE STUDY Implementing the DB System
Begin Class project
-5- 
 
 
Advanced SQL Server Management
Alerts, etc.


n-Tier architecture
Database design & life cycle  
-6-
 
 
Work on class project


Server-side & Client-side programming languages - an overview
Work on Class Project


 
-7-
 
 
Data base development case study


Select server-side language and develop middle and server tier modules



 
-8- 
 
 
Complete the data base development case study


Implement middle tier modules for case study
-9- 
 
 
Work together on projects


Work together on projects
 
-10- 
 
 
Review and present research assignments


 
Research assignment due
-11- 
 
 
 Present final review of Class Problem to Faculty and Business representatives

Final Exam

Class Problem solution due
 


Back




Instructions

Assignments are due on hardcopy on the first day of the week in which the assignment is noted in the schedule. I will allow a grace period but if the assignment comes in after Wednesday they may suffer a 20% penalty. After Friday, 50% penalty.

You must turn in all assignments in order to pass the course, even if you get no points for the assignment.

In addition to handing in the assigned problems, you are expected to read all the chapter problems and convince yourself that you could do them if asked.  If you have trouble understanding them, bring them to class.
 


Back




How do you know when you are done? How well have you done?

GRADING (These values may vary depending on how well we progress)

POINTS
1 Test 100
9 projects 300 (1/2 on whether it works
1/4 on quality, 1/4 on testing) FINAL 200
Attendance & participation 100
TOTAL 500
Your grade on all work will be determined by linear interpolation between the lowest 4.0 and the highest 0.0.
Lowest 4.0 =~90%
highest 0.0 =~70%


Back


Back to the Table of Modules