Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment Task I would like you to practice what you have learned in this module. You will write a SQL Script that creates a database
Assignment Task I would like you to practice what you have learned in this module. You will write a SQL Script that creates a database called Assignment02DB_YourNameHere. The database you design and create will be to hold the following data (though for now we will leave it empty) OrderDate Category SubCategory 10/30/2007 Accessories Tires and Tubes Road Tire Tube 10/30/2007 Accessories Tires and Tubes ML Road Tire 10/30/2007 Accessories Helmets 10/30/2007 Clothing Jerseys Product OrderPrice OrderQty Customer Aaron Adams Aaron Adams Aaron Adams Aaron Adams Aaron Alexander 6/15/2008 Clothing Shorts Aaron Allen Aaron Baker Aaron Baker Aaron Bryant Aaron Bryant Aaron Bryant Aaron Bryant Aaron Bryant Aaron Butler Aaron Butler Aaron Campbel3/13/2008 Bikes Aaron Campbell3/13/2008 Accessories Helmets Aaron Carter $3.99 $24.99 $34.99 $53.99 $69.99 $3,399.99 $1,700.99 $49.99 $49.99 $8.99 $35.00 $4.99 $34.99 $4.99 $9.99 $1,120.49 $34.99 4.99 Sport-100 Helmet, Red Short-Sleeve Classic Jersey, M Women's Mountain Shorts, S 6/4/2006 Bikes 3/12/2008 Bikes 3/12/2008 Clothing Mountain BikesMountain-100 Silver, 44 Road Bikes Jerseys Road-350-W Yellow, 42 Long-Sleeve Logo Jersey, XL Long-Sleeve Logo Jersey, XL AWC Logo Cap 1 10/26/2007 Clothing Jerseys 10/26/2007 Clothing Caps 1/27/2008 Accessories Tires and Tubes HL Mountain Tire 1/27/2008 Accessories Tires and Tubes Mountain Tire Tube 1/27/2008 Accessories Helmets 6/28/2008 Accessories Bottles and Cages Water Bottle 30 oz. 6/28/2008 Accessories Bottles and Cages Mountain Bottle Cage 1 Sport-100 Helmet, Red 1 Road Bikes Road-550-W Yellow, 40 Sport-100 Helmet, Black Touring Tire Tube 6/24/2008 Accessories Tires and Tubes NOTE: This database must include tables with proper constraints and views for an abstraction layer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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