CHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?</para></question><question id="ch04ques02" label="4.2"> Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in …show more content…
Thus, students choosing this option need to present reasons why they think such a radical change would succeed. * The use of a schema for accountants seems quite plausible. It does eliminate the redundancy of double entry from the database system, yet it still provides a framework familiar and useful to accountants and financial analysts. * There is a good possibility that double entry will remain, even in databases, due to inertia. Indeed, many modern AIS, such as ERP systems, use databases but also retain the principles of double entry. 4.4 Relational DBMS query languages provide easy access to information about the organization’s activities. Does this mean that online, real-time processing should be used for all transactions? Does an organization need real-time financial reports? Why or why not?</para></question></general-problem></problemset> On-line real-time processing is not necessary for every business transaction. For example, batch processing is adequate for payroll: there is little need for the data to be current except on payday. Real-time financial statements are useful for planning and provide management with better ability to react to changes in the environment. Nevertheless, real-time financial statements may present distorted pictures of reality if accruals have been ignored or not properly recognized.
4.5 Why is
In today's time the accounting and book keeping ranges from the old way of paper and pen to extremely large accounting data base systems for the major companies and organizations around the world; although either system could be used but
Figure 11 shows the relationship of a database using DBMS, connecting the user with the information from the database. A database consists of many data from customers to orders, services, employees, and so on. The user can be a customer or employee. Employees use DBMS to find customer’s information, service types, and service provider information. Later in the process, the DBMS will then extract data from the database to answer the users’ questions.
The global information system will require the use of internet technology managing financial documents, inventory reports, sales reports, marketing information and human resources. Sparked by intranet (internal networking) and internet (connection to the worldwide web), real time information can be relayed to headquarters for reporting data supporting store operations. Internet based databases like those offered by Oracle offer a nearly user friendly solution to implement when dealing with massive data transfer derived from store operations. Monitored and ran by headquarters, this global information system will feed, track and report several financial documents used by headquarters for earnings reporting; income statements, profit/loss statements and cash flow are among the most important when reporting to stakeholders. The store will input sales, food cost, labor cost, controllable expenses and facility costs for projected costs. Further,
Connolly and Carolyn (2004) define a database as a structureordesign that consists of theclient’s data as well as metadata. It is also a persistent, logicallycoherentrepository of inherentlymeaningful data that is relevant to someaspects of therealworld. The database consists of data organized in a systematicway, anditallowseasy retrieval of information, analysis, updating andoutput of data. Thatdata can be in theform of graphics, scripts, reports, text, tables, andsoon. Most of thecomputerapplications are databases at their core. Manycompaniesusuallyhave a lot of data, andsotheyhavebig databases that can handlethatlargeamount of data. It is wherenothe database administratorcomes into playtopensurepropermanagement of the database sothatthe organizational data is safe from anyintrudersor data corruption (Jones, 2014). The database is whatcontrolsthedata of theentireorganization, andany tampering of the databases can culminate to the stoppage of businessoperations.
Metadata present a more complete picture of the data in the database than the data itself.
Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.
In the modern day it is important for any business to have a good knowledge of different accounting process and help to understand how the business operates. Anyone from potential investors to stakeholders could look to see how well the business is going. We all know that any kind of idea could fail if their owners doesn't very carefully manage the business accounts.
An Accounting Information System (AIS) is a system that collects, records, stores, and processes data to produce information for decision makers. (Hoggett J., 2012) Accounting software began with programs written to automate common, repetitive bookkeeping transactions for businesses but now over the time it have become increasingly sophisticated and customized for specific industries especially for construction companies. (Bagranoff, 2008) Enterprise-wide software is incredibly powerful, complex, and is capable of collecting a wide variety of data to support business decisions. It is the core of business information systems. Accounting Information System increases the financial performance, productivity, efficiency, synchronize workflow and also improves forecasting & decision making. (Bhattacharya, 2008)
The importance of records is frequently related to its timeliness. Useful records must get to decision makers regularly and fast. To offer timely statistics, accounting
Speed is an obvious benefit that computers offer, one of which tends to naturally increase efficiency. The fast processing automation is capable of means that faster transactions are made, like the staff payroll system which is part of OAS,
Database Management System (as known as DBMS) is a set of application that enable user to create, edit, update, store and retrieve data from database files. By using DBMS, data in a database can be added, deleted, changed, sorted and searched. DBMSs are usually used to manage employee information of a big company, customer information and stock information.
Data is the most important component of the DBMS. The main purpose of DBMS is to process the data in efficient and convenient way for the users. In DBMS, databases are defined, constructed, modified , inserted and accessed from the database. There are two types of data in the DBMS. They are
database can also be thought of as an electronic filing system. Data and information are
A database is a collection of information sequenced and organized in such a way that the computer may be able to source and access it on demand by the operator. Like any other management system, a database management system is a collection of programs and protocols that enable the user to enter, sequence, organize, retrieve and select data on demand. Thus, a database management system (abbreviated as DBMS) can be defined as the cumulated system that helps the user to access and make effective use of a database on proper authentication.
In DBMS, by using the normalization concepts on tables, we design the database in such a way that the data is not duplicated.