[SOLVED] Advanced Database Creation
Create a database similar to what we did in class. This database will have one table. Call the table inventory. The inventory table should contain the following columns: pallet_id = unique value for the pallet, product_id = unique value for the product,Production_Date = date made,Shelf_life= how many days the product is good for,QTY= Quantity of an item on the pallet.Determine what should be the key for the inventory table. Note: Multiple products can be on a pallet as well the same product produced on multiple dates. Add the primary key.Load some records.Create a view that lists products that will expire within the next few days (return all columns).Create a second view that lists all the pallets and how much product is on them by sku.Document How you would change this table and move it to third normal form.Create a backup of your database/upload the database backup and document how you would change the table to 3rd normal form.Note: On the two views for this assignment.View one: Products that will be expiring soon. This will require a calculation using two of he fields in the table. View Two: Product Qty by Pallet. Question to ask yourself: If we produced more of a product today and added it to one of the pallets that already contained that product, would your totals be accurate? Also assume we can have multiple products on a single pallet, so we need to include product_id in the result of this view.