Question: Please help me answer the following question for practice purposes: Tables: IS361 Fall 2015 Student 9. pts) to Consider the Part table at the end
Please help me answer the following question for practice purposes:

Tables:

IS361 Fall 2015 Student 9. pts) to Consider the Part table at the end of the exam. write a list of sOL statements create this table in MySQL and add the first two records shown on the last page to this table. Be sure to use appropriate data type for each column. The database actually contains one more tables called warehouse which is not shown on the last page. The warehouse column of the Part table comes from the WarehouseID column of this warehouse table. Assume the warehouse table has been created and proper records exist. Warehouse table: Warehouse ID Description Address City Zip Sample syntax: CREATE TABLE Product T Product ID INTEGER (11) NOT NULL INTEGER (11) Product VARCHAR (50) Product Description CHAR (10) Product Finish (6, 2) Product PRIMARY KEY ProductID) REFERENCES CONSTRAINT Product PK FOREIGN KEY Fki, T Product Product (ProductID Product Description INSERT INTO Product Product LineID) Finish, 175, 1) 'End Table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
