Selecting a Database for a Small Business Essay - 1076 Words

Jay-Star Incorporated is a small machine shop located in Lexington, Kentucky. There are only seven employees that actually work on the shop floor. Jay-Star produces metal core and distributes that core to various aerospace manufacturers. There are three different types of core that Jay-Star produces: Square Cell, Hexagonal Cell, and Beneflex Cell. Each of them can be produced using different materials from various shipping companies. The employees take these materials from the shipping company, produce the product, and then deliver the finished product to the aerospace manufacturer (customer). For a small company, Jay-Star keeps a very hectic schedule. Any miscalculation on shipping dates could be disastrous for the order†¦show more content†¦The last three tables are probably the most important in the database. The Orders, Product, and Order Line Items tables connect it all together. They show how each customer gets each product, how the product gets there, and when it is s upposed to arrive. They also show how much each product costs. The requirements of creating this database are to define the primary keys for each table and to show what order each table should be placed. The primary keys are simple. They are usually the number that defines each row in the table (i.e. EMPLOYEE_ID). It can either be part of the actual record itself , or it can be an artificial field (one that has no meaning other than being an identifier of the record) (Data Analytics Software). The order in which each table is created is based upon their relationships. The Customer, Shipper, and Employee tables all have a one-to-many relationship with the Orders table, so therefore, they are created first. A one-to-many relationship, in this example, is where one customer, shipper, or employee is associated with many orders (Pratt, Last p. 26). The first step in creating the database was defining each entity. Each entity would represent its own table. The entities that were established were Customer, Shippers, Employees, Orders, and Products. The next step was to determine a unique identifier for each entity. Identifiers, such as personal identification numbers, worker numbers, and license numbers, are used for identifying individualShow MoreRelatedThe Reliability Of Data Migration826 Words   |  4 PagesReliability of Data Migration Over many ago relational databases reside most of the data but after the introduction of NoSQL database had changed this procedure. Most of the unstructured data had been sent to NoSQL database. Relational database systems, which showed good performance before the birth of internet and cloud computing era is now unable to control the heat of new technologies. To stabilize this situation new requirements were set to design by RDBMS. To meet these challenges they needRead MoreEssay On Starting A Business1413 Words   |  6 PagesIt has long been one of my goals to open and successfully operate a business in the field of managing information for firms and entities across the nation. The idea first developed when I realized that corporations are constantly gaining immense amounts of information every year with difficult means of managing it. The task will be a lengthy process and consist of many downfalls and cooperation of many team members to produce the desired outcome and effect on the market. Many elements are combinedRead MoreE-Marketing1556 Words   |  7 Pagesopportunities and different channels for businesses to market to products services. Deploying an effective targeted e-marketing campaigns an important strategic decision for businesses to stay competitive and to increase profitability. The three e-business marketing strategies are: e-commerce website, e-marketing and web services using underlying web technologies including Extensible Markup Language, Simple object Access protocol, Web Services Description Language and Universal Descript on, DiscoveryRead MoreBusiness Analysis : Organizing Data And Data Crunching854 Words   |  4 PagesOrganizing Data and Data Crunching The make-or-buy analysis is heavily depending on the accuracy of the company’s database. Therefore, I need to make sure that I have maintained the database and updated the information correctly. Moreover, I also need to perform several analysis from numerous files in the database and required the ability to analyze a huge amount of data effectively and in a timely manner. Another set of Skills: Attention to Detail Attention to detail is one of the requirementRead MoreBenefits Of Spreadsheet And Database1449 Words   |  6 Pagesbenefits of spreadsheet and database, and also will recommend the suitable option for second-hand car retailer for storing data. Evidence of pros and cons will be listed so it can be helpful to choose the option. Nowadays every organization intend to use spreadsheet or database to store their data. However, when storing data it is essential to know what type of data is being stored, so that a suitable option is selected for the organization. When considering the type of business this organization isRead MoreData Warehousing : A Data Warehouse1151 Words   |  5 Pagesyears. Data warehouse: Data warehousing is an efficient system which store the past as well as current data used for creating reports. Data warehousing system is used for decision making by analyzing the reports. A data warehouse is a relational database, which is designed for analysis and query. It helps an organization to consolidate and analyze data from different sources and make decision. A data warehouse environment consists of OLAP (On-Line Analytical Processing) engine, ETL (Extraction, TransformationRead MoreInput Controls1681 Words   |  7 Pagesprovide a framework for the kind of data that will be submitted by users. Selecting the correct input control for a data field is critical. Text input, select box, radio button, and password are four examples of input controls. As pointed out by Ponce de Leon, most input controls are visual and interactive. There is also something called a hidden input control. They can be used to store system critical data, such as database key data, that the user does not need to interact with. Text typeRead MoreThe Current Scenario of Setting Up a Business1375 Words   |  6 PagesThe government of the state has allocated the funds for setting up the small business to promote the local investments and for the promotion of domestic products. The theme of the funds allocation is also to eradicate the overspills of globalization that are inhibiting the private investors to invest in the national economy. This fund allocation by the government will also instill a new sense of entrepreneurial activities at small sale and later on the economy will enjoy the unfolded outcomes of theseRead MoreHuman Resource Management Systems : Management1080 Words   |  5 Pagesbenefits management, and employment recruitment. Many businesses both large and small have begun to transition from employing multiple people to perform the task associated with running the organization. Although the human element of human resources will soon diminish these software systems help business owners w ho do not have the time or the capital to hire someone to do the jobs for them. The first initial step in selecting a product that fits the daily operations of the corporation is to understandRead MoreForeign Related Literatures1598 Words   |  7 Pagesonline  scheduling,  point-of-sale  and business management software for the beauty industry. Thousands of businesses have joined the GramercyOne family to provide online booking to their customers, manage day-to-day operations and drive new business. SalonBooker is completely  web-based, which makes it available from any computer with a browser and internet connection, anywhere at any time, even via an  smart phone or iPad. With SalonBooker you will be able to manage your business efficiently by integrating