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

Jay-Star Incorporated is a small machine browse located in Lexington, Kentucky. There are only seven employees that rattling work on the shop floor. Jay-Star produces metal core and distributes that core to unhomogeneous aerospace manufacturers. There are three different types of core that Jay-Star produces Square Cell, hexagonal Cell, and Beneflex Cell. Each of them cigaret be produced development different materials from various fare companies. The employees take these materials from the transferral company, produce the mathematical product, and then deliver the finished product to the aerospace manufacturer (customer). For a small company, Jay-Star keeps a very hectic schedule. some(prenominal) miscalculation on shipping dates could be disastrous for the graze emanate 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 finding and requirements of the database desc ribe, step-by-step, the process for creation of the complete database and explains the reason or rationale for to each one step and, for each step, the options available and choices made for execution and explain how full of life thinking and ethical reasoning were applied in the creation of the database design.The aspiration 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 data 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 withdraw 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 achiever in using SQL in my future endeavors. Works CitedData Analytics Software. http//www.1keydata.com/sql/sql-primary-key.htmlPratt, Phillip J. Last, bloody shame Z. A Guide to SQL, Eighth Edition. P.26Journal of the Association for Information Systems, Aug 1, 2010, Vol. 11, zero(prenominal) 8 (Aug 2010), p. 433-454