This website uses cookies to ensure you have the best experience. Learn more

Business Admin Essay

1809 words - 8 pages

Barb Gordon

Royal Realty Services and Loans is a rapidly growing small business located in Southern California. Founded in 1996, Royal Realty Services and Loans specializes in providing loans and escrow services to a wide range of customers.
When Royal Realty opened its first store back in 1996, Windows 2000 was chosen as the operating system for all computers. While this initially proved to be an adequate solution, it has since outgrown its usefulness. Now with three stores, a new operating system must be put into place.
One of the most detrimental problems with the Microsoft Access database is that it is limited to a file size of only two gigabytes. While this may initially ...view middle of the document...

Each table is designed
to support and facilitate the filling of orders placed by customers in the stores. Based upon the description of the tables that was posted on Kudler’s intranet and our analysis, the tables may be described in the following manner:
The Customer table contains demographic data for each of Kudler’s customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc. Each record in the customer table contains a customer_id field that is used to link the customer to the orders that they place.
The Inventory table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc. Each record in the inventory table is linked to the Item table by the item_id and to the Supplier’s table by the supplier_id.
The Item table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store. The Item table is linked to the Inventory table by way of the item_id and to the Order Line table by the item_id field.
The Order table is used to record information pertinent to each order placed with a given store. Each order will have one or more entries in the Order Line table associated with it. The Order table is linked to the Order Line table by the store_code and the order_id. It also links to the Customer table via the customer_id field.
The Order Line table contains details on items appearing on an order. One or more order lines are associated with each order and each order line references an item being purchased with its description, quantity, price, etc. The Order Line table is linked with the Order table by the order_id and the store_code. It also links to the Item table by the item_id.
The Store table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc. The Store table links with the Order table by the store_code.
The Supplier table contains data concerning wholesalers, vendors and other suppliers from whom inventory is procured. These goods are used to prepare saleable items or are simply resold in their acquired form. The Supplier table is linked with the Inventory table by way of the supplier_id.
The purpose of the Tax table is to provide tax rates applicable to orders placed at a given store. The Tax table is linked with the Order table by way of the store_code field.
The Tender table provides a means to record the methods of payment used for an order. For example, an order may be paid for partially by cash and partially by credit card. The Tender table is linked with the Order table by the store_code and the order_id.
Recommendations for Improvements and/or Enhancements
Based on the descriptions of the tables, it is recommended that the Kudler database undergo the following enhancements. The...

Other Essays Like Business Admin

Admin Law Essay

2291 words - 10 pages LIMITS ON EXCESSIVE DELEGATED LEGISLATION MYTH OR REALITY INTRODUCTION Delegated Legislation, as the name itself suggests, means the delegation of the power of law making by the legislature to the other organs of the government. In India, there is separation of powers between the organs of the government but this separation is not in water tight compartments. Delegated Legislation in India is seen when the legislature, delegates some of the

Network Admin Essay

837 words - 4 pages In this lab, you will demonstrate the ability to work with decimal and hexadecimal numbers. Required Setup and Tools In this lab, you will need only paper and pencil to do the required work. However, the use of a calculator is permitted to verify the results of a calculation. The Windows calculator may be used for this purpose. Recommended Procedures Task 1: Convert Decimal Number into Binary Procedure 1. Convert the decimal number 125

Medication Admin Essay

894 words - 4 pages Medication Administration March 12, 2014 Medication Administration Without a doubt, the single biggest aspect of healthcare that needs to improve with regards to safety is medication administration. We, as healthcare providers, are human and therefore human errors will happen, but we still must strive to limit these errors to the best of our abilities. The QSEN Competency definition of safety reads, “minimizes risk of harm to patients and

Senior Admin Associate

4287 words - 18 pages Africa is a continent of opportunities and across its 55 states, the continent of Africa presents endless business opportunities. From new oil and gas discoveries across the region, huge growth in mobile banking and mobile technology and under-developed tourism potential countless reports show that Africa is on a growth trajectory. The economic fundamentals are clearly in favour of Africa; steadier exchange rates, robust commodity prices

Apa Guidelines

1330 words - 6 pages Title of Paper Student’s Name Course Number (ORG500) – Name of Course (Foundations of Effective Management) Colorado State University – Global Campus Instructor’s Name August 6, 2010 Title of Paper Ipsum lorem vei illum sat dolor euis mod tincidunt vei auminiure dolor in esse. Ulta ceet dolore magna si napi. Wisi e nim admin im veniam, quis nostrud. In atsvulpate velt esse meleste at semper manet sola. Ut lacreet dolore magna aliquam

Mobile Based Inventory

3142 words - 13 pages Maintenance Maintenance Stocks Stocks Products Products INVENTORY INVENTORY Price Price Figure 3. Entity Relationship of Richelle Hardware and Gen.MDSE. In this figure shows the Entity Relationship of Richelle Hardware and Gen.MDSE.The admin have the Management and it coverts three categories. First is the transaction handled the operation for Billing, Payment and Expenses of the business. Second is the Employee which also covers the

Apa Format

1495 words - 6 pages auminiure dolor in esse. Ulta ceet dolore magna si napi. Wisi e nim admin im veniam, quis nostrud. In atsvulpate velt esse meleste at semper manet sola. Ut lacreet dolore magna aliquam sic semper fi tyrannis erat volutpat. Wisi enim ad minim veniam. Dolore eu sata sfeugiat. Ipsum lorem vei illum sat dolor euis mod tincidunt vei auminiure dolor in esse. Ultaceet dolore magna si napi. Wisi e nim ad minim veniam, quis nos In a tsvulpate velt esse

Business Impact Analysis

622 words - 3 pages ------------------------------------------------- [ Business Impact Analysis ] TABLE OF CONTENTS 1 Introduction 3 1.1 Purpose 3 2 System Information 3 2.1 Points of Contact 3 2.2 System Resources 4 2.3 Critical Contacts and Resources 4 2.4 Disruption Impact 4 2.5 Resource Recovery Priority 4 Appendix A: Business Impact Analysis Approval 5 * Introduction Purpose The Business Impact Analysis (BIA) is an essential step in

P6 Illustrate the Use of Budgets as a Means of Exercising Financial Control of a Selected Company

2156 words - 9 pages if the company can’t afford to pay It then the employees can take you two to court. Again, just like the two previous points, with the admin team, it can easily be resolved, you two need to learn how to do your own admin and possibly train a few more members off staff to be able to do it to, the reason is that the admin team isn’t needed and is a waste of money. If this continues to happen next month then the business will lose a lot of money and

What I Will Do in 5 Years

580 words - 3 pages so i seen alot and we had our home open as a 24 rescue center. seen so many families broken due to addictions and lack of education this always pushed me to finish my schooling, provide for my family and then move on to a higher education. In 5 years i see myself graduating with my BA in Business Admin with my concentration in Health Service Admin and starting my MBA in Health Care Management. Within that time my sister n law will have her

It Enrollment System-Goals

1144 words - 5 pages would be one of the products to deliver. The project management team is keen to offer this product as a part of a whole and complete “enrollment system” that connects this web page with the “Main System” and the others stakeholders involved. The Enrollment System should provide solutions that respond to the needs of the students, the teachers, the admin staff and the owner committee. 2.2 Project goals, business outcomes, and objectives The

Related Papers

Business And Admin Essay

3381 words - 14 pages CAP. 1: Le persone,l’attività economica,l’economia aziendale 1.1 La centralità della persona e delle società umane Le persone fanno parte di una società, l’attività economica è fatta ed è per le persone. ← Le persone perseguono molti fini. Le persone non hanno sempre solo fini economici, si ha un progetto e si creano le situazioni adatte per giungere ad un nostro fine, ma non è sempre economio. ← Per arrivare ad un certo fine

Business And Admin Lv2 Essay

2439 words - 10 pages that affect employers in a business environment. Health and Safety Data protection Pay and Pensions 2b) List three key points of legislation that affect employees in a business environment. Health and Safety Data protection Employment rights and responsibilities 3. Identify a range of places where a person can find information on employment rights and responsibilities. You should identify at least two internal and two

Unit 3 Level 2 Business Admin

2227 words - 9 pages delegates. The final I.T that can be used for work tasks that I am putting down is Microsoft Office, probably one of the most used software’s in working companies. 1.2One benefit for using word processor is that it can create a lot of different types of documents quickly, such as business letters, invoices and e-mail. The second benefit for using I.T for work tasks is that you can send your work across by e-mail instead of having to waste paper and ink

Nvq Level 3 In Business Admin

1217 words - 5 pages 303 - Section A - Task 1a Report on Substance Data Collection System V’s Excel Spreadsheet We currently use two methods of participant data collection systems. Substance (on line data input programme) and a formulated excel spreadsheet. Substance online data input programme costs the Foundation £1,400 be annum and was developed by an external experienced social research company that specialise in working in the youth, sport and positive