DESIGN AND IMPLEMENTATION OF VIRTUAL ORGANIZATION

1
DESIGN AND IMPLEMENTATION OF VIRTUAL ORGANIZATION

• RAGHU KIRAN TATA

PROJECT COMMITTEE Dr. RICHARD J EASTON Dr.
ROBERT W STERNFELD
PROJECT ADVISOR Dr. HENJIN CHI
2
INTRODUCTION

• One of the more interesting aspects of the
  internet is how it has made virtual corporations
  a reality. Instead of hiring people to do jobs,
  you add people as needed to perform certain
  tasks. The problem with all this collaboration is
  the sheer number of places information can get
  lost. You might have some information in your
  email program, some printed on your desk, some
  files stored on various computers and lots of
  phone calls for which there is really no record.

3
OBJECTIVE

• To develop a discussion forum and to Create
  and maintain a Team site making it easier for
  teams around the world to work together using
  this new ASP.NET technology.

4
PROJECT OVERVIEW
APPLICATION FEATURES

• Fast, reliable messaging between you and your
  teammates.
• Discussion boards for you and your teammates.
• Teams can be created.
• Centralized storage of Team members contact
  information.
• Access from virtually anywhere.
• user login for user authentication.
• Search engine to search for content.

APPLICATION TASKS

• Design the related database tables.
• Create the stored procedures used in the
  application.
• Build the application's Web pages.

5
SOFTWARE / TECHNOLOGY

• Windows 2000 Professional
• Internet Information Server 5.0 with .NET
  Framework
• installed.
• Visual Studio.NET
• SQL Server 2000

6
CLIENT/SERVER TECHNOLOGY

• The Client/Server system is the medium of
  communication between the desktop computer and
  the database. This system ensures that network
  traffic is limited.
• The structure distributes operations efficiently
  between the client and the server.
• The basic entities in the client/server model are
  server processes, which manage resources and
  client processes, which require access to shared
  resources.
• Clients/server relationships involve a client
  process that shares a resource by sending a
  request to a server, and a server that performs
  the request on behalf of the client and sends
  back a reply.

7
THREE TIER ARCHITECTURE

• Most sophisticated Web based applications that
  involve data entry are based on a 3-tier
  Client/Server architecture (also referred to as
  the multi-tier architecture). The three tiers
  are
• The Client (Web Browser)
• The Web Server/Application Server
• The Database Server
• Data validation can happen in any or all of the 3
  tiers depending on the needs of the application.

Client Web Browser
Application Server
Database Server
Web Server
8
DATABASE DESIGN

• Introduction
• In the relational model, data is organized
  in tables that have the following
  characteristics every record has the same number
  of facts every field contains the same type of
  facts in each record there is only one entry for
  each fact no two records are exactly the same
  the order of the records and fields is not
  important.
• Problems Resulting from Poor Design
• A myriad of problems can manifest themselves as a
  result of poor database design
• The database and/or application may not function
  properly.
• Data may be unreliable or inaccurate.
• Performance may be degraded.
• Flexibility may be lost.
• The common problems resulting from poor database
  design can be grouped under two categories
• redundant data and
• modification anomalies.

9
DATABASE DESIGN

• List the objects.
• List the facts about the objects.
• Turn the objects and facts into tables and
  columns.
• Determine the relationship among objects.
• Determine the key columns.
• Determine the linking columns.
• Determine the constraints.
• Evaluate the design model.
• Implement the database.

10
DATABASE TABLES

• TblMembers
• TblMessages
• TblMessageFolders
• TblTeams
• TblTeamMembers
• TblPosts
• TblMemberHistory

11
STORED PROCEDURE

• A stored procedure is a set of Structured Query
  Language (SQL) statements that you
• assign a name to and store in a database in
  compiled form so that you can share it
• between a number of programs.Stored procedures
  can contain not only simple
• select, insert, update, and delete statements,
  but also can encapsulate procedural
• code. Since you compile and encapsulate stored
  procedures, they provide more
• efficient and secure data access.
• ADVANTAGES OF STORED
  PROCEDURES
• Stored procedures are compiled once and stored in
  executable form, so procedure calls are quick and
  efficient
• By grouping SQL statements, a stored procedure
  allows them to be executed with a single call.
  This minimizes the use of slow networks, reduces
  network traffic, and improves round-trip response
  time

12
STORED PROCEDURES

• sp_CheckForDuplicateEmail
• sp_CheckForTeamDelete
• sp_CheckLogin
• sp_CheckProfileVisibility
• sp_RetrieveAllMembers
• sp_RetrieveMessageCountByMember
• sp_RetrieveMessagesByMember
• sp_RetrieveTeamMembers
• sp_RetrieveTeamsByMember

13
GoNexus

• PROJECT DEMO

14
CONCLUSION

• Virtual Oraganisation is developed enabling the
  people from different regions communicate with
  each other.This system allows fast and reliable
  between the users.Private discussion boards are
  available to team members.Public discussion
  boards are available to all the registered users.
• This project has given me the oppurtunity to go
  throught tha tasks of installing and
  configuring Microsoft .net and SQLServer2000.
• ASP.NET Technology was used to create the dynamic
  web pages and to create Graphical User
  Interface.
• SQL Server 7.0 has been effectively used to
  create the database, the tables, relationships
  among the tables and to create the stored
  procedures.

15
QUESTIONS

• ?