Selecting a Database for a Small Business Essay -- SQL Database

Jay-Star Incorporated is a small machine shop located in Lexington, Kentucky. There are only 7 employees that in reality 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, hexangular 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 rank flow of the company. This is why this database would uprise to be beneficial in keeping a more precise schedule of events. This paper will explain the purpose and requirements of the database describe, step-by-step, the process for creation of the jazz database and explains the reason or rationale for each step and, for each step, the options available and choices made for execution and explain how critical thinking and ethical reasoning were employ in the creation of the database design.The purpose of this database is to keep track of all of the events at Jay-Star Inc. The Customers plank lists all of the companies that order products from Jay-Star. It also lists the companies contact information and where they are located. The Shippers table lists all of the shipping companies that deliver materials to Jay-Star. Just like the Customer table, the Shipper table lists contact information and location of the companies. The Employees table is a list of all of the employees that actually pr... ...o make schedule keeping easier and more effective. It can tell employees what product they can expect to produce next and let supervisors know when shipments will be delivered. This paper shows the step by step process used in creati ng the database with the use of primary keys, while also explaining the thought process that went into why tables were created and the order that they were placed using the relationships of each table. Overall this project as proven to be a great test in using all of the fundamentals for this SQL class. I look forward to continued success in using SQL in my future endeavors. Works CitedData Analytics Software. http//www.1keydata.com/sql/sql-primary-key.htmlPratt, Phillip J. Last, Mary Z. A Guide to SQL, 8th Edition. P.26Journal of the Association for Information Systems, Aug 1, 2010, Vol. 11, No. 8 (Aug 2010), p. 433-454