ISM 641 Ashford University Database Functions & Design Memorandum

User Generated


Computer Science

ISM 641

ashford university



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 download, as well as a download, and a download 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.

Your memo must be a minimum of 250 words and may be submitted within the body of the discussion post or as a document attached to your initial post.

Unformatted Attachment Preview

Contact us at: Memorandum Monday, December 07, 2015 TO: FROM: SUBJECT: Ashford University Faculty Lorna Raven Wheeler, PhD. Director of the Learning Services Writing Center New video to post in your classes NEW WRITING CENTER VIDEO The Learning Services Writing Center is happy to share this new video with you and your students. It provides an accessible and fun overview of all of our major services. Please post the announcement and video in each of your classes. SAMPLE ANNOUNCEMENT Hello students! Please check out this video from our Writing Center! From paper review to questions about APA formatting, the writing center team is ready to support you. Just click the link below: qu92r Students, the Writing Center also has a vibrant website. Check it out below: Ashford Writing Center Thank you to Ashford Faculty for supporting the Learning Services Writing Center. If you have any questions, you may contact us at 1 BUSINESS MEMO TEMPLATE Learning Services Writing Center Business Memo Template This memo template may be used for most business memos (unless your company requires a certain format or use of their logo). Memorandum To: Note recipients’ names and titles From: Note your name and title CC: Here, include those who need to be apprised of the information but not necessarily the direct recipient of it. Date: Note today’s date in full, for example, 11/10/2015 or November 10, 2015 Subject: Your main point (Keep it specific and brief) You can start with an introductory paragraph. You do not need to indent. This first section explains the context of the issue or message and also sets the tone. Like an abstract in a longer written paper, the first paragraph should give a sort of overview that includes a brief explanation of the topic of concern and a forecast of what is to come. The second paragraph or body of the memo should be very specific and get to the heart of the matter. Note the issue and the solution. If a solution is not yet available, note the issue and the course of action. Each line should be single-spaced, with an extra space between paragraphs. It is possible that you will need two body paragraphs if the subject is complete or requires more than one course of action. This option is fine. Do remember to practice good writing strategies including using smooth transitions between points. Additionally, using headings can be useful when your issue is particularly complex or multi-layered. Headings will serve as a sort of road map of the most important points. The closing paragraph should both sum up the main points of the issue and also serve as a directive, should readers need to take particular actions. While you want to be concise, you need not be abrupt when concluding the memo. Make sure that you have covered all key aspects of the issue and that you have laid out a clear plan of action and/or clarified your point. Created in 2015 1 WRITING A BUSINESS MEMO Writing the Business Memo Even in this era of texts, tweets, teleconferences, instant messaging, and email, the business memo is still widely used and absolutely essential in most intra-office communications. While writing a quick memo may seem like a relatively easy task, it is important to follow a few basic rules so that your memo effectively communicates the message you intend. Memos are meant to be brief, clarifying, single-subject documents. They may be delivered via email or sent through inter-office mail, but regardless of the form, the memorandum (aka “memo”) will always follow a formal organizational pattern. Typically, memos are used for internal communications and business letters are used for contacts outside of the organization. Still, if you are working closely with outside clients for a length of time, a memo may be more appropriate. Before breaking down the formatting expectations for a memo, let’s consider some tips that will serve you well as you enter the business arena. Rule Number One: Know your audience Depending upon your audience, the tone of your memo can vary widely. For example, if you were writing a memo to your direct reports inviting them and their families to the company party to be held at the local zoo, you would want to use a more informal writing style. Using a highly formal writing style for such a memo might achieve quite the opposite and inadvertently suggest that the company party might feel like another day at the office. Rule Number Two: Know your purpose Sometimes, a writer will send off a quick memo with competing topics and the recipient of the memo is left perplexed and wondering, which of these topics is most important? Commit to writing about a single subject/problem/goal in your memo rather than ask the reader to decide which topic is most important. Rule Number Three: Get to the point Business memos should be straightforward, accessible, and brief. They tend not to exceed one page, single-spaced, with size 11 or 12 Times New Roman font. Remember, the word “memorandum” is basically defined as succinct and noteworthy. Thus, keeping your message brief and relevant is important. If you send out several memos a day that do not really say much (for example, in a discussion of the office party, you send a memo about the flavor of cake that will be served), your colleagues will likely not bother to read your memos in the future. How to Format the Business Memo • • • • • Do not include addresses (return or mailing) as memos are meant for internal communication. No need for the opening salutation, e.g., Dear Dr. Cooper, or a closing phrase, e.g., Best or Sincerely. At the top of the page, note “Memo” or “Memorandum.” When crafting an email memo or hard copy for intra-office mail, include a concise and specific topic in the subject line. You can either format the memo yourself (following our sample memo) or use one of Microsoft Office’s templates. Created in 2015
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey, your answer is ready. Rember to replace Firstname and Lastname with your real name.

To: Executive Board Members
From: Firstname Lastname, Company Consultant
Date: April 08, 2021
Subject: Replacement of Excel Spreadsheet Inventory System with a Relational Database
Regarding the issue raised by the inventory department concerning the challenge faced in
managing inventory records using Excel spreadsheets due to the growth...

Really great stuff, couldn't ask for more.


Related Tags