Nt1310 Unit 3 Lab 4

502 Words3 Pages
Lab 4 Task I • Create a database called lab4 • Use lab4 DB • Insert data into each table as specified in the insert statement for each table -- Create Lab4 database Create database Lab4 -- Use Lab4 DB use lab4 -- Create customer table Create table CUSTOMER ( id char(5) primary key, fname char(15), lname char(15), bday datetime, phone char(12) ); -- Create product table create table PRODUCT ( id char(5) primary key, list_price money, description char(20) ); -- Insert data into customer table insert into customer values ('11111', 'Glen', 'Stamler', '9/13/1974', '555-3232'); insert into customer values ('22222', 'Maddy', 'Gray', '8/05/1984', '555-8475'); insert into customer values ('33333',

More about Nt1310 Unit 3 Lab 4

Open Document