Need Help creating a SQL in Microsoft Access
|
Catalog_ID |
|
|
|
|
Column Name |
Title |
Rating |
Charges |
|
Null?NorY |
Y |
Y |
N |
|
Data |
The Conformist |
5 |
visa/master |
|
|
|
|
|
|
|
|
|
|
|
Item_ID |
|
|
|
|
Column Name |
Item number |
Price |
Genre |
|
Null/NorY |
Y |
N |
Y |
|
Data |
B2211334 |
$6.00 |
drama |
|
|
|
|
|
|
|
|
|
|
|
Order_ID |
|
|
|
|
Column Name |
Order Number |
Order Date |
Order Done |
|
Null/NorY |
Y |
N |
N |
|
Data |
ON20 |
10/3/2015 |
10/3/2015 |
|
|
|
|
|
|
|
|
|
|
|
Member_ID |
|
|
|
|
|
Column Name |
member name |
Address |
|
Phone Number |
|
Null/NorY |
N |
Y |
Y |
Y |
|
Data |
Joe |
121 Orr RD. |
(321) 444-1111 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Supplier_ID |
|
|
|
|
|
Column Name |
Supplier Name |
Address |
|
Phone Number |
|
Null/NorY |
N |
Y |
Y |
Y |
|
Data |
Marks Paper |
696 Ross St. |
(144) 999-2776 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CD_ID |
|
|
|
|
|
Column Name |
CD Quality |
MP3 |
Blue Ray |
HD |
|
Null/NorY |
Y |
N |
Y |
Y |
|
Data |
Digital Audio |
None |
50 gigabytes |
16-bit digital audio |
· Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.
· Refine your database and SQL statements by incorporating your instructor's feedback.
· Verify that the database completely follows the business logic and design you created in the previous weeks.
· Create queries using your new database to demonstrate that the data is useful and meaningful.
· Submit the final database and database scripts to the instructor for testing and installation
SU_ITS3102_W3_A2_Ford_KR.doc.accdb
| ISBN | Title | Author | PubDate | Cost | Retail | Category | PubID |
|---|---|---|---|---|---|---|---|
| 0131873253 | Database Systems | Hector Garcia | 6/15/08 | ¤ 100.00 | ¤ 128.68 | Information Systems | 1 |
| 0307352153 | Quiet: The Power of Introverts in a World That Can't Stop Talking | Susan Cain | 1/29/13 | ¤ 7.25 | ¤ 9.60 | Non-Fiction | 4 |
| 0307954560 | Meatless: More Than 200 of the Very Best Vegetarian Recipes | Martha Stewart | 1/8/13 | ¤ 10.15 | ¤ 15.00 | Cooking | 5 |
| 0743273567 | The Great Gatsby | F. Scott Fitzgerald | 9/30/04 | ¤ 6.23 | ¤ 8.25 | Fiction | 3 |
| 0811877825 | Goodnight, Goodnight Construction Site | Sherry Rinker | 5/4/11 | ¤ 6.36 | ¤ 9.24 | Childrens | 1 |
| 1590597699 | Beginning Database Designq | Clare Churcher | 1/24/07 | ¤ 19.22 | ¤ 23.53 | Information Systems | 2 |
| 1591845521 | Bend, Not Break: A Life in Two Worlds | Ping Fu | 12/31/12 | ¤ 14.00 | ¤ 16.02 | Biography | 4 |
| CustomerID | LastName | FirstName | Address | City | State | Zip |
|---|---|---|---|---|---|---|
| 1 | Smith | Sheila | 123 Smith Street | Goshen | IN | 46528 |
| 2 | Jones | John | 456 John Street | Hilo | HI | 96714 |
| 3 | Fu | Ping | 457 Ping Park | San Francisco | CA | 94101 |
| 4 | Michaels | Michael | 123 Michael Lane | White Pigeon | MI | 46507 |
| 5 | Farmer | Franny | 457 Franny Circle | New York | NY | 10453 |
| OrderID | CustomerID | OrderDate | ShippingDate | ISBN |
|---|---|---|---|---|
| 1 | 1 | 12/3/12 | 12/10/12 | 0131873253 |
| 2 | 1 | 12/11/12 | 12/13/12 | 1591845521 |
| 3 | 2 | 12/12/12 | 1/1/13 | 0307352153 |
| 4 | 3 | 1/15/07 | 3/15/07 | 0743273567 |
| 5 | 4 | 5/19/10 | 5/21/10 | 0811877825 |
| 6 | 5 | 1/8/13 | 1/10/13 | 0131873253 |
| PubID | PubName | Contact | Phone |
|---|---|---|---|
| 1 | Becky's Books | Becky Aldridge | (574) 123-4569 |
| 2 | Tony's Tomes | Tony Jones | (457) 555-1212 |
| 3 | Peace Publications | Groovy Mohanahan | (873) 111-9999 |
| 4 | Pearson Publishing | John Pearson | (123) 555-7878 |
| 5 | Stevens Books | Steven Stevens | (888) 111-1555 |