Please help me answer the following question for practice purposes: Tables: IS36

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 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

Explanation / Answer

ANSWER:

CREATING TABLE PART:

CREATE TABLE PART
   ( PartNum CHAR(5) NOT NULL,
   Description VARCHAR(50),
   OnHand INTEGER(4),
   Class CHAR(5),
CONSTRAINT Warehouse FOREIGN KEY (WarehouseID) REFRENCES Warehouse (WarehouseID),
   Price DECIMAL(5,2));

INSERTING DATA:

ROW 1:

INSERT INTO PART (PartNum, Description, OnHand, Class, WarehouseID, Price) VALUES ('AT94','Iron',50,'HW',3,24.95);

ROW 2:

INSERT INTO PART (PartNum, Description, OnHand, Class, WarehouseID, Price) VALUES ('BV06','Home Gym',45,'SG',2,794.95);

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.