Empowerment
and livelihood improvement of Integrated Solutions Limited

1.0:
Introduction

Database Management System (DBMS)

• It is the software
  that defines a database, stores the data, support a query language,
  produces reports and creates data entry screens

A Database Management System (DBMS) is a
software package with computer programs that control the creation,
maintenance, and the use of a database. It allows organizations to conveniently develop
databases for various applications by database administrators (DBAs) and other
specialists. A database
is an integrated collection of data records, files, and other database objects. A DBMS allows different user
application programs to concurrently access the same database. DBMSs may use a
variety of database models, such as the relational
model or object model, to conveniently describe and
support applications. It typically supports query
languages, which are in fact high-level programming languages,
dedicated database languages that considerably simplify writing database application
programs. Database languages also simplify the database organization as well as
retrieving and presenting information from it. A DBMS provides facilities for
controlling data access, enforcing data
integrity, managing concurrency control, recovering
the database after failures and restoring it from backup files, as well as
maintaining database security.

A DBMS is a set of
software
programs that controls the system organization,
storage,
management, and retrieval of data in a database.
DBMSs are categorized according to their data structures or types. The DBMS
accepts requests for data from an application program and instructs the operating
system to transfer the appropriate data. The queries and responses must be submitted
and received according to a format that conforms to one or more applicable
protocols. When a DBMS is used, information systems can be changed more easily
as the organization’s information requirements change. New categories of data
can be added to the database without disruption to the existing system.

Database servers
are dedicated computers that hold the actual databases and run only the DBMS
and related software. Database servers are usually multiprocessor
computers, with generous memory and RAID disk arrays used for
stable storage. Hardware database accelerators, connected to one or more
servers via a high-speed channel, are also used in large volume transaction
processing environments. DBMSs are found at the heart of most database applications. DBMSs may be built
around a custom multitasking kernel with built-in networking
support, but modern DBMSs typically rely on a
standard operating system to provide these functions.

Definition:
A database management system (DBMS)
is the software that allows a computer to perform database functions of
storing, retrieving, adding, deleting and modifying data. Relational database
management systems (RDBMS) implement the relational model of tables and
relationships.

Also
Known As: DBMS

Examples:

Microsoft
Access, MySQL, Microsoft SQL Server, Oracle and FileMaker Pro are all examples
of database management systems.

1.1 Procedure of DBMS:

In a
well-structured database application, SQL statements are typically not
distributed over the entire application but concentrated in a single access
layer instead. This access layer has a procedural interface to the rest of the
application at which the operations for application objects are made available
in form of abstract data types.

In client/server
configurations, the client and server interact when an SQL statement is
executed in the access layer. The number of these interactions can be reduced
considerably by transferring the SQL access layer from the client to the
server.

SAP DB provides a
language (special SQL syntax) for this purpose that allows an SQL access layer
to be formulated on the server side. This special SQL syntax can be used to
define database procedures and triggers.

This has three
main advantages:

• The number of interactions between client and
  server is reduced considerably (several factors). Client/server
  communication is only required for each operation on the application
  object, and not for each SQL statement. This enhances the performance of
  client-server configurations considerably.
• The SQL access layer contains the procedurally
  formulated integrity and business rules. By concentrating these rules on
  the server side and eliminating them from the database applications,
  modifications can be made centrally and thus become valid immediately in
  all database applications. In this way, the integrity and decision rules
  also become a part of the catalog in the database system.
• An SQL access layer in the form of database
  procedures transferred to the server side is an essential customizing
  tool, as it allows customer-specific database functionality to be
  included.

To be able to
execute a database procedure, users must have the call privilege. This call
privilege is independent of the user privileges for the tables and columns used
in the database procedure. As a result, users may be able to use a database
procedure to execute SQL statements that they otherwise would not have access
to.

Database
procedures are called explicitly from the programming language of the
application. They can contain parameters, except for LONG columns.
The extent to which LONG columns can be used within database procedures depends
on the length of the LONG columns and the amount of storage space available.

As
with any SQL statement, precautions must be taken to ensure that calling a
database procedure has the desired effect, and that errors do not have any
lasting effects on the database system. SAP DB provides nested transactions for
this purpose. Each database procedure call can run in a sub
transaction that can be reset without interfering with transaction
control in the database application

2:
COMPANY PROFILE 

2.1 ABOUT INTEGRATED SOLUTIONS LIMITED

Integrated
Solutions Limited (ISL) is an innovative provider of information and
Communication Technology (ICT) products and services in Bangladesh &
Australia. It is a joint venture company between those two countries. Their
products and services are used by government bodies and large to small
companies at home and abroad through its commitment and dedication towards
quality, innovation and customer satisfaction. 

Integrated Solutions brings
the integration of ICT into daily and corporate life by providing products and
services along with mentoring of global standards.

ISL’s computing
professionals are trained at some of the leading institutions in the world, and
have extensive experience in national and international ICT projects. They are
committed to providing the very best in products and services to their clients
who will substantially contribute to their growth and long term prosperity. Its
aim is to inspire and delight their customers and communities with their
innovative products and services at home, on the move and at work.

At ISL, a group of hard
working young talented people, driven by intelligence, taste and patience,
transforms the need and dream of the customer into reality by their core
technical knowledge and expertise.

ISL believes that a good
development needs to be backed up by good customer support and this is a common
practice in ISL. This is the reason the customers rate them so high. They also
believe in achieving perfection through open source collaboration for software
development; therefore they try to practice open source whenever it’s possible.

ISL employs
professionals that are experts in installing, training and maintaining
application software packages. They customize accounting and contact management
software to meet the specific needs of the company and help to get the most out
of client’s word processing and spreadsheet software.

2.1
HISTORY OF INTEGRATED SOLUTIONS LTD.

Integrated Solutions is software
and IT related company that was established in Australia in the early 1995.
Then it starts its operation in Bangladesh as joint venture Company in the
early 2000. In Bangladesh it works in various domains of software development
and offers robust high quality solutions for wide range of platforms. At ISL,
they believe the best way to develop business is through assuring user
satisfaction and quality assurance.

With
monumental changes taking place in the computer Industry, companies need to
keep current of the latest technology and how it affects their business.
Integrated Solutions provides companies with this expertise. They offer a wide
variety of products & services and maintain a staff of systems and software
professionals, whose diverse talents enable them to offer the best solutions to
businesses. Whether you need a complete system design or merely help with a certain
application, ISL can find a solution that will work for you. Integrated
Solutions was founded in Bangladesh early 2000 and has grown substantially, due
to the importance it place on customer satisfaction. ISL understand your
computer systems are an integral part of your daily business activities. It
knows the frustration that occurs when your system is not operating
efficiently. Integrated Solutions is dedicated to ensuring that everything
possible is done to maintain quality in the products, systems and software they
provide their customers. They are available to our customers 24hours a day, 7
days a week as their commitment to quality and excellence that customers
deserve.

2.3 MISSION

Deliver
state-of-art software and technology solutions to our customers through
quality, innovation and leadership.

2.4 VISION

Our vision is to be recognized as the company of
choice for information technology products and services, which provide value to
our customers and communities.

To achieve this vision we aim to

·
Strengthen
customer commitment by better understanding their needs, leveraging all ISL
solutions to meet these needs and exceeding their expectations.

·
Position
ourselves competitively in the market with expertise in technologies that are
driving the industry globally.

·
Maintain
commitment to professional development processes that recruit, nurture and
retain the ‘right’ people and further develop their expertise.

·
Through
continuous review and improvement, accelerate the development of the
organization as the efficient, low cost operator.

2.5 GOALS

ISL deliver the value to
their customers by providing expertise in:

·
Business solutions delivered through application
software.

·
Design, implementation and management of reliable
technology infrastructure.

·
Cost effective procurement of IT hardware and
software.

2.6
CORPORATE VALUES

ISL always try
to be satisfied their valued clients and customers through their requirements.
This means, we will hold the following values and will be guided by them as we
do our jobs.

·
Creating
an honest, open and enabling environment

·
Have
a strong customer focus and build relationships based on integrity, their
requirements, service, maintenance and mutual benefit

·
Strive
for profit & sound growth

·
Relentless
in pursuit of business innovation and improvement

·
Responsible,
trustworthy and law-abiding in all that we do

2.7
ISL’s CLIENTS:

Integrated
Solutions has a growing list of clients ranging from government bodies and
large national and international companies to small businesses. Our clients
appreciate our ability to constantly exceed their own and their client’s
expectations.

·
Ministry of science and Information
& Communication Technology, Bangladesh

·
Ministry of planning, Bangladesh

·
MIS Technologies Centre, Singapore

·
Turner Freeman Lawyers, Australia

·
BASF Bangladesh

·
PHP Group, Bangladesh

·
Intraco Group, Bangladesh

·
Bangladesh Army

·
ZAF Sweaters & Garments

·
Khan Foundation, Bangladesh

·
The Millennium University, Bangladesh

·
Australian Campus Network, Australia

·
Bangladesh Project Management Institute

·
Ahmad Medical Centre, Bangladesh

·
PNS Graphics, Australia

·
Islam & Associates

2.8
ISL PRODUCTS:

ISL
develops markets and supports an ever-expanding line of products. This delivers
the best in terms of quality, security and value to our clients. Our products
are used by public authorities as well as businesses such as garments
industries, medical professionals, accounting and law firms, travel agents,
fleet managers etc.

Some
of our recent products are:

Web
portal is a unique program for online
publication of forms and public notices of all ministries of Bangladesh. The
program is an important step towards e-governance and is funded by the ministry
of Science and information & Communication Technology, Bangladesh.

Project-I is a workflow enabled project management system. This
Lotus Notes application provides ‘whole of project’ life cycle tracking system,
offering total control for project management. Project-I has a set of tools for
most project management tasks including budgeting, tracking expenditure, and
cash flows. It comes with a financial system interface and can be customized to
suit any organization.

Diagnostic-I is a leading software for streamlining the
complexities of data management in the medical industry. It can be used for registering
patients, creating appointments and consultations, maintaining patient queries
and medical reports.

Inventory-I is a complete inventory management system for receipt
of fabrics and accessories against an order as well as issuing to production line
and local store transfer. This is an essential software in garments industry.

 Rim-I
is an innovative research management tool suitable for any private sector
organization that undertakes large scale research activities. Rim-I captures,
stores and indexes the total research process and makes the information
available for access and reuse throughout an organization.

Account-I is developed for trading, intending and other uses by
private organizations who need pure accounting to easily create and maintain
their own chart of accounts.

Mobile-I specially developed to meet the needs of senior
executives in both private and public sectors. This is an integrated workplace
information management solution which goes beyond standard personal information
management packages. The software is being used in different ministerial
offices in Australia.

Travel-I management system uses the workflow capabilities of
Lotus Notes to manage payments related to travels undertaken by employees in
government and large organizations.

Law Soft-I is developed for law firms to keep track of progress
of cases and allows them to monitor staff activities.

2.9 SERVICES:

Integrated
Solutions provides a full range of services that offer our clients the benefits
of an experienced IT development, without the expense of developing and
retaining comprehensive in-house resources. We are dedicated to achieving the
best results in software and website development, IT outsourcing, network
design and implementation, security and training.

Software Development:

ISL’s
Software Development team can create purpose built software that enhances your
business process, optimizes, resources and streamlines your organization Off-the-shelf
solutions cannot address the unique requirements of information management
technologies with legacy systems, existing networks and subsystems, requires a
complex level of skill and experience.

ISL
has access to a team of highly skilled and experienced technologists in the
areas of software design, development and implementation. We use latest tools,
techniques and methodology, and make extensive use of reusable code and objects
that have been stress-tested. Our custom software is designed and developed to
meet your specific needs, and in doing so, we provide the best in information
to your business. The solutions we provide for our clients involve our team in
all key phases of software delivery, from base design through to complete
development.

Web
Development

ISL
has the expertise to provide your business with all the very latest in website
development. Our team has expertise in all facets of static and dynamic web
development.

From
a basic website to more complex database driven e-commerce and shopping
facilities, the ISL web development team will be able to provide you with any
service you may need to promote your group to the largest audience available.

Network Services:

Infrastructure Design &
Implementation

When
it comes to networking we at Integrated Solutions can design, implement, deploy
and manage any network to custom meet your needs now and in the future. We
understand the

importance
of a quality sound network backbone to ensure your businesses functionality
with critical data, applications and day to day operations.

The
core of your organization is your network and a poorly designed network can
cost your company countless headaches. Whether your upgrading your current
network or planning and designing a new network we will carefully work with you
to design and implement the best possible solution for your company’s needs.

·
Remote Desktop Support

·
System Maintenance

·
Remote Backups

·
System Monitoring

·
Email/Internet Access/Web Hosting

·
WAN’s/Blended WANs

·
Managed Firewalls

·
Network Security

LAN/WAN Support

Technology
is evolving over leaps and bounds even as you read this. In order to stay ahead
of your competitors you must accept these changes and implement these new
technologies to keep yourself one step ahead of the competition.

Companies
are changing and evolving as readily as technology is. As companies become more
and more mobile or geographically separated, the need to exchange data is
increasingly important. We can offer you timely service through remote desktop
support.

We
at Integrated Solutions understand no two companies are alike and that’s why we
will custom design and implement a solution that works specifically for your
needs. Whether you’re a small, medium or large user environment we will assess
your situation and needs and propose and provide state of the art technology
and solutions for your LAN or WAN.

Network Security

Security
is one of the most important aspects of any network. You could have one of the
most solid and sophisticated networks in the world, but without a secure
network protecting your businesses critical data it would be considered stone-age
by today’s standards.

Malicious
viruses and computer hackers are becoming more and more of a threat every day.
Without awareness, policies, software, hardware and updated technologies to
combat these threats you are leaving yourself and your business accessible and
vulnerable to an endless possibility of nightmares. A network without security
is like storing all your money under your pillow instead of the bank.

Integrated
Solutions will work with you to create an intelligent infrastructure by integrating
your existing assets with new technologies to give you state of the art
security solutions for a strong and reliable infrastructure.

2.10
MANAGEMENT HIERARCHY OF INTEGRATED SOLUTIONS LTD.

THE KEY TASKS
AND OUTPUTS OF THE HR FIRM

As per the agreement, the key tasks and outputs of
Rapport Bangladesh Limited (HR firm) related to Database creation would be as
under:

USE OF ICT FOR HR SCREENING AND RECRUITMENT

Rapport
Bangladesh Limited is proud for their expertise in using the state of the art
Information and Communication Technology (ICT) tools used in human resource
screening and recruitment procedures. The processes to be followed for SDF
would not be exception to that as well. Our ICT tools and expertise would be
utilized at every step of the HR screening and recruitment processes. The steps
are as follows:

1.      Pre screened of about 8,000 applicant’s CV by expert
professionals.

2.      Advertisement for Recruitment

3.      Collection of CVs from candidates

4.      Develop a Database for Candidates

5.      Use a custom built software to be used for selection
and recruitment of          candidates.

A  Use of ICT for Database Design and
Software development:

ICT
professionals at Rapport Bangladesh Ltd have used the standard software
development methodologies for development of the candidates’ database and
custom built software for recruitment processes. Software Development Life
Cycle plays a critical role in the development of a new system and RAPPORT has
incorporated standard procedures to keep track of the project.

B  Requirement Elicitation:

The
first life cycle activity is the requirement elicitation that has helped the
stakeholders to determine what information and information processing services
are needed to select the best candidates for the service and functions of the
SDF. During this process, the requirements gathering team attempted to discover
important information about how different responsibilities are performed at SDF
at the current scenario and how SDF would need to perform their job in order to
meet future demand.

C  System Analysis:

Analysis
phase immediately followed the requirement elicitation phase and started with
the software requirement specification generated from the requirement
elicitation phase by RAPPORT. The next process followed were the requirements
structuring and strategies for the subsequent system design. 

D  System Design:

System
Design phase used the outcome of the requirements elicitation and analysis
phase of the IT team. This phase elaborated system design methodology in
relation to system analysis.

Object-Oriented
Analysis and Design (OOAD) and Rapid Application Development (RAD) are the
popular system design methodologies. Both of them draw on principles
fundamental to all systems analysis and design approaches. OOAD truly blends
analysis with design through the evolution of techniques but RAD is more of a
general strategy of developing information systems.

E  Software Development:

Software
Development phases will be coordinated with the requirements elicitation and
structuring process. This phase will transform the requirements into meaningful
abstraction through the data structure, algorithm and coding of the business
processes.

F  Testing and
Deployment:

Testing and Deployment phase finalized the SDLC life
cycle and the target solution was taken for the test run. This phase was
carried out on functional test of different application modules and processes
based on functional specification.

G  Potential problems and technical approach adopted to address
them:

Technology used

The
whole system could be divided in two different parts. In one part, system
design team members have arranged the interfaces and other necessary designs
and in another part developers have stored all the details of candidates in the
databases. In doing so, the following technologies were used:

Interfaces:     

·
php

·
Ajax

·
Java Script

Database:       

·
MySql 

The
database and system development team have intentionally used open source
technology to avoid any license fee to be paid by SDF in future.

Basic Analysis of potential Candidates from Database

Analysis: In the database total number of candidates was 8,604.
Among them 4,845 were primarily pre-selected for MCQ test in four different
centers in Bogra and Barisal.

Please
find the comparison between number of posts, total number of candidates and pre
selected candidates in the following graph:

Analysis:  It was found
that the highest percentage of pre selected candidates were from District
Accountant post. Here around 79.77% candidates were pre selected. Where as only
12.39% candidates were pre-selected for District Program Officer (ECCRR) post.
The number of selected candidates was only 27 where the unsuccessful candidates
were 191.

Please
find the comparison between pre selected and unsuccessful candidates in the
following graph:

Analysis:  It was found
that the highest number of pre selected candidates were for Cluster
Facilitators (1 for 5 villages) post. The total number of pre selected
candidates for this post were 2,052 where as for District Program Officer
(ECCRR) post the number of pre selected candidates were only 27.

Please find the pie chart of the pre selected
candidates for the respective positions:

(due to large number of partitions it was not possible
do show the labels in the graph. But you may view it from the table below)

XI        List of reports that may be generated from Candidate Information
Management System

1)
Position wise summary of all candidates

2)      Position and selection status wise candidates summary with percentage 

3)      Position wise pre screened candidates gender
distribution summary with
percentage

4)
Position and applying district wise candidates summary

5)
Home district wise candidates summary

Applied District Name:

6)
Position wise all candidates list

Position
Name:

7)
Position wise all pre selected candidates list

Position Name:

8)
Position
wise all rejected candidates list

Position Name:

9)
All SDF candidates list

10)  Position
wise all pre selected candidates mailing address list

Position Name:

11)
Position wise pre-selected candidate details

Position Name:

12)
Position wise candidates preferred district and home
district list

Position Name:

13)
Position wise candidates highest qualifications

Position Name:

14)  Position
and district wise female candidates list

Position Name:

Applied
District:

15)
Position and applying district wise candidates highest
qualification list

Position Name:

16)
Position and applying district wise candidates with
work experience list under certain parameter

Position Name:

Applied
District:

Minimum Work
Experience:

17)
Applying district wise candidates list

Applied
District Name:

18)
Applying district wise candidates summary

Applied District Name:

19)
Home district wise candidates list

District Name:

20)  Position
and home district wise candidates list

Position Name:

District From:

21)  Position, applying district and selection
status wise candidate summary

22)   Individual
candidate’s profile using unique candidate number including photo

23)  Position and
district wise pre screened individual candidate’s Admit Card with photo

24)  Position and
district wise pre screened individual candidate’s mailing address

Candidate’s
sitting arrangement

Analysis of Result

Analysis: The number of pre selected candidates who have
attended the examination were 1,873 which is about 39% of the total pre
selected candidates. Among them highest number of candidates were for Cluster
Facilitator (1 for 5 Villages) post. The lowest percentage of turn out was for
District Program Officer (ME &L and MIS) post with only 25% attendance.

Total
Application Received:    8,604 

Pre selected Candidates:          4,838   (56.22 %)

Appeared
for MCQ:                 1,873   (38.71%)

Analysis: For Cluster Level posts, maximum number of candidates
has scored between 71 to 80. If we accept the pass mark to be above 50, then
around 88% candidates would pass the MCQ test. But if we consider above 40 as
the pass mark then around 95% candidates would pass. The total number of
candidates appeared in the examination were 1529.

Analysis: For District Level posts, maximum number of
candidates have scored between 61 to 70. If we accept the pass mark to be above
50, then around 75% candidates would pass the MCQ test. But if we consider
above 40 as the pass mark then around 93% candidates would pass. The total
number of candidates appeared in the examination were 344.

Analysis: Four sets of questions were used during the
examination. It was expected that candidates from Cluster Team Leader to
Cluster Facilitator ‘Technical’ would answer using C and D set. Where as
candidates from District Accountant to District program Officer (ME & L and
MIS) were expected to answer using A and B set.  Please find the actual number of candidates
who have used the different sets of questions.

Analysis: Four sets of questions were used during the
examination. It was expected that candidates from Cluster Team Leader to
Cluster Facilitator ‘Technical’ positions would answer using C and D set. Where
as candidates from District Accountant to District program Officer (ME & L
and MIS) positions were expected to answer using set A and B.  Unfortunately, 33 candidates from Cluster
Level positions have used set A and B, where as 12 candidates from District
level positions have used set C and D.
The mismatch happened, since the candidates thought that they were pre
selected for vise versa positions.

Findings

After completing my
internship on Integrated Solutions Limited we see some limitations here. We
want to give some suggestions to remove these problems. We suggest the company
to take some initiatives. Like-

·
The website is
one of the main issues and contains good impression to the viewers. The current
website of ISL is not attractive and dynamic. So they (ISL) should have to
improve this.

·
There is scarcity
of manpower in ISL. So they need more manpower.

·
Setting
proper planning for each and every work as well as for the whole department.
Managerial supervision is also wanted to increase.

·
Updated
technology should be needed for ISL

·
It needs to
concentrate more on quality of products

·
Customer services
should be increases from six month to one year.

·
Proper
maintenance of files and necessary files and documents on daily basis.

·
Should increase
their Marketing strategies and activities

·
Provide and
facilitate the training opportunities to their loyal employees

At the very end of the ‘internship program’ working
three months, it can be expected that these above suggestions will help to
rearranging some infrastructures, which will support the  customers and clients based service and
maintenance  of  Integrated Solutions Limited.

Conclusions

The
internship is a key element in the technical writing student’s professional
preparation. And the internship report is a key element in the internship
experience. It is through writing the report that the maturity and professional
experience the student gained as an intern becomes fully realized. It is
through the report that the student exercises his or her critical and
analytical faculties and demonstrates newly found skill and identity as a
professional communicator.

Appendix-1:

Tables used in
the database schema

Table
Name: Educational Info

Table
Name: Work Experience

Table
Name: Position

 Table Name: Relevant Fields

Table
Name: Resume