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 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 flow of the company. This is why this database would prove 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 comp lete 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 applied 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 table 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 creating 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 Cited Data Analytics Software. http://www.1keydata.com/sql/sql-primary-key.html Pratt, Phillip J. Last, Mary Z. A Guide to SQL, Eighth Edition. P.26 Journal of the Association for Information Systems, Aug 1, 2010, Vol. 11, No. 8 (Aug 2010), p. 433-454