mis 442 report

of 32

Management Information Systems

Submitted By Abdullah Al Salman - 1110612

Sangida Huraiya – 1220190

Md. Shakib Israq – 1320404

Sayeed Hasan - 1230213

Masiat Tabassum Sadia - 1310081

Date Course Name: MIS 442 30th March, 2016 Section: 01 Semester: Spring 2016 Subject: IUB Accounts & Finance Department

Submitted To Instructor: Abu Bakar Emran SalahuddinSenior Lecturer, School of Business.

Independent University, Bangladesh

of 32

ContentsExecutive Summary.....................................................................................................................................3

Introduction:...............................................................................................................................................4

Accounts & Finance Department Activity Performed:.................................................................................5

Hardware:....................................................................................................................................................5

Network Devices:........................................................................................................................................8

Database Design:.......................................................................................................................................14

Network Design:........................................................................................................................................15

Difference in performance before and after the Installation of System:...................................................16

Efficiency:..................................................................................................................................................16

Input & Output:.........................................................................................................................................17

Feasibility:.................................................................................................................................................18

Investment:...............................................................................................................................................18

Problems with Current System:.................................................................................................................18

Limitations:................................................................................................................................................19

Recommendation:.....................................................................................................................................19

Conclusion:................................................................................................................................................19

References:................................................................................................................................................20

List of Work Performed by the Individual Group Members.......................................................................20

of 32

Executive SummaryIndependent University, Bangladesh (IUB) has accounts and finance department which

department is maintaining all the accounts and finance related matters. This department is

maintaining many types of activities in IUB. Like tuition fees collection, supplier payments,

purchase requisition approval, employee salary payment, car parking payment collection,

convocation payment, transcript payment collection, certificate payment collection etc. IUB

Accounts & Finance Department uses 10.50.255.36:8080/IubAcct/iubUser system to maintain

its whole regular activities. The system is efficient and economically, technically, operationally

and legally feasible. This system is very helpful, requires less time, improve services than before.

We have visited to IUB accounts and finance department and CITS to collect information about

the database. Also we talk with the people who are related to the accounts and finance

department. We get the network design of this department. We get some information about

network design also how this network function actually installs and work. Sometime they face

some problems in maintenance and operation (server down, network slow etc). They back up

their all data weekly. We discussed with the department related people and took their opinion

and exasperated to give some recommendation based on the limitations of current system. The

information that we gather from them all are written over the report.

of 32

Introduction:IUB is a leading private university in Bangladesh situated in Dhaka. IUB’s accounts and finance

department plays an important role for maintain all the accounts and finance related matter.

Presently IUB’s accounts and finance department is situated at the western part of the university

building. There are more 10 employees are doing their job in this department. IUB Accounts &

Finance Department uses 10.50.255.36:8080/IubAcct/iubUser system to maintain its whole

regular activities. This system makes their daily works lot more easier and faster. The system is

efficient and economically, technically, operationally and legally feasible. By this system this

department records their all transaction and all activities. There are many software and hardware

is using in this department.

of 32

Accounts & Finance Department Activity Performed:IUB Accounts & Finance Department has three types of server: a) Database server b) Web Server (UGC authorized website) and c) LAN based web server ORACLE (used internally). Accounts & Finance Department database is used operating system of Windows.IUB Accounts & Finance Department uses 10.50.255.36:8080/IubAcct/iubUser system to maintain its whole regular activities. It is UGC authorized software and Accounts & Finance Department authority changes it as their certain need.

Activities:

Tuition fees collect: They collect tuition fees from the student on Bank Asia Ltd. & Mutual trust

bank Ltd.

Supplier pay: After receive purchase requisition, Work Order, Quality Certificate Paper,

Challan, Bill & other all confirmation and then they pay to the supplier.

Purchase Requisition Approve: The Purchase Department provides them to approve the

requisition. They talk to user department & if Budget is available, they approve the requisition.

Employee Salary Pay: They pay all employee salary into Bank Asia ltd. & Mutual Trust bank.

In this bank every employee has a employee salary account number.

Car parking Payment collect: They Collect car parking money for every car in 30 days

validity. They provide a card for each car.

Convocation Payment: They collect money 6000 BDT for every student for their convocation.

Transcript payment collects: If any student want transcript, they charge 100 BDT for student

copy & 500 BDT for Original Copy.

Certificate payment collect: For collect Certificate every student must pay a amount for that.

Hardware:As we know computer hardware is a collection of physical elements of a computer system. All of which are physical objects that you can actually touch. As per this for our Accounts & Finance Department there is 10pc, 10 printers, 4 scanners and a server & network set up.

of 32

Desktop PC:IUB Accounts & Finance Department has 10 computers of which all net activated computers are dedicated for official uses and other educational purposes to its users. Features of this Computer:

Desktop PCBrand : Dell

Model : Optiplex 3020 Mini Tower

Processor: Intel Core i3, 4th Gen

Speed: 3.60GHz, Chipset: Intel H81

Ram: 4GB,

Hard Drive: 500GB,

Monitor: 18.5’’ LED Wide

OS: Windows 7 (Copy)

Origin: USA

Warranty: 3 years

Offline UPS:

The Feature of the UPS is:

Offline UPS

Brand: Micronet

Model: Micronet 1200VA

Origin: Taiwan

Assemble: China

Capacity: 1200VA

Warranty: One year

Printer: They use Color Laser jet printer & Black & White laser jet printer for their uses. The features

are:

of 32

Color Laser Printer HP Laser Jet P 1102W/1102 Printer Brand: HP Model: Laser Jet Pro 400 M451NW/452DW

Scanner:

The Feature of Scanner is:

HP SJ 200 Scanner

Server:

The sixth generation of HP’s DL380 2U density servers features an Intel® 5520 CHIP SET with

dual socket configuration that supports six-core Xeon processors for a maximum of 12 cores.

There are 12 slots for DDR3 (800MHz to 1333MHz depending on the processor used)

Registered (RDIMM) memory that can hold up to 48GB for your intense multi-tasking

requirements that, all of which utilizes Advanced ECC memory protection. A prominent feature

of 32

of the DL380 G6 are the 8 small form factor (SFF) hot-plug drive, all fully customizable, support

Serial attached SCSI (SAS) and SATA Hard Drives. These drives can be configured into RAID

0, 1, 1+0, 5, 5+0, depending on the type of RAID controller you chose to install.

Server Monkey offers the HP DL380 G6 in a variety of preconfigured options to suit your

organizations' specific computing needs. However, this refurbished HP server is also completely

customizable, giving you the freedom to tailor your server to your precise performance and

budget requirements. And with Server Monkey's industry-leading 1 Year Warranty and out-

standing technical support, you can rest easy knowing that your HP DL380 G6 will receive the

attention it deserves.

HP ProLiant DL380 Specs:

Brand: HP Product Line: ProLiant Product Type: 2U Rackmount Form Factor: 2U Rack Processors: Up to 2x Intel® Xeon 5500 or 5600 Series Processor Cache: Up to 12 MB L3 Memory: Up to 192 GB for Registered Memory configurations Hard Drives: Supports 8x hot-plug 2.5" SAS or SATA drives Maximum Internal Storage: Up to 12 TB (with optional LFF drive cage) I/O Slots: 6 PCI-express slots Remote Management: Insight Control with iLO Advanced

Roaming Profile:

A roaming user profile is a concept in the Windows NT family of operating systems that allows

users with a computer joined to a Windows Server domain to log on to any computer on the

same network and access their documents and have a consistent desktop experience, such as

applications remembering toolbar positions and preferences, or the desktop appearance staying

the same.

Network Devices:

Router:

of 32

Cisco 3900 Series Integrated Services Routers Cisco 3900 Series Integrated Services Routers are designed to meet the application demands of

today's medium-to-large branches and to evolve to cloud-based services. They deliver virtualized

applications and highly secure collaboration through the widest array of WAN connectivity at

high performance that offers concurrent services at up to 375 Mbps.

Features and capabilities:All Cisco 3900 Series Integrated Services Routers (ISR) have modular design that allows for

reuse of a broad array of existing modules that meet business requirements while maximizing

investment protection.

Agile Application Services: Including the ability to host multiple Cisco or third-party

applications on UCS-E Series server modules that can also run VMware ESXi for mission-

critical applications at the branch office, along with application delivery assurance services

to support granular application visibility and control (AVC) that can prioritize and optimize

all types of data, voice, and video applications.

WAN Connectivity: Through the industry's widest choices, including T1/E1, T3/E3,

4G/LTE, xDSL, copper, and fiber Gigabit Ethernet.

WAN Optimization: With support for router-integrated, on-demand WAN optimization

and application acceleration through service modules.

Highly Integrated Security: With a comprehensive suite of VPN technology with IP Sec

and SSL VPNs enhanced by onboard encryption acceleration and threat defense support

through firewall and intrusion prevention system (IPS) options and further includes support

for next-generation encryption and cloud-based security.

Unified Communications: That support call processing and voicemail services and offer a

high-quality analog and digital voice and video experience through on-board integrated

of 32

digital signal processors (DSPs) and analog voice cards that support highly resilient call

management that can overcome WAN service interruptions.

Media net: That services that deliver a more visual, social, and personal experience through

video networking solutions for branch users and allow for control of media services through

AVC.

High Performance: With powerful and energy efficient multicore processors, a multi

gigabit fabric and high-performance services modules that can run multiple concurrent

services offered in a scalable manner at high throughputs.

Specification:

The Cisco 3900 Series Integrated Services Routers include:

3 RU units with up to 4 GE ports with 2 SFP ports.

UCS-E service module that can support Cisco and third-party apps, VMware ESXi, and MS hypervisor.

Up to 4 service modules, 1 integrated service module (ISM).

Up to 98 LAN switch ports, 4 Enhanced High-Speed WAN Interface Card (EHWIC) slots.

Ability to add a second integrated power supply.

Security

o Embedded hardware-accelerated VPN encryption and Cisco Cloud Web Security.

o Integrated threat control using Cisco IOS Firewall and Cisco IOS IPS.

Unified Communications

o 3 or 4 on-board digital-signal-processor (DSP) slots optimized for voice and video.

o Cisco Unified Border Element capabilities for up to 2500 sessions.

o Support for Cisco Unified Communications Manager Express, Cisco Unified Survivable. Remote Site Telephony and Cisco Unified Enhanced Survivable Remote Site Telephony (E-SRST).

Wireless:

of 32

Cisco Aironet 3501i - wireless access pointFeatures Wireless access point 802.11B/g/n 2.4 GHzNetworking

Compliant Standards: IEEE 802.11b , IEEE 802.11d , IEEE 802.11g , IEEE 802.11h, IEEE 802.11i , IEEE 802.11n , IEEE 802.1x

Connectivity Technology: Wireless

Data Link Protocol: IEEE 802.11b , IEEE 802.11g , IEEE 802.11n

Data Transfer Rate: 300 Mbps

Features: Auto-sensing per device , Cisco M-Drive technology , CleanAir technology , MIMO technology , Power over Ethernet (PoE) , Wi-Fi Multimedia (WMM) support

Form Factor: External

Power Over Ethernet (PoE):

PoE

of 32

Spread Spectrum Method: OFDM

Status Indicators: Status

Type: Wireless access point

Wi-Fi Bands: 2.4 GHz

Wireless Protocol: 802.11b/g/n

of 32

Width: 8.7 in

Service & Support

of 32

Type: Limited lifetime warranty

Flash Memory

Installed Size: 32 MB

Core switch:

WSC 6500E Series:

of 32

The Cisco Catalyst 6500-E Series Switch offers the broadest range of interface modules with

industry-leading performance and advanced feature integration. The Cisco Catalyst 6500-E

Series Switch also offers high port densities and comes in 3-, 4-, 6-, 9, 9-Vertical, and 13-slot

versions that make it ideal for a range of deployment scenarios.

Features and BenefitsLists the Cisco Catalyst 6500-E Series Chassis features and benefits.

Feature Benefit

Scalability

3, 4, 6, 9, 9-V and 13-slot modular chassis Allows flexibility and room for future growth.

Delivers up to 2 terabits per second of system bandwidth capacity and 80 Gbps per-slot for all slots. A system configured for VSS has a system capacity of 4 terabits per second.Capable of delivering up to 4 terabits per second of system bandwidth and 180Gbps of per-slot bandwidth. A system configured for VSS will be capable of delivering up to 8Tbps of system capacity.

Scales the system capacity for future needs.

High interface capacity Scales to high-density 40 Gigabit Ethernet, 10 Gigabit Ethernet and Gigabit Ethernet configurations.

Increased resiliency

Standby fabric hot sync Decreases the supervisor engine switchover time of Supervisor Engine 720 and Supervisor Engine 2T based systems to between 50 and 200 ms, depending on the modules being used.

Redundant control channel Increases resiliency to protect against backplane control channel failures.

Redundant supervisor engine option Increases availability with redundant supervisor engine options.

Redundant power supply option Supports redundant power supplies for increased availability.

of 32

Feature Benefit

Fan tray Supports hot-swappable fan trayThe 6509-V-E provides for redundant, hot-swappable fan trays.

Environmental

Side-to-side airflow (except Cisco Catalyst 6509-V-E)

Allows ease of access to ports and cables6509-V-E has front-to-back air flow to support hot aisle or cold aisle designs.

AC and DC power supply Supports both AC and DC power supply options, including AC and DC mixing.

Network Equipment Building Standards Layer 3 (NEBS L3) compliant

Supports NEBS L3 compliance for deployment in demanding environments.

of 32

Feature Benefit

of 32

Feature Benefit

Cable:

of 32

System cats 6 A:

The latest standard from the TIA for enhanced performance standards for twisted pair cable

systems was defined in February 2009 in ANSI/TIA-568-C.1. Category 6A is defined at

frequencies up to 500 MHz—twice that of Cat 6.

Category 6A performs at improved specifications, in particular in the area of alien crosstalk as

compared to Cat 6 UTP (unshielded twisted pair), which exhibited high alien noise in high

frequencies.

The global cabling standard ISO/IEC 11801 has been extended by the addition of amendment 2.

This amendment defines new specifications for Cat 6A components and Class EA permanent

links. These new global Cat 6A/Class EA specifications require a new generation of connecting

hardware offering far superior performance compared to the existing products that are based on

the American TIA standard.

The most important point is a performance difference between ISO/IEC and EIA/TIA component

specifications for the NEXT transmission parameter. At a frequency of 500 MHz, an ISO/IEC

Cat 6A connector performs 3 dB better than a Cat 6A connector that conforms with the EIA/TIA

specification. 3 dB equals 50% reduction of near-end crosstalk noise signal power.

Confusion therefore arises because of the different naming conventions and performance benchmarks laid down by the International ISO/IEC and American TIA/EIA standards, which in turn are different from the regional European standard, EN 50173-1. In broad terms, the ISO standard for Cat 6A is the highest, followed by the European standard, and then the American (1 on 1 matching capability)

Halogen free, RoHS compliant.

https://en.wikipedia.org/wiki/ISO/IEC_11801

https://en.wikipedia.org/wiki/Telecommunications_Industry_Association

of 32

Low flame spread LSFH™ jacket material. Category 6 / Class E compliant. Suitable for PoE / PoE+ applications. The central spine maintains geometry of pairs. The small diameter of Cat6 cable reduces pathway fill. Consistent performance

Database Design:IUB Accounts & Finance Department did not provide us their Database Design. They said that is very confidential matter.

Network Design:

Fiber Fiber

UTP UTP

Fiber

ISP-1 ISP-2

MC MC

Router Cisco 3900 Series

Firewall Cisco ASA 5520 Series

Microtic CCR 16103 Series

Core Switch (CS)WSC6500E

SB

SECS

CITS Live Switch

Website

DNS

Proxy

Distribution Switch Cisco 2960 Series

SLS

VC Office

SLASS

Registrar Office

Purchase Department

Accounts Department

Server Firm 2960 Series

Local DNS

DHCP IRAS

Active Directory

Accounts Software

of 32

Difference in performance before and after the Installation of System:

Benefits of using accounts software:

1. Checking all the detail

2. Keeping it legal

3. Cost savings

4. On-screen input and printout

5. Automatic updating of student’s accounts in the ledger

6. Speed

7. Accuracy

8. Up-to-date information

9. Staff motivation

Before using accounts software:

1. Hard to check all the detail manually

2. Use of paper cost was higher

3. Keeping the record manually

4. Failing in automatic update because of manual record keeping

5. Demotivation of staff

6. Taking too much time to find the data

Purchase Department

Accounts Department

of 32

Efficiency: Accounting Software can easily and efficiently be installed. A complete modern Web-based,

Multilingual ORACOL system, Using accounting software, it is very much efficient in terms of

cost, time, and service. At the beginning, to install software one needs technical support and get

it running on an HP server. But once set up, information across and running day-to-day is

straight forward.

Input & Output:

Fig: Input System

of 32

Fig: Student Ledger Output

Feasibility:IUB accounts have accounting software which is provided by the UGC, if they develop this from

outside then it might cost a lot. They are using a complete modern Web-based, Multilingual

ORACOL system. So, IUB accounts system is economically feasible. This system is very much

proficient in cost saving. It has reduced the waste of time by providing good on-line service.

Investment:Some IS projects may be not be attractive from cost or benefit aspects; they may have a high

effect on corporate performance. Accounts system will be revenue related projects though it is

provided by UGC. The benefits arising from this system are hard to count and hence they appear

to be unattractive from cost-benefit viewpoint. Though the system is gained from UGC but its

maintenance and other facilitate services have a cost which is considered as revenue investment.

Businesses often do not perform cost-benefit analysis for such projects. IUB Accounts

Department provides user focused services. So it can be said that it’s a revenue related

investment.

of 32

Problems with Current System: Maintenance and Operation:

They use UGC authorize software system which is only can change by top finance

and accounting director and deputy director.

Back Up:

They backup their file and transaction in every week. According to the finance and accounts senior accounts manager, currently there isn’t any problem in backup system of the data. The database or data or processed information backup has been done weekly in the main server.

Security:

It’s not open system for all so it’s very secured system. There is no possibility of

losing saved data or being damaged or being hacked.

Limitations: The server where the Accounts software system’s database is saved is under the control of CITS

department which provides services to other departments’ systems. So if the main server falls

then the library authority nothing to do with server until the CITS department set up the server.

IUB Accounts Software is UGC Provides software. IUB Accounts just customized it as its needs.

So So Customization may not be as great for that department..

Documentation is limited and aimed at Accounts Software developers. There usually is limited

technical support, especially for users of the software.

Recommendation: IUB Accounts Department should use a high speed server which has more space and physically

good.

Though Accounts Department has no own server, dependent on CITS. It should buy a new server

though it will be more expensive and require more manpower and physical location.

of 32

IUB Accounts & Finance Department should use licensed software which will more effective for

them.

Conclusion:10.50.255.36:8080/IubAcct/iubUser is well-established software and perhaps one of the most

efficacious software currently. It is user friendly and supports the mission of Accounts & Finance

Department. But it is comparatively new and verified software. Accounts & Finance Department

authority faces different kind of problems in maintenance and operation. To get rid of these problems

IUB Accounts & Finance Department can own their particular licensed software though that will be more

expensive, time consuming and require more manpower to authorize that.

References:1. Jyotishi Das-Deputy Director, Finance Accounts Department

2. Mohammad Sohel Rayhan- Senior Accounts Officer, Finance Accounts Department

3. MD. Touhidul Islam- Senior Accounts Officer, Finance Accounts Department

4. MD. Zamanul Rasheed- Manager, CITS

5. MD. Ibn Saeem Reza- Senior Officer, Service & Support, CITS

6. Khandakar Shoukatur Rahman- Web Developer, CITS

List of Work Performed by the Individual Group Members

Group Member Name In which part they have worked

Masiat Tabassum Sadia Activity PerformedMd. Shakib Israq Hardware & Network Devices

of 32

Abdullah Al Salman Database Design & Network DesignSangida Huraiya Efficiency, Input & output, Feasibility, Sayeed Hasan Investment, Problems, Limitation,

Recommendation

mis 442 report

Documents