Isys 350 Final Project Requirement

Isys 350 Final Project Requirement - Section I in MySQL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Section I: in MySQL, please create the following two tables under database “isys350”. The root password should be “admin”. In MySQL, Create a table named coffees , With the following attributes: id: MEDIUMINT, auto_increment, primary key name: VARCHAR(32) sup_id: INTEGER price: DOUBLE The id column is auto_increment and primary key of the coffees table. The column storing the coffee name is name. The third column, named sup_id, will hold a number that identifies the coffee supplier; The fourth column, called price, stores the price / pound for each coffee product. Insert the following data into the table: id Name sup_id price 1 Colombian 101 7.99 2 French_Roast 49 8.99 3 Espresso 150 9.99 4 Colombian_Decaf 101 8.99 5 French_Roast_Decaf 49 9.99 In MySQL, create the second table called suppliers, With the following attributes: sup_id: INTEGER, primary key sup_name: varchar(32) street: varchar(50) city: varchar(30) state: char(2) zip: char(5) Insert the following data into the table:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/28/2011 for the course ISYS 350 taught by Professor Li during the Fall '10 term at S.F. State.

Page1 / 3

Isys 350 Final Project Requirement - Section I in MySQL...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online