Welcome to web Pages of Vicky Shiv

1.0 User Specification and Requirement Document

2.0 A Brief Description of Mail Box

3.0 Design of Mailbox System

4.0 A Brief Description of the First Tier

4.01 Forms

4.02 Main Applet Screens

4.03 Info Dialog

5.0 A Brief Description of the Middle Tier

6.0 A Brief Description of the Third Tier

6.01 Referential Integrity

7.0 Error Checking

1. Reaching an extension

At the outset, the mail message system awaits the input of a extension. Some extensions belong to active extensions, others do not. We will see below how active extensions are created. If an inactive extension has been dialed, an error message is generated, and the system reverts to its initial state. If an active extension has been reached, the mailbox greeting is played. Unless changed by the owner, the greeting is You have reached extension xxxx. Please leave a message now.

At this point, the caller can type in a message, by entering the message text from the keyboard

2. Accessing a mailbox

To restrict access to the owner of the mailbox, the system prompts for a passcode. After the mailbox owner has entered the correct passcode, it is possible to retrieve messages from the mailbox, or to change mailbox settings. The user options menu is displayed:

Retrieve your messages.

Change your greeting.

Change your passcode. 

3. Getting the Message

There is an Restriction access to the Owner of the mailbox. Once the system authenticate the user, the user has full right to change its password, greeting and review messages.

To review message there is a new message list and an old message list. You can interchanges the messages between the old and the new message list.

4. Administrator

Administrator has got all the privilege to add mailboxes, delete mailboxes and change the password for the mailbox. The administrator access is being protected by the passcode.

Mail Box is based on Three Tier Client Server Architecture. The first tier is Graphical User Interface written in java, the middle Tier is dbANYWHERE Server and the third tier is the database. All Data is stored and retrieve from the database. Mail Box is using the JDBC classes of dbANYWHERE to connect, retrieve, stores and modify the database.

When the applet is downloaded from the server, In it init Process it ask dbANYWHERE Server to get the connection to the database. Once the connection is established it uses different types of SQL statement to retrieve results set from different tables and display it to the user.

As soon as applet is downloaded an authentication form came up in which you can login as the Administrator or Login as the User or Leave an Message for an extension. Every thing is password protected.

If user want to Login then he/she has to enter its login id and password and press OK button. This data is validated from the database, if it is a valid data then an other form Open as a User Profile. Now user can review its messages (Delete or Save messages), change its password and change its Greeting.

In case user want to leave a message for an active extension then he/she has to entered the mailbox id and Press OK. If the mail box does not exist it will give an error message other wise a new form (LEAVE MESSAGE ) will come with the extension greeting and now the user can entered the message through keyboard and press OK button. All this data is save into the database. The new message saved by the user can be retrieved by the mailbox owner in his/her review form.

If administrator want to login, then he has to enter his password. If this password is a not a valid password then he /she will get an error message otherwise a new Form for the administrator (ADMINISTRATOR FORM) is open. Administrator can add a new extension, delete an extension or change password of the mailbox. In case of deleting and modifying the user password, if the mailbox box does not exist it will give error message. In case of adding new extension, if the extension already exist it will give an error message.

Deletion of mailbox is cascading delete. If you delete the mail box, the corresponding old and new message will be automatically deleted. If you add new mail box then an automatic greeting ("You have reached an Extension XXX ,please leave an Message") is added to that mailbox database where XXX is Extension ID.

Mailbox system is virtually three Tier System. The first tier is using Java and dbANYWHERE custom classes, middle tier is using dbANYWHERE server to connect to the third tier which is the database. This application is an Applet so you can download from anywhere and get connected to the database.

First Tier the first tier is the custom Java and dbANYWHERE classes. Java classes is basically the used for developing Graphical User Interface. The dbANYWHERE classes is used to connect dbANYWHERE sever to the database and helps in doing various operations on the database.

Second Tier The second tier is the dbANYWHERE server which process the request coming from the client machine. dbANYWHERE Server listen to the port 8889. The request coming from the Applet is proceed to the database and result in from of result set is sent back to the applet by the dbANYWHERE Server.

Third Tier The Tier tier is the database. This database is presently running on the same machine but we can configure it on the other machine.

There are basically four forms (Dialog classes) ,one Applet and one error Info Dialog Box used to built the GUI

• Forms(Dialog classes)

1. ADMINISTRATOR Form
2. USER PPOFILE Form
3. REVIEW MESSAGE Form
4. LEAVE MESSAGE Form

• Applet

1. MAILBOX Applet

• Info Dialog (To display the Error Message)

INFO Dialog(In this we pass three parameter to built this Dialog box i.e. Frame, Error Message, Heading)

It provides the basic functionality of the mailbox administrator such adding mailboxes, deleting mailboxes, changing the mailbox box password. There is error checking for various operation such as deleting the mailbox which does not exit, adding the mail box which already exit, leaving the fields blanks, changing the password of the user which does not exist etc.

This form is used to review the messages. It consists of two lists(java classes) one showing new and other showing old messages. You can shift the new messages to the old message and old message to the new one. In order to increase the efficiency of the application all database transactions are done at the commit button. There is no database transaction when you are moving the messages or deleting the messages, It is all happening in the Vector classes at the client site. Once you say commit then this Vector is saved in the database.

This form is used to leave message for an extension. It display the greeting for that extension when it pops up .User can enter the message in the text area and

Press ADD button to save the message in the database.

This is the main Screen in the form of Applet. Once applet is downloaded it will get connected to the database through dbANYWHERE Server. It provides the functionality of the login screen such as Login as an Administrator ,login as a user and leave an message for an extension.

This is used to display the message/error message. It has three parameter

• ErrorMessage/Message to be displayed
• Frame Reference (Reference of the Frame for which message is displayed)
• Title (title of the dialog box)

The second tier is the dbANYWHERE server which process the request coming from the client machine. dbANYWHERE Sever listen to the port 8889. The request coming from the Applet is proceed to the database and result in from of result set is sent back to the applet by the dbANYWHERE Server.

Few Points about dbANYWHERE Server

• dbANYWHERE middleware software supports a 3-tier architecture for the database access.
• Each layered architecture refers to the database client(Application or Applet), dbANYWHERE server, and database Server. You can run all of them on One Machine.
• Using of dbANYWHERE we can have our first tier database independent. All the calls from the clients are handles by the dbANYWHERE which in turns passes it to the database.
• All the three tiers uses network Configuration to talk to each other.
• In general it talk at Port no 8889 at your IP address

Database MailBox

t_mailbox

t_newmessage

t_oldmessage

• t_mailbox

Primary Key : MailBoxID

field1 : MailBoxID text 5

field2 : MailboxPassword text 5

field3 : MailboxGreeting text 100

• t_newmessage

Primary Key : NewMessageID

Foreign Key : MailBoxID

field1 : NewMessageID Integer AutoGenerated

field2 : MailBoxID text 5

field3 : Message text 100

• t_oldmessage

Primary Key : OldMessageID

Foreign Key : MailBoxID

field1 : OldMessageID Integer AutoGenerated

field2 : MailBoxID text 5

field3 : Message text 100

1. Cascade Delete in case of Deletion of mailbox all the corresponding message in the t_oldmessage and t_newmessage will be deleted.
2. Old and new message table have an Foreign Key as the MailBoxID.
3. Primary key in case of t_oldmessage table and t_newmessage table is auto generated by the system.

1. Checking for the invalid choice in the menu.
2. Field can't be blank.
3. Error checking for the valid mailbox extension i.e. valid passcode and valid extension.
4. Deleting mailboxes which does not exist.
5. Adding mailboxes which already exist.
6. Error checking for the valid Mailboxes.
8. Error checking for the valid Administrator.
9. Error checking for the valid mailbox when user want to leave the message.