1. Create a new database and name it Baseball Gear.

2. Include in the Baseball Gear database a table (entity) for Customer, Order, Order Line Item, and Item.

3. For each table (entity) created include the associated fields. For example, CUSTOMER, Customer Number, First Name, Last Name, Phone. Note: Data type and field size must be specified for each field. You can review your class notes to identify some of the field sizes used in class and apply them were applicable. The data populated in the tables is a good indicator as to the field sizes and data types.

4. Phone field must have input mask/pattern specified. Date must conform to the format of the data specified in the figures. Currency is showing in the figures so it must be specified for fields in the database that are currency.

5. Indicate a primary key for each field (attribute) as specified in the figures.

6. Indicate each foreign key for each field (attribute) as specified in the figures.

7. Create relationships (with referential integrity) between the tables that reflect the relationships identified in the figures.

8. Populate the tables with the data specified.

9. Generate a form for Customer data entry and call it the Customer form.

10. Generate a query to select only those customers who have ordered Baseball bats. Call it Query Baseball bats.

11. Generate a report containing the information from the Baseball bat query and call it Order Tracking Report.

 

Transcribed Image Text:

Using the information in the figures below complete the tasks in the Instruction Section. CUSTOMER Customer Number First Name Last Name M ORDER ITEM Order Number Customer Se Order Date Last Name MacDonald MacNeil Sutherland Order Date 1122 11/1/2020 1133 11/10/2020 1122 12/11/2020 5000 10/3/2020 1133 11/2/2020 Quantity 9966 9870 9978 9870 9978 0 Records (data) Primary keys CUSTOMER Customer Number ORDER Order Number 2002 2014 2004 2003 3000 ORDER LINE ITEM Order Number 2002 2014 2004 2003 3000 ITEM Item Number First name 1122 Jack 1133 Jill 5000 John Customer Number Item Number Title 9870 Baseball Bat 9966 Baseball Ball 9968 Baseball Glove Baseball Catcher 9978 glove Distributor Number 004 006 004 008 Phone 569-563-1245 563-289-5631 258-895-6633 Shipped? IY 25 Y 30 N 3N 20 Y Price S S 35.00 15.70 100.00 150.00 Foreig Using the information in the figures below complete the tasks in the Instruction Section. CUSTOMER Customer Number First Name Last Name M ORDER ITEM Order Number Customer Se Order Date Last Name MacDonald MacNeil Sutherland Order Date 1122 11/1/2020 1133 11/10/2020 1122 12/11/2020 5000 10/3/2020 1133 11/2/2020 Quantity 9966 9870 9978 9870 9978 0 Records (data) Primary keys CUSTOMER Customer Number ORDER Order Number 2002 2014 2004 2003 3000 ORDER LINE ITEM Order Number 2002 2014 2004 2003 3000 ITEM Item Number First name 1122 Jack 1133 Jill 5000 John Customer Number Item Number Title 9870 Baseball Bat 9966 Baseball Ball 9968 Baseball Glove Baseball Catcher 9978 glove Distributor Number 004 006 004 008 Phone 569-563-1245 563-289-5631 258-895-6633 Shipped? IY 25 Y 30 N 3N 20 Y Price S S 35.00 15.70 100.00 150.00 Foreig

Answer rating: 100% (QA)

Answers are as below CREATE TABLE ITEMDETAILS ITEMID INT NOT NULL PRIMARY KEY ITEMNAME VARCHAR255 ... View the full answer