Homework Eight

Name
Jane Stone
Tom McMasters
Otto Vanderwall

Buyer

A buyer has a Name
Name
Gayle Hardy
Lyle Banks
Pearl Greene

Seller

A seller has a Name
ID Name Description Seller
1001 Abraham Lincoln Hammer A bench mallet fashioned from a broken rail-
splitting maul in 1829 and owned by Abraham Lincoln		 Pearl Greene
1002 Albert Einstein's Telescope A brass telescope owned by Albert Einstein
in Germany, circa 1927		 Gayle Hardy
1003 Bob Dylan Love Poems Five versions of an original unpublished,
handwritten, love poem by Bob Dylan		 Lyle Banks

Item

An item has an ID, Name, Description and a Seller
Item Buyer Price Timestamp
1001 Otto Vanderwall $250,000 12/04/2017 09:04:22
1003 Jane Stone $95,000 12/04/2017 08:44:03

Bid

A bid is an offer from a buyer, to buy an item from a seller. A bid refers to an item and a buyer and has a price and a timestamp

If for some reason you'd like this data in a more cut-and-paste friendly format, here you go:

-- Buyers
('Jane Stone'),
('Tom McMasters'),
('Otto Vanderwall');

-- Sellers
('Gayle Hardy'),
('Lyle Banks'),
('Pearl Greene');

-- Items
('Abraham Lincoln Hammer'    ,'A bench mallet fashioned from a broken rail-splitting maul in 1829 and owned by Abraham Lincoln'),
('Albert Einsteins Telescope','A brass telescope owned by Albert Einstein in Germany, circa 1927'),
('Bob Dylan Love Poems'      ,'Five versions of an original unpublished, handwritten, love poem by Bob Dylan');

--Bids
(1001,250000,'12/04/2017 09:04:22'),
(1003,95000 ,'12/04/2017 08:44:03');