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:

• Data Base Management Software management
• Principles and applications of distributed Data Base Access.

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:

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?

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