Database Exercise

Databases police squad B ACC/340 June 13, 2011 Richard Calabria Databases In todays business society, technologies such as databases are a vital federal agency of just about any major retail business including the Riordans organization. Many people conthrough the importance of the role of databases in business because they are integrated so well. Databases definitely affect the output case of the news report cycle because it includes bon tons financial data and other external reports that are derived from the database.The bottom-line is that databases raft have a major impact on all of the report system cycles. Capturing the Output Financial rumors and other external reports The output part of the accounting cycle is extremely important because the information essential meet legitimate guidelines. Because external financial statements are used by a diverseness of people in a variety of federal agencys, financial accounting has harsh rules known as accounting standar ds and as generally accepted accounting principles (GAAP) (Price, 2010). In order to meet such expectations the input (sales invoices, payroll period card, etc. and Transaction Processing (journals, ledgers, trial balances) that proceed the output part of the accounting cycle must be accurate. Having a manager cow chip the data inputted in the database versus the sales invoices, payroll cards, and other inputted data is a good way to ensure that the output get out be accurate. Entity kindred Diagram for the Output part of the Accounting Cycle Entity relationships in a data base are a major component inside a firm or a business or political party that tells a story or passage about the events related to node or consumer usage to that attach to.Economic events and information in relation to who and what had involvements to that company. The Who of a crabbed company is called the Agent which is participants of a act between the customer and the sales representative while, the what is the event inside the SELLS PRODUCT TO activity itself? CUSTOMER SALEPERSON AASSETS &8212&8212&8212 &8212&8212&8212- &8212&8212&8212- IS DEPLETED BY SALES CASH ASSETS INCREASED BY SALE INVENTORY AASSETS &8212&8212&8212 &8212&8212&8212- &8212&8212&8212 The in a higher devote diagram indicates the salesperson making a sale of product to the customer.This transaction will deplete the inventory on hand for Riordan but will increase Riordans hard currency assets by the sale. This increase in cash asset will then be reflected in the financial statement of Riordan. Accounting Assets generate imagerys from these events through the sale of inventory. To become a resource an entity must pass a couple of test, one being an quarry of value, two being an object of interest. In an accounting cycle an Entity must mirror an accounting cycle to design a blueprint to get under ones skin a database. I (Quintin) used to work for a company called S. M. I. L. E. , from 2002 to 2008 and it w as a small company containing a very small database which was ran and set up by about 4 to 5 departments. The company was funded by a government grant that they used to help poor families with their bills and sometimes vent out food baskets to needy, not just around the holidays but when the cash were available. The key to receiving funds depended on the income of a household, which means that they had to qualify for the assistance. present is fictional table of how the system (database) would apply Employee Department Roster occupied (Employee) Last NameFirst NameDept.MangerLocationPhone Number BroussardTonyaAccnon/app. Bldg4 233-0001ext. 301 AnthonyFredH/RectempBldg2233-1200ext. 412 YoungVeraCust/Sfull/repBldg1233-0001ext. 719 In this table the different departments for the company were all distributed in a table that showed who ran what department and that which was how the same way the payroll was set up and displayed for accounting cycle which are done by the managerial emp loyees inside of a business. Conclusion In closing, it is discernable that the role of technology in particular the database has become an important part of the business world.Riordan manufacturing integrating the database into their business will realize positive impacts in their accounting and overall efficiency that otherwise would be impossible to accomplish. Businesses, who do not take advantage of todays technological advances, place themselves at a big disadvantage to their competitors. The bottom-line is that most businesses would be mettlesome and maybe even be forced to close their doors without technological advances such as databases. References Price, R. (2010). Financial Accounting. Retrieved from http//www. accountingcoach. com/online-accounting-course/financial-accounting. html