Corporate Proposal for SQL Server
LaTanya White
Manish Patel
ITS 410 – Database Management
March 27, 2016 Corporate Proposal for SQL Server
ESL Inc. has tasked me with the project of finding a new database system that will better meet the needs of their growing customer base. ESL is a large company that has been using a series of spreadsheets and access databases, and manual records to track their business and they are currently looking for a better way to streamline the inner workings of their business. After evaluating their current system, it is apparent, that if a decision to move forward hadn’t taken place within the next few months, their current system would start to fail, as they are reaching capacity in memory used and bandwidth running the various individual instances of Access on their network.
The following proposal is therefore a look into what Microsoft SQL Server 2012 has to offer to bring the system to the level that is sufficient for their current needs, and has the potential of growing as the company grows both internally and externally.
After spending several weeks reviewing the current system, data files, Access databases, and evaluating the current usages and the needs for the future system, I am confident that the system that would be most beneficial and useful in this environment is Microsoft SQL Server 2012. Microsoft offers several editions for SQL Server 2012, and I think the most flexible, and reliable version for ESL’s environment is the
Barnes and Co. offered a strong ERP system, X3, which focused on growth in manufacturing, distribution and service industries. It aligns with LSFF’s current strategy for advancing into new markets and as it serves more than 170,000 it is confident to say that if LSFF encounters any IT issues, Barns and Co. will have the capacity to support its needs for that function. The Underwood Group has proposed Microsoft Dynamics NAV, which offered more of a cohesive package that encompasses the functions that LSFF is lacking. It would eliminate the need for manual processing as it has automated the data function to receive more real-time information, which would mitigate any further problems for tracking orders. It has also integrated a reporting component that would reduce the time it takes for an employee to generate a monthly performance report. As a complete package, I believe Microsoft Dynamics NAV is more suitable for LSFF’s current and long-term needs as it provides a more integrated and functional system to operate
Which database management system platform should I use? This is a very common question that developers ask themselves when they work on a project that requires storing and querying data. There are 4 well-known platforms that people may consider; they are: Oracle, Microsoft SQL, Teradata and DB2. This essay will compare and contrast the differences and similarities between these fours platforms.
This must be in your own words and not copied and pasted from the original source. Include the purpose of the database and the subject matter it covers. This may be four or five sentences; and
Our company needs to be installing a latest and advanced ERP system which makes us fully utilizing the business resources in the most efficient manner. Currently, the existing information system does not provide the full, accurate and reliable information from one department to another, neither it’s a cross-platform for information sharing(Columbus, 2014). A less-efficient information system is contributing into increasing cost of production for the business and overall reducing the business efficiency. The inventory turnover is increasing over the time period and so the productivity of staff unable to work at their optimum level. The current information system does not cover the whole business process and rather employees are engaged in manual data recording and preparing the documents to back the data.
The use of huge databases that combine all of a company 's data and allow users to access the data directly, create reports, and obtain responses to what-if questions is referred to as:
Up until this point, Third Star Financial Services has operated via a succession of mergers and acquisitions where systems were inherited but never integrated into the network. Its data management has been virtually non-existent and entirely ineffective. Evidence of this can be found in the absence of an enterprise-wide data management solution and the presence of several disparate systems operating independently with no measurable benefit to the company. Due to a lack of actionable data, management makes decisions based on instinct rather than through analysis. A direct consequence of this is a steadily declining market share and loss of high-level employees to competing companies. Fortunately, this discrepancy has been identified and Third Star executives have established the new goal of modernizing and streamlining operations. Using concepts outlined by the Data Management Association (DAMA), this proposed enterprise architecture will allow Third Star to transform their data from a liability to an asset.
1) Before using any DBMS, the creators should have created a data model from the users' requirements.
New applications will utilize off-the-shelf software components that have been customized per Riordan’s specifications and further messaged to ensure that each application will integrate smoothly with all the others in order to create a single cohesive whole. Great effort will be made to ensure that the data structures used in each are consistent in order to simplify the creation of the enterprise’s database. To help facilitate this, we will create an umbrella application that will integrate each other system as a module. This umbrella application will be extendable as needed and will act as a single-launch point for the various systems utilized by Riordan. We will also be working closely with Riordan’s IT department to develop a bridge that will enable them to easily port their existing databases into the new one automatically.
As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.
The information system that will be implemented is largely based on semantics technology and essentially functions as a solution to manage spreadsheet data. However, it is important to note that this system will also assist with information stored in relational databases as well (No author, 2012). The primary users of this system include both business as well as operations personnel. There may also be some IT involvement as well; however, the highly intuitive nature of the system that will be used (which is called Anzo Express and created by Cambridge Semantics) should minimize IT involvement once the actual system is properly set-up and implemented. This information system enables users to link data from different spreadsheets and relational databases. It is able to do so in real time. Additionally, it has reporting features that are both traditional and web-based for ease of accessibility. There is also a web-based dashboard that can be used. This information system allows for the aggregation and integration of various data that can be viewed by users in a variety of different ways.
Hudson argues that the authoritarian structures in social institutions undermine our ability to learn how to become good citizens. This argument is consistent with experiences throughout my life as a child, student, and employee. Throughout the years I have learned that in structures like this it is near impossible to effect meaningful change. Hudson argues that the authoritarian structure of school, work, and other social institutions diminishes our ability to learn how to be good citizens.
The Database will be using an Oracle system and Microsoft Access in between the software and hardware design.
It is recommended that GRW Inc obtain and implement the Enterprise Edition of SQL Server 2012. The Enterprise Edition will undoubtedly contain features that the company will not use, by choice or by lack of necessity, but those features will be available as the company grows and its needs change. Of particular interest in the Enterprise Edition is the advanced security and advanced high availability features which are not components of the lesser editions. According to Microsoft, these features add “transparent data encryption, SQL Server auditing, multiple active secondaries, and multi-site geo-clustering” (n.d.).
in order to create possibly the most effective and versatile workforce of any corporation in existence. To study Microsoft's way of doing business is to look at the company from many angles, from a managerial and organizational standpoint to its process of developing products and services for its customers and its competitive environment. The purpose of this paper is to analyze Microsoft from a strategic fit
Its mind numbing to reflect the amount of technical change that has taken place in only a short period of time. In this current age, innovation has opened doors to a wide capacity for data collection and management. An example is the amount of business use with Microsoft Access. Businesses have gained from Access’s technical capabilities by using it to offer a wide range of ways to add value and efficient to any facility. Today we use Access databases to organize the way we live and work. This software is very technical savvy and uses tables, fields and records to organize company data and ultimately to speed up solving any business problems or inquires. Team B has developed a Microsoft Access