SOFTWARE REQUIREMENT & SPECIFICATION
1.1 Introduction
1.1.1 Purpose
The purpose of this event management system is to make task of customers’ for event organization easier and efficient. It also helps to save time and cost of customer.
1.1.2 Document conventions
• Component Object Model:
An interface standard for software components used to enable inter- process communication and dynamic object creation.
• Database:
A system intended to organize, store, and retrieve large amounts of data easily; a repository of information.
• Events:
A social gathering or activity.
• Operating System:
The essential program in a computer that maintains disk files, runs applications, and handles devices such as the mouse and printer.
1.1.3 Intended Audience and Reading Suggestions
The intended readers of this SRS are developers, event heads, managing staffs and the event organizers. Reading the general descriptions before proceeding to the specific requirements would help the readers easily understand the background behind the functions of the system.
1.1.4 Product Scope
Event management system results in easier and efficient tasks of customers and saves time and cost; this can be beneficial for entrepreneurs and small businesses looking to expand their contact base. These networks often act as a customer relationship management tool for companies selling products and services. They can organize conference, seminars, trade shows etc. by this event management system.
1.2 Overall Description
1.2.1 Product Perspective
The software will be a new independent product, that it, it is not a component of another program. It is intended for the administration of the management and other concerned users. The product will import its data from Microsoft Access2010 database and use the Visual Basic.NET for its integrated development environment that uses COM as programming model.
This information can only be accessed by the staff members and the manager/supervisor aside from the developers. All the forms used in the product follows a clear and logical structure. Errors will be minimized through the use of drop-down buttons and command buttons to eliminate the excessive use of text input. Management of data includes searching, adding, modifying and deleting. The product specified will be developed for Microsoft Windows XP and Microsoft Windows 10. It does not also require any new hardware to function.
1.2.2 Product Functions
Event management designed to assist managers, event organizers, firms, and other users whose line of business deals with events management to manage their participants’ data in an orderly manner. It shall perform the following functions:
• Protect the database of the firm by requiring a correct and registered username and password.
• Make data organization easier by classifying participants according to sub-types of personal events.
• Facilitate a step-by-step process of entering, organizing, retrieving, modifying and deleting data from the database without the need to go the database itself.
• Add new client information easily.
• Provide an option for users to update information
• Delete existing client information.
• Create new events.
• Provide an easy function where you can go back one form whenever necessary.
• Present a list of participant codes representing existing clients.
• Add new supplier contacts with which future collaboration is expected.
• Display client information in an organized manner for easy understand.
• Display payment terms of participant including the total event fee, amounts paid by the participants and the balance.
•
1.2.3 User Classes And Characteristics
Event Heads:
The primary target users of this software are the Event heads. They are in-charge of scheduling events and managing participant information, thus, they will be the most frequent users of this software. Moreover, these people are assumed to be familiar with basic computer processes that will enable them to use this software. Their aim in the use of this software is to access or update existing participant information, add new participant information and make easy the billing procedure of the participants.
Event Managers:
The managers and the supervisors shall also have access to the software. They must possess computer literacy and analytical skills so as to use the software and make good use of the information provided by the same. They will use it in monitoring what their head has accomplished and what still needs to be done. Furthermore, they shall also use it in times when they want to check on a certain participant or event or when there is no staff available to attend to a participant.
1.2.4 Operating Environment
• Event Management will be a website/e-commerce website mode on .net.
• Event Management will have to make the database of it own by entering the data of the service provides from the frontend admin panel of the website by the special module for entering the data for service providers.
• Event Management will then establish a link to the system’s database and provide data for the working instance of application. There will be only one application for one type of user each application will refer to the same database. The authenticated users will be not able to make changes to that database.
1.2.5 Design And Implementation Constraint
• Event management is designed in such a way that it will required the minimum memory space and won’t require any data space on the memory drive of the clients device
• Another constraint is that of availability of internet connection at the user side.
• This might prove to be difficult to participants, should they ever want to avail the organizations services. On the other hand, this system will help to regulate the clientele and therefore provide guaranty that the services offered by the managing body are of outstanding quality.
• With regard to scheduling of the events, it is assumed that the venue shall be the choice of the event.
1.2.6 User Documentation
The software will provide options for a relatively easy data input processes text-boxes that will be properly label. It will also have a user-friendly view of the whole system with simple and easy undertaking of action-driven processes as command buttons are functionally label. With all these, target users of this software will relatively find it not difficult to use it.
1.3 External Interface Requirements
1.3.1 Hardware Interfaces
• Intel Core CPU @ 1.70 GHz
• 512 MB RAM minimum
• And other regular hardware devices
1.3.2 Software Interfaces
The system was developed to serve as a database for the events’ organizers. It is a stand-alone system; hence, it does not need an internet connection. However, the system requires minimum specifications for the software interfaces to be able to use it efficiently.
The operating system (OS) required in order to use the system is at minimum Windows XP, but may also be Windows Vista, or Windows 10. Microsoft Visual Studio 2008 and Microsoft Office Access 2010 must also be installed to their devices. These two application software were used to make the database, thus, having them in the computers will make the system proceed successfully and run error-free.
1.4 Other Non-functional requirements
1.4.1 Performance Requirements
Although the system is a simple one, a literate organizer who is able to understand simple computer processes is needed to run the system. An organizer is one who is knowledgeable about the ins and outs of the firm and is learned in the field of organizing events. The organizer will be the person to enter the data needed into the system, thus an organizer needs also be efficient to utilize fully the benefits that can be provided by this software. The system also needs MS Access for the organizations database management system.
1.4.2 Safety Requirements
Different information is entered into the database such as information about the different caterers, suppliers and participants. Mismanagement of information might cause participant dissatisfaction that will eventually lead to profit loss, only because of mistakes on giving information. In line with this, the organizer should always double check which suppliers are available.
1.4.3 Software Quality Attributes
Correct information must be entered into the system to prevent mismanaged conflicts to occur. This will make the information provided by the system to be reliable and useful. However, in case an error occurs, changes may be immediately effected provided the user notices the error. This is why periodic monitoring and run-through of the database and the system must be done. The target users of the system are deemed to understand basic computer processes so use of this system will be easy for them. They will not need to undergo rigid training and instruction in order to use the software.
CHAPTER 2
DATA DICTIONARY
DATA DICTIONARY:
A data dictionary is a catalogue -a repository-of the elements in a system. As the name suggests these elements centre on data and the way they are structured to meet user requirements and organization needs. In The major elements are data flow, data stores, and processes.
Table Name: Customer
Table Description: This table contains customers detail info.
Field Name Data Type Constraints Description
CUS_ID INT(10) PRIMARY KEY AUTO INCREMENT
CUS_NAME VARCHAR(50) NOT NULL CUSTOMER NAME
CUS_ADDRESS VARCHAR(50) NOT NULL CUSTOMER ADDRESS
CUS_EMAIL VARCHAR(30) NOT NULL CUSTOMER EMAIL ID
PASSWORD VARCHAR(20) NOT NULL CUSTOMER PASSWORD
GENDER VARCHAR(10) NOT NULL CUSTOMER GENDER
MOBILE NO BIGINT(10) NOT NULL CUSTOMER MOBILE NO
Table 2.1 Customer
Table Name: Admin
Table Description: This table contains Admin detail info.
Field Name Data Type Constraints Description
ADM_ID INT(10) PRIMARY KEY AUTO INCREMENT
ADM_NAME VARCHAR(50) NOT NULL ADMIN NAME
ADM_EMAIL VARCHAR(50) NOT NULL ADMIN EMAIL
PASSWORD VARCHAR(20) NOT NULL ADMIN PASSWORD
Table 2.2 Admin
Table Name: Event
Table Description: This table contains Event info.
Field Name Data Type Constraints Description
NAME VARCHAR(50) NOT NULL EVENT NAME
TIME TIME NOT NULL TIME
DATE DATE NOT NULL DATE
Table 2.3 Event
Table Name: Venue
Table Description: This table contains venue detail info.
Field Name Data Type Constraints Description
VEN_NAME VARCHAR(50) NOT NULL VENUE NAME
VEN_TYPE VARCHAR(50) NOT NULL VENUE TYPE
VEN_OWNER VARCHAR(50) NOT NULL VENUE OWNER NAME
MOBILE NO BIGINT(10) NOT NULL VENUE OWNER MOBILE NO
VEN_ADDRESS VARCHAR(50) NOT NULL VENUE ADDRESS
COST FLOAT NOT NULL COST OF VENUE
IMAGE TEXT NOT NULL VENUE IMAGE
Table 2.4 Venue
Table Name: Facility Provider
Table Description: This table contains facility provider detail info.
Field Name Data Type Constraints Description
FAC_ID INT(10) PRIMARY KEY AUTO INCREMENT
FAC_NAME VARCHAR(50) NOT NULL FACILITY PROVIDER NAME
FAC_EMAIL VARCHAR(50) NOT NULL FACILITY PROVIDER EMAIL
PASSWORD VARCHAR(20) NOT NULL FACILITY PROVIDER PASSWORD
SPECILIZATION VARCHAR(50) NOT NULL SPECILIZATION OF FACILITY PROVIDER
COST FLOAT NOT NULL COST OF SPECILIZED ITEM
IMAGE TEXT NOT NULL IMAGE
MOBILE NO BIGINT(10) NOT NULL FACILITY PROVIDER MOBILE NO
Table 2.5 Facility Provider
Table Name: Role type
Table Description: This table contains roll detail info.
Field Name Data Type Constraints Description
ROL_ID INT(10) PRIMARY KEY AUTO INCREMENT
ROL_NAME VARCHAR(50) NOT NULL ROLL NAME
ROL_DES VARCHAR(50) NOT NULL ROLL DESCRIPTION
Table 2.6 Role type
Table Name: Feedback
Table Description: This table contains feedback info.
Field Name Data Type Constraints Description
ID INT(10) PRIMARY KEY FEEDBACK ID
NAME VARCHAR(50) NOT NULL USER NAME
FEEDBACK DETAIL VARCHAR(50) NOT NULL FEEDBACK DETIAL
Table 2.7 Feedback
Table 2.8 Payment
Table Description: This table contains payment info.
Field Name Data Type Constraints Description
PAY_ID INT(10) PRIMARY KEY AUTO INCREMENT
PAY_AMOUNT INT(10) NOT NULL PAYMENT AMOUNT
Table 2.8 Payment
CHAPTER 5
FUTURE ENHANCEMENT
Email Notification Management Send Email Invitations ; Automate Confirmations:
• Auto notifications to email groups on form submit.
• All it takes is a few clicks and everyone on your list can be notified about your upcoming event.
• Send emails about important info and updates, or remind people that you’re waiting for a response.
• Tracks who opens, accepts or declines your event invitation.
• Automatically capture invitee response details and update participant lists.
• Send automatic emails with confirmation and payment receipt
CHAPTER 6
CONCLUSION
It organizes and manages the events. It makes the task of customers and event managers easier. It consist all the things and information that are required for organizing an event. It fulfilled all the requirement of customers. It gives efficient and effective system. This system is time and cost saving system.
