New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

Final Systems Development


Final Systems Development fin571

Marketplace > Kaplan University > fin571 > Final Systems Development

Almost Ready


These notes were just uploaded, and will be ready to view shortly.

Purchase these notes here, or revisit this page.

Either way, we'll remind you when they're ready :)

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Final Systems Development
Study Guide
50 ?




Popular in

Popular in Department

This 0 page Study Guide was uploaded by an elite notetaker on Wednesday November 11, 2015. The Study Guide belongs to fin571 at Kaplan University taught by in Fall 2015. Since its upload, it has received 28 views.

Similar to fin571 at Kaplan University


Reviews for Final Systems Development


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 11/11/15
Bead Bar 1 Bead Bar Systems Development Your Name Axia College of University of Phoenix Bead Bar 2 Bead Bar Systems Development The purpose of this project is to identify a computerized system that will align with the Bead Bar s company goals The Bead Bar is a company that supplies customers with workshops and materials to produce their own costume jewelry using items such as wire beads and string The Bead Bar is 15 million dollar company founded in 1998 that employee 15 full time employees and 20 part time employees The company has three divisions that consist of studios franchises and Bead Bar on Board The studio division oversees the company owned siX studios across the Eastern part of the United States The franchise division is in charge of managing the supply requirements of the five franchises The last division is Bead Bar on Board which designs the portable studios that are located on crew ships Malaga 2005 The Bead Bar would like to expand their organization however the current processes cumbersome and not necessarily accurate In order to develop an information system that can handle future growth and allow better communication between outside sales offices and the head office certain steps need to be followed The executives of Bead bar would like the ability to communicate to every location and pull information such as inventory and sales The basic requirements are as follows network without noticeable cables in the studios connection between headquarters and all studio locations and access to corporate network remotely improve data collection from all locations electronic retrieval of sales information and improved work ow systems to reduce paperwork They are also interested in a strong database to store information from sales and inventory to personnel information Bead Bar 3 Proper infrastructure design and implementation is imperative to meet all the Bead Bar s requirements I have listed below the steps needed to implement the recommended information solutions Planning Phase The current needs for the Bead Bar are to have a point of sales POS terminals company wide network and a SQL database This project should take approximately four to six months to implement the entire system throughout the company Keep in mind the lead time for the installation of the wide area network WAN in the studios and Bead Bar on Board Each branch will receive multiple POS with a client platform that will connect to the corporate server System Analysis Phase The current business process of tracking inventory sales orders and maintaining personnel records needs to be evaluated The Bead Bar still uses several paper based forms and they are finding that several orders have been lost invoices have been inaccurate and there have been delays in fulfilling orders Malaga 2005 The major issue with these methods is the potential room for error With the design of a computerized system many of the current paper methods can be eliminated This would reduce employee time spent figuring out inventory tracking orders financial statistics and would better serve the customers Design Phase The system will consist of a main server that is kept at the corporate building that collets all the information from each store Each main store will have two POS and a client based PC that will collect sales information from the POS terminals and report them to the corporate database Bead Bar 4 Each branch will have a wireless networking along with routers and switches to connect back to the head office The computers will run Windows XP Professional edition The system will have a local database that will collect the information and upload to the main office after hours The network topology would be a star topology and client server architecture with wireless networking in the headquarters and the studios The network will use the TCPIP protocol This solution will require the installation of Digital Subscriber Lines DSL in the studios and the implementation of a Virtual Private Network VPN solution The issue with regard to the Bead Bar on Board would have to be a satellite solution Satellite communications cards can be purchased and will have a monthly service fee The network topology is mixed for the Bead Bar The headquarters is a local area network that is using the star topology Each device will connect via wireless to a Wireless Access Point WAP and the WAP will connect to the servers The remote sites would typically be on a dedicated WAN Due to the cost of a dedicated line for this service the recommendation is to use VPN This will allow the remote sites and telecommuters the ability to access the company s network through a secure tunnel via the internet Development Phase During this phase the equipment would be installed at each location The database will be created and evaluated Software will be loaded and placed on the system All the branch networks will be setup including the DSL lines and the wireless networks in the studios Testing Phase During this phase we will put the system in a series of test making sure that everything is working as planned The testing that will be conducted will be verification and validation The Bead Bar 5 verification test will be done by various simulations to ensure it works The validation testing will be done during the implementation phase to make sure it works during the real world environment Implementation Phase During this phase the system will be introduced to the employees and each employee will receive specific training on the proper use of the system Employees will be tested on their skills using the system to ensure problems do not occur due to poor training Maintenance Phase During this phase information technology IT staff members will make sure that the servers database network and all the other systems are working as intended Service Desk support will be provided during normal operating hours There will be on call staff for after hours emergency support for any errors or issues that may arise Backups of the database will be scheduled every night These backups will provide the recovery of data in case of a system failure The illustration below represents the layout of the network Bead Bar 6 Bead Bar Network Diagram Sammy 182003 A a Bead B r Head Of ce Sewer vf39 7 Bead Baron i V a Board 44 I I 3 INT ERNET Lo rug lala nd Studio New Canaan Studio ED sin n Studio Cannamimt Studio Washington IDC Studio Home Customers The following is the inputs and the outputs that the system will have Point of sale data from every Bead Bar counter the input will include the price at which the sale has been made the quantity and quality of beads sold and the time at which the sale took place The system will automatically input the information about the transaction into the local database The output will be the sales bill at the point of sale the new level of inventory and the total sales statistics Afterhours the local database will output the daily sales information to the SQL database at the head office The output will also give warnings if the reorder level of beads has been reached in any bead bar Database Model Due to size and demographics of the Bead Bar the enterprise database solution is the best option The database management system DBMS that is recommend would be Microsoft s Bead Bar 7 SQL Server if properly designed the database will be able to grow with the company The SQL database is appropriate for multiple locations and can store a large amount of data everything from customer and employee information to sales trends and inventory levels The next recommendation is the type of database if it is going to be centralized or distributed Due to the studios and Bead Bar on Board the best option would be the distributed A small part of the database with prices and inventory can be stored on a computer in each site In the evening the systems can send data back to the main database This way each studio can track daily sales and inventory levels daily The office will in turn pull the data from the main database and will also be able to make price adjustments that each studio will have in the morning The relational database model would work well for the Bead Bar The relational database is exible and easy to use This database model uses fields and records which are grouped into tables The tables can then be linked together through a common field Microsoft s SQL database will also support the possible use of Data Warehousing that Meredith asked about and the Data mining that Miriam is curious about With a strong database the Bead Bar will be able to store all their company related information electronically and will be able to access it in a matter of seconds With the implementation of the new company wide computerized infrastructure Bead Bar will see many benefits The studios will be using a POS system that will process customer purchases and will immediately process bills update inventory and send sales information back to the main office This will allow Bead Bar to better manage our sales and inventory levels The new accounting system will produce financial statements for any day or any location easily and effectively The website will allow customers the ability to view the catalogue sign up for Bead Bar 8 workshops make purchases check shipment status and pay their bill all Within a secured environment The implementation of the extranet Will allow Bead Bar to set base inventory levels so When inventory levels reach a certain point the supplier is automatically notified and an order is placed These features Will help the Bead bar expand outside of the US Which Will increase customer base and improve yearly revenue The main office Will have complete control over all the Bead Bars and stores on cruise ships Reference Malaga R A 2005 Information systems technology New Jersey Pearson Education Inc


Buy Material

Are you sure you want to buy this material for

50 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

Kyle Maynard Purdue

"When you're taking detailed notes and trying to help everyone else out in the class, it really helps you learn and understand the I made $280 on my first study guide!"

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.