I need assistance with the items listed below. Please read thoroughly before accepting bid – Plagiarism will be checked. Thank you.
Prior to beginning work on this interactive assignment, read Chapters 1 and 2 of your textbook as well as the Relational Databases 101: Looking at the Whole Picture Online Resources, (Links to an external site.) and review any relevant information in this week’s lecture.
In an attempt to manage their data, small to midsized organizations use Excel spreadsheets or file sharing systems. This may be sufficient when the company is small, but as companies grow these methods exhibit some major shortcomings and limitations. For this interactive assignment, you will take on the role of a consultant who has been employed by a growing business to evaluate whether or not Excel is still a viable solution. For several years, the company has opted to use Microsoft Excel to track its inventory due to its ease of use and flexibility. However, the current Excel inventory spreadsheet includes over 20,000 records and the company has recognized that searching for specific inventory records or generating reports is difficult. As part of your position, you must generate a memo to the executive board that explains the following elements and suggests a course of action for the company. Be sure to support the views presented in your memo with statements from your required resources. (Information on Writing a Business Memo, as well as a Business Memo Template, and a Sample Business Memo are provided for your convenience.)
In your memo, describe at least three limitations associated with the use of Excel and explain in general how they might affect business operations for a growing company. Describe how databases can help address these limitations, particularly with the search and reporting capability. Explain how databases can help the organization better manage its data than the current Excel solution. Describe some of the different database functions that would be involved in this data management. Use your required resources to support your statements.
A minimum of 250 words .
Prior to beginning work on this assignment read Chapters 1, 2, and 9 of your textbook, review the Database Lifecycle (Links to an external site.) and (DBLC) Database Life Cycle (Links to an external site.) online resources, and review any relevant information in this week’s lecture. These sources will be used to support your work in the assignment. It is also recommended that you log in to your virtual lab environment and make sure you can access the Structured Query Language (SQL) server housed there.
Successful database development must appropriately reflect the information system of which the database is a part. In order to ensure that the database captures the needed information for the target information system, database architects must work within a framework known as the Database Development Life Cycle (DBLC). The DBLC includes steps ranging from initial assessment and analysis to operation and maintenance. This assignment will be the first step in the creation of your Week Six Database Design Project.
For this assignment, analyze the user needs laid out in the ISM641 DBLC Scenario in order to facilitate the development of a database life cycle for the project. Within your paper describe the steps of the Database Development Life Cycle as it relates to the ConstructCo needs. Explain the analysis, design, implementation and testing tasks needed to complete each step within the DBLC for ConstructCo. For the conceptual design phase of the development, describe how unstructured data can be converted to structured data. Explain a minimum of two challenges, either business or technical, you might face when implementing the DBLC process and suggest ways in which you would overcome these challenges. Use evidence from your required resources to support your statements.
The final portion of your paper will be a one-page professional memo that will explain the DBLC steps to the ConstructCo executive team. The objective of the memo is to gain buy-in for the database development process in order to ensure successful project implementation. (Information on Writing a Business Memo, as well as a Business Memo Template, and a Sample Business Memo are provided for your convenience.)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more