GMU Model with Functional Dependencies and Database Program

In a text/word file, write out the “Model” of your tables in the following format:TABLE_NAME(Key, otherElements, etc.) (if there is a foreign key, italicize it)

You might want to add extra fields to make your database make more sense.

Create a MySQL Model using MySQL Workbench of your tables & be sure to include the relationships and enter the data below.

Please Call your Database LastNameFirstNameAssignment2

Each table created should have a Primary Key, and data types for each element.

Antique Store
BuyerLastName Buyer FirstName BuyerPhone
Shire
Robert
205-555-5523
Shire
Robert
205-555-5523
Shire
Robert
205-555-5523
Bancroft Chris
201-555-5512
Bancroft
Chris
201-555-5512
Shire
Robert
265-555-5523
Smith
Robert
204-123-1234
Smith
Robert
204-123-1235
Smith
Robert
204-123-1236
Goodyear Katherine 123-555-1234
Shire
Robert
205-555-5523
Goodyear Katherine 123-555-1234
Goodyear Katherine
123-555-1234
Goodyear Katherine 123-555-1234
InvoiceDate Invoiceltem Price
Item Vendor VendorPhone
7/14/2013 Antique Desk
$3,000.00 Chairs, Chairs, Chairs 555-123-1212
7/14/2013 Antique Desk Chair $1,200.00 Chairs, Chairs, Chairs 555-123-1212
7/14/2013 Antique Lamp
$800.00 I Love Lamps 555-122-1221
7/14/2013 Candles
$45.00 I Heart Candles 555-555-2222
7/14/2013 Book Shelf
$250.00 PutUrBooksHere.com 888-333-1212
7/16/2013 Dining Room Table $2,500.00 Tables And More 800-111-5555
8/12/2013 Book Shelf
$200.00 PutUrBooksHere.com 888-333-1212
8/12/2013 Dining Room Chairs $1,000.00 Chairs, Chairs, Chairs 555-123-1212
8/24/2013 Dining Room Chairs $1,000.00 Chairs, Chairs, Chairs 555-123-1212
8/25/2013 Antique Couch $4,500.00 Couches A Plenty 555-421-5555
9/1/2013 Coffee Table
$500.00 PutUrBooksHere.com 888-333-1212
9/2/2013 Antique Chest
$1,250.00 Chest-R-US 800-555-1712
9/2/2013 Generic Chair
$75.00 Chairs, Chairs, Chairs 555-123-1212
9/2/2013 Antique Chair
$125.00 Chairs, Chairs, Chairs 555-123-1712