Need Help creating a SQL in Microsoft Access

profilephanon
lab5_kcds.docx

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

Email

Phone Number

Null/NorY

N

Y

Y

Y

Data

Joe

121 Orr RD.

[email protected]

(321) 444-1111

Supplier_ID

Column Name

Supplier Name

Address

Email

Phone Number

Null/NorY

N

Y

Y

Y

Data

Marks Paper

696 Ross St.

[email protected]

(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

· In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables.

· 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