BS07_BSBADM504B_Admin Systems_ Ass 1_V1.1

The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal

Provide a system that can modify a response to any possible circumstances, conditions, or situations that may occur in future

Considerations will be implementing upgrading the entire network the new system will rely upon, in its current state it will not sufficiently support the projected needs of the new system

4. What problems under the old system are solved or mitigated by the new system?

Another factor to ensure success is to train the IT personnel on the system’s applications and processes. How well the IT personnel understand the systems is extremely relevant to the success of system implementation. The involvement of IT personnel, who have knowledge regarding the application requirements, increases the ability of the team to correctly and quickly specify the requirements. Experienced IT personnel on a team help ensure others understand terminology and have more of an understanding of the stakeholders needs (Havelka and Lee, April 25, 2002).

The challenge is some of the past development work was done by a consultant. We have option to scale the current work which is not an industry standard and end up paying more money and band aids fixes or develop a new program that we can design and manage for our future growth knowing future growth is inevitable. The risk of continuing the current information system program is low for now, but it will be a major replacement issue for the future growth that could cost the company millions and lost business opportunities. Developing a new information system program is a risky choice from time

Identify Major Issues: Describe the major issues, both current and historical that may or have impacted the need for the project.

The purpose of this project is to conduct an analysis research into the implementation and management of this business enterprise system. This project deals with developing and upgrading the computer system to handle to daily work load of our business while being able to conduct communication between sites and data back-up. Furthermore, we will analyze other various architectures features such as: system requirements, architecture selection, resources and timeline, security and the

The increased number of IT investment is applied in organization. It is clear that information technology has become the competitive fact in world business. Collaboration is the new trend in business world. No one can deny the importance of information technology application. Besides the profits outcome, the impacts of information technology deployment also create commitment, trust and value. Advanced information system can improve each steps of business process. It enables people to share information, performance task simultaneously and making decision efficiently. IT companies designed different products to satisfy each step of business operation in terms of manufacturing and human resources. Seminole should apply this new IT infrastructure to business operation. Firstly, company can use the transaction processing systems (IPS) to keep track of all business activities and transaction of the organization such as payroll and employee record keeping. IPS also shows all information from internal and external operation. Secondly, Business intelligence systems are designed for decision-making support. Management information system (MIS) is a system that helps managers to keep track of company performance status, which purposed for decision-making and evaluation. Decision-support system (DSS) is purposed for future business decision-making. Thirdly, Enterprise application systems are designed for integrating business process from different functions, such as supply chain

1. In terms of hardware, software, databases, telecommunications, and the Internet, what specific recommendations are you prepared to make to Sewtown to improve the speed, accuracy, and reliability of their information system?

b. What will the new system accomplish? What functions will it perform? Which organization goals will it support?

Mr. Lassiter, being the manager of sales and marketing, should have addressed the entire organization of the new system changes. He did not even address the full system conversion to several of his own staff members. Also, Mr. Lassiter anticipated Kovecki had studied the documentation, which he had not. Mr. Lassiter needs to prepare a special meeting with key members of staff

5. Evaluate the steps that were taken in the ERP activities. Which were done well and which could be improved?

The main problems with the existing system and goals for the future system identified as below:

Information systems changed forever the way accounting tasks are processed. The days of green paper pads are gone, and instead businesses have a centralized place where all accounting transactions are entered and saved. No more looking for paper