Chapter 11 Application

Question 1

Issue a command to create a database CS340.

Answer 1

Create database CS340;

Question 2

Provide code to create a table named Implement within the current database.

(get specifications for column from notes)

Answer 2

create table implement( article varchar(21) NOT NULL UNIQUE, msrp decimal(6,2) DEFAULT 0.00, CATEGORY char(7) NOT NULL, quantity int(1) default 1);

Question 3

Add a column named id, data type int, unsigned, not null with the auto_increment type attribute and designate the primary key.

Answer 3

Alter table implement add id int unsigned not null auto_increment primary key;

Question 4

Alter the Implement column named msrp to change the name to price.

Answer 4

alter table implement change msrp Price decimal(6,2) Default 0.00;

Question 5

Modify price to set width to 7 and the precision to 2 decimal places.

Answer 5

alter table implement modify price decimal (7,2) Default 0.00;

Question 6

Add a column to implement with name vendorId, data type int, and width 3. The vendor column is to be a foreign key constraint that references a table named Vendor with corresponding column also named vendorId.

Answer 6

Alter table implement add vendorId int(3);

Alter table implement add constraint implement_fk_Vendor foreign key (vendorId) references Vendor (vendorId);

Question 7

Code a statement to rename the implement table to TractorImplement.

Answer 7

rename table implement to TractorImplement;

Question 8

Create an index based on the category column of TractorImplement/

Answer 8

create index TractorImplement_category on TractorImplement (category);