Strayer University: Week 3 Business Quiz 2 Chapter 3 Questions

The use of data in today’s commercials is a vital role that cannot be overlooked. That is there is a need to backup data on physical mediums. The main mediums are hard-drive, flash drive, optical disc, and tape drive. There is multiply different version of each main type of medium. These different physical mediums store data in different ways. Fragmentation can also be an issue for some of these physical mediums. I will cover each medium in a little depth because of the different types available in today’s market.

1. Why is it necessary to plan a file structure carefully? What can happen if it is too loosely organized or too detailed.

Why are databases important to business? How do databases generate sales and-or profits? What databases do you interact with, and how do they benefit you?

Q1: How is a file processing system or spreadsheet different to a database system? What disadvantages does the database approach address.

2) A vast majority of business data is captured and stored in text documents that are structured.

Improved Data Sharing: Data is retained by usual business processes and manipulated on a server is available for designated users (clients) over an authorized access. The use of Structured Query Language (SQL) supports open access from all client aspects and also transparency in network services depict that similar data is being shared among users.

Patient records, pharmaceutical records, will each have a dedicated data mart while financial and personnel records will share the third. Each data mart will backup to the data warehouse every 24 hours or as Riordan’s IT department specifies. To minimize disruptions at individual facilities should a data mart be temporarily cut off from the network active records are to be kept in local servers will which upload any updates needed to each data mart on an hourly basis. In this way should any given data mart become unavailable local facilities will still have access to active records.

Organisations need data as a point of reference or to be able to retrieve information whenever it is needed. Every organisation should keep accurate records and information on their employees in order to be able to use this information for planning ahead for the business. Organisations also need data as a legal requirement.

Moving on to question three, I ask “what filing systems are used: alphabetical, subject, geographic?” Wendy answered, “Well, we mainly use alphabetical. As I said before, we use subject and location to label folders, but inside those folders are arranged in alphabetical order. The Social Assistant Management System (SAMs) account and SchedulePlus system can be set to quarry by first or last name, phone numbers, location, birthday and even poverty levels. Our hard copies that need to be scanned don’t have an order, we just put them in a folder and scan them when we can.”

a) “to be able to retrieve information whenever it is needed. For example each organisation has to keep accurate records or information of their employees in order to be able to use this information for planning ahead (…)

3. What would you recommend as effective methods for this organisation to store the data, and why? (Give two different options)

20. One advantage of a database system over previous data management approaches is that the database system is

In a centralized database, all data of an organization are kept in a single computer as a central processor or server. Users in remote locations access data by using WAN by application software provided to access data. The centralized database (the central processor or server) should be able to satisfy all requests from the system; therefore, it creates restricted access. But since all data resides in a single location it easier to maintain and support data. In addition, it is easier to maintain the integrity of data, because once the data is stored in a centralized database, out-of-date data is no longer available in other places.

Different organisations that they are surrounded by data that come in variety of forms: records, instructions, design, blueprints, maps, image, sounds, metadata, detailed data, and summarized data, to name just a few which still does not satisfy their information need. This information is stored in places ranging from file cabinets to

• Easy data retrieval: At the user’s command, data can be retrieved either from a particular table or from any number of related tables within the database. This enables a