MIS 442 Report
-
Upload
abdullah-al-salman-dipto -
Category
Documents
-
view
121 -
download
3
Transcript of MIS 442 Report
Page 1 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
Page 2 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
Page 3 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.
Page 4 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.
Page 5 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.
Page 6 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:
Page 7 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
Page 8 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:
Page 9 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
Page 10 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:
Page 11 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
Page 12 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
Page 13 of 32
Page 14 of 32
Width: 8.7 in
Service & Support
Page 15 of 32
Type: Limited lifetime warranty
Flash Memory
Installed Size: 32 MB
Core switch:
WSC 6500E Series:
Page 16 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.
Page 17 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.
Page 18 of 32
Feature Benefit
Page 19 of 32
Feature Benefit
Page 20 of 32
Feature Benefit
Page 21 of 32
Feature Benefit
Page 22 of 32
Feature Benefit
Page 23 of 32
Feature Benefit
Page 24 of 32
Feature Benefit
Cable:
Page 25 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.
Page 26 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
Page 27 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
Page 28 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
Page 29 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.
Page 30 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.
Page 31 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
Page 32 of 32
Abdullah Al Salman Database Design & Network DesignSangida Huraiya Efficiency, Input & output, Feasibility, Sayeed Hasan Investment, Problems, Limitation,
Recommendation