Database Exercise

Databases Team B ACC/340 June 13, 2011 Richard Calabria Databases In right aways patronage line society, technologies such as databases argon a vital part of just intimately every major(ip) retail demarcation including the Riordans organization. Many people pardon the importance of the use of goods and services of databases in business because they ar integrated so well. Databases emphatically affect the issue part of the story wheel around because it includes ships companys fiscal data and other international reports that are derived from the database.The bottom-line is that databases can have a major impact on all of the business relationship cycles. Capturing the takings Financial statements and other external reports The output part of the accounting cycle is extremely important because the information essential meet certain guidelines. Because external fiscal statements are used by a variety of people in a variety of ways, financial accounting has green rules known as accounting standards and as generally accepted accounting principles (GAAP) (Price, 2010). In order to meet such expectations the enter (sales invoices, payroll time card, etc. and operation Processing (journals, ledgers, trial balances) that proceed the output part of the accounting cycle must(prenominal) be accurate. Having a manager demote the data inputted in the database versus the sales invoices, payroll cards, and other inputted data is a expert way to ensure that the output entrust be accurate. Entity Relationship Diagram for the Output part of the Accounting Cycle Entity relationships in a data base are a major component interior a firm or a business or company that tells a story or passage to the highest degree the withalts related to customer or consumer enjoyment to that company.Economic events and information in relation to who and what had involvements to that company. The Who of a particular company is called the Agent which is participants of a tra nsaction between the customer and the sales representative while, the what is the event inside the SELLS PRODUCT TO bodily function itself? CUSTOMER barterPERSON AASSETS - - IS DEPLETED BY gross revenue CASH ASSETS INCREASED BY SALE INVENTORY AASSETS - The above diagram indicates the salesperson making a sale of result to the customer.This transaction depart deplete the muniment on hand for Riordan entirely will increase Riordans cash assets by the sale. This increase in cash asset will then be reflected in the financial statement of Riordan. Accounting Assets furnish resources from these events through the sale of inventory. To get down a resource an entity must pass a couple of test, one being an mark of value, two being an object of interest. In an accounting cycle an Entity must reflect an accounting cycle to design a blueprint to start a database. I (Quintin) used to work for a company called S. M. I. L. E. , from 2002 to 2008 and it was a small company containi ng a very small database which was ran and set up by about 4 to 5 departments. The company was funded by a giving medication grant that they used to help myopic families with their bills and sometimes passing out food for thought baskets to needy, not just around the holidays but when the funds 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 bow of how the system (database) would fancy Employee Department Roster Employed (Employee) ut virtually(a) 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 selfsame(prenominal) way the payroll was set up and displayed for accounting cycle which are do by the managerial employees inside of a business. Conclusion In closing, it is evident that the role of technology in particular the database has become an important part of the business world.Riordan manufacturing consolidation the database into their business will realize constructive impacts in their accounting and overall faculty 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 crippled 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. hypertext mark-up language