-- ********** create database ********** --
-- ********** Begin ********** --
CREATE DATABASE website;
-- ********** End ********** --
go

use website
go

-- ********** create table ********** --
-- ********** Begin ********** --
CREATE TABLE shopping (
    ID int IDENTITY(1,1) NOT NULL,
    Name varchar(20) NOT NULL,
    address varchar(30) NOT NULL
);
-- ********** End ********** --
go

SET NOCOUNT ON

insert into shopping (Name, address) values ('eBay', 'www.ebay.com')
go

SET NOCOUNT ON

-- ********** insert ********** --
-- ********** Begin ********** --
insert into shopping (Name, address) values ('amazon', 'www.amazon.com');
-- ********** End ********** --
go

SET NOCOUNT ON

-- ********** delete ********** --
-- ********** Begin ********** --
DELETE FROM shopping WHERE Name = 'eBay';
-- ********** End ********** --
go