Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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 an Database Diagram and be sure to include the relationships. Each table created should have a Primary Key, and data types for each element.
- Try creating the SQL DDL Script to create this database. You do not have to create Insert lines to insert all of the items into the tables.
- Provide the Model/Schema you create and the image of the Diagram.
Antique Store BuyerLastName BuyerFirstName Robert Robert Robert Chris Chris Shire Shire Shire Bancroft Bancroft Shire Smith Smith Smith Goodyear Shire Goodyear Goodyear Goodyear Robert Robert Robert Robert Katherine Robert Katherine Katherine Katherine BuyerPhone 205-555-5523 205-555-5523 205-555-5523 201-555-5512 201-555-5512 205-555-5523 204-123-1234 204-123-1235 204-123-1236 123-555-1234 205-555-5523 123-555-1234 123-555-1234 123-555-1234 Invoice Date Invoiceltem 7/14/2013 Antique Desk 7/14/2013 Antique Desk Chair 7/14/2013 Antique Lamp 7/14/2013 Candles 7/14/2013 Book Shelf 7/16/2013 Dining Room Table 8/12/2013 Book Shelf 8/12/2013 Dining Room Chairs 8/24/2013 Dining Room Chairs 8/25/2013 Antique Couch 9/1/2013 Coffee Table 9/2/2013 Antique Chest 9/2/2013 Generic Chair 9/2/2013 Antique Chair Price ItemVendor VendorPhone $3,000.00 Chairs, Chairs, Chairs 555-123-1212 $1,200.00 Chairs, Chairs, Chairs 555-123-1212 $800.00 I Love Lamps 555-122-1221 $45.001 Heart Candles 555-555-2222 $250.00 PutUrBooksHere.com 888-333-1212 $2,500.00 Tables And More 800-111-5555 $200.00 PutUrBooksHere.com 888-333-1212 $1,000.00 Chairs, Chairs, Chairs 555-123-1212 $1,000.00 Chairs, Chairs, Chairs 555-123-1212 $4,500.00 Couches A Plenty 555-421-5555 $500.00 PutUrBooksHere.com 888-333-1212 $1,250.00 Chest-R-Us 800-555-1212 $75.00 Chairs, Chairs, Chairs 555-123-1212 $125.00 Chairs, Chairs, Chairs 555-123-1212
Step by Step Solution
★★★★★
3.45 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
Based on the provided image of the Antique Store data we can define the following tables and their structures for a database Note that in the database design Key represents the Primary Key of a table ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started