A. Employee Table
1. Table & data types created correctly
2. Records / attributes populated correctly
(5)
(5)
10
B. Import Data
1. Customer data imported correctly
2. Product Supplier data imported correctly
(5)
(5)
10
C. Forms
1. Supplier form is functional
2. Product Category form is functional
(5)
(5)
10
D. Relationships
1. Relationships are properly configured
(20)
20
E. Queries
1. MostProductsSold query is functional
2. CustomerOrders query is functional
3. ProductPrices query is functional
(10)
(10)
(10)
30
F. Report
1. Report meets management expectations
(10)
10
G. Assessment
1. Assessment meets management expectations
2. Assessment embedded in personal record
(5)
(5)
10
Total
100
CIS3100 – Database Design and Implementation
Products on Sale Database for Kahdea Inc.
1. Project Overview
The activities in this project are designed to provide a better understanding of how data is organized into a relational database. A relational database enables management information systems to support inventory, transactions and business intelligence capabilities.
Using Microsoft Access 2016, you will create and manage tables, perform data imports, link tables via relationships, create queries and finally create reports for executive summary.
A general overview of relational database fundamentals and Microsoft Access training via Lynda.com is provided in section 11 to enable your success in this project. Please allow enough time to expose yourself to this material before starting the project.
2. Company Background
Kahdea Inc. is a small startup company that sells sports merchandise online. The mission of the company is to successfully sell and deliver sports products for all. The company sells products for a wide variety of sports including football, basketball, baseball, soccer, hockey, and volleyball.
Kahdea is composed of twenty-eight (28) employees who work in different departments (production, operations, automation, accounting, human resources, finance, marketing, etc.). During their probation period, all employees are trained before being assigned into their positions.
Kahdea is planning to have their annual sale next month. This sale is an important event for the company because it can typically generate 31% of Kahdea’s annual revenue. The company has been planning this sale for some time now, and wants to make sure all transactions are supported without issue.
Your specific role in the project
You are a new hire at Kahdea. During your training, you are expected to learn about building and maintaining relational databases using Microsoft Access. The database you will support is being used to keep track of Kahdea’s sales during this period. Although the database has been constructed, the team needs your assistance inserting data, using forms, creating queries and reports.
Your first training task requires you to watch the Microsoft Access training videos on Lynda.com. A series of hyperlinks for reference information are provided for you at the end of this project document.
After you become familiar with Microsoft Access, open the Kahdea.accdb file.
3. Create a Table
Before you begin, the team wants to ensure you understand table structure. They would like you to create a table for Employees and populate a few records. The table should include the field names: EmployeeID(PK), Last Name, First Name, Phone and Attachments.
·
Step 1: Click the “Create” tab on the top ribbon and select “Table Design”.
· Step 2: Enter the Field Names and Data Type. Include a Primary Key (EmployeeID) for
the table. Select attachment as the data type for the Attachments field.
· Step 3: Save the table as “Employee”.
· Step 4: Enter the following records into the table. Create a personal record by substituting the red text with your information (enter a fictitious phone number). This record will be used later in section 9 of this assignment.
EmployeeID
Last Name
First Name
Phone
Attachments
1
Kathleen
Salazar
(909) 869-5438
2
Kim
Stella
(909) 869-2360
3
Leen
Hlahza
(909) 869-5079
4
Mike
Jacob
(909) 648-1010
5
see section 9
· Step 5: After you enter the records, close the table. The entries should be saved.
4. Importing Data
In preparation for the sale, the team has gathered information regarding products’ supplier, and customers that need to be entered into the system. Since there is a lot of information to upload, using the forms will not be effective. Microsoft Access allows for a bulk insert of data.
Populate Customer table with data
For this task you will need the Customer.xlsx file.
· Step 1: Right click on the Customer table (Under All Access Objects panel) and select
“Import”, choose “Excel”.
· Step 2: In the pop-up window click “Browse” and navigate to the Customer.xlsx file.
Select the file.
· Step 3: Click “Append copy of the records to the table” and in the drop-down menu
choose “Customer”, click “OK”.
·
Step 4: Click “Next” until the final window. Click “Finish”.
4. Importing Data (continued)
Populate ProductSupplier table with Data
For this task you will need the ProductSupplier.txt file.
· Step 1: Right click on the ProductSupplier table (under All Access Objects panel) and
select “Import”. Choose “Text File”.
· Step 2: In the pop-up window click “Browse” and navigate to the ProductSupplier.txt
file, choose the file.
· Step 3: Click “Append copy of the records to the table” and in the drop-down menu
· choose “ProductSupplier”, click “OK”.
· Step 4: Click “Next” until the final window. Click “Finish”.
Note: For best results, right-mouse click on the ProductSupplier.txt file then save the file to your desktop to enable this data import.
5. Create Forms
As a new hire at Kahdea Inc. you are tasked to create forms. Database administrators can enter the data directly into the tables. However, your boss feels it would be more efficient to create a form that coaches users to enter information in the best order. Create a user entry form to capture suppliers and product category data.
Create the Supplier Form
Apply the following steps using the Form Wizard to create a data entry form with tabular layout. Include all fields except Webpage and Notes.
·
Step 1: Click the “Create” tab on the top ribbon and select “Form Wizard”
· Step 2: In the popup window select the Supplier Table from the drop-down menu
(Tables/Queries). Select the fields you wish to use and move them to the
Selected Fields box by clicking the “>” button. Click “Next”
.
· Step 3: Click and select “Tabular”, and click “Next”.
· Step 4: Name the form Populate Supplier, and click “Finish”.
· Step 5: Click the New Record icon.
· Step 6: Populate the form with new entries using the table given below, once all entries
are entered, save the form. Once finished, close the form.
Field
Input
CompanyName
Iamz Co
Address1
153 9th Street
City
Brea
State
CA
Zip
92821
Country
USA
Phone
7148884565
FaxNumber
6523937595
Create the ProductCategory Form
Apply the following steps using the Form Wizard to create a data entry form with a columnar layout, to add data into the ProductCategory table. Include all fields except ProductCategoryID and Active.
· Step 1: Click the “Create” tab on the top ribbon and select “Form Wizard”.
· Step 2: In the popup window select the ProductCategory table from the drop-down
menu (Tables/Queries). Select the fields you wish to use and move them to the
Selected Fields box by clicking the “>” button. Click “Next”
· Step 3: Click and select “Columnar”, and click “Next”.
· Step 4: Name the form Populate ProductCategory, and click “Finish”.
·
Step 5: Click the New Record icon.
·
Step 6: Populate the form with new entries using the table given below, once all entries
are entered save the form. Once finished close the form.
Field
Input
ProductCategory
Bodybuilding
6. Creating Relationships
Although the tables have been created, some of them are missing relationships. Without table relationships, inserts, updates, or deletions in one table, data will not propagate to the other tables. You will need to create the relationships for all tables in the database.
Note: All tables have at least one relationship while some have two.
· Step 1: Click the “Database Tools” tab on the top ribbon and select “Relationships”.
· Step 2: If a table is not displaying on the screen, click the “Database Tools” tab on the
top ribbon and select “Show Table”, on the popup window and click “Add”. After
selecting any missing Tables, click “Close”.
· Step 3: Drag the Primary Key from the first table to the Foreign Key on the second table.
A new window will appear displaying the joint keys. Check “Enforce Referential
Integrity”. Click “Create” to create the relationship.
· Step 4: Continue creating relationships for tables that do not have relationships.
· Step 5: Save all changes and the close the workspace.
7. Create Queries
Kahdea Inc. wants to gather information from the database. Create the following queries to enable decision making for inventory and logistics.
MostProductsSold Query
Create a query that displays the Product Code, Product Description, and number of times the Product was sold. Limit to the results to products that were sold at least 10 times. Save the query as MostProductsSold.
CustomerOrders Query
Create a query that displays CustomerID, ShipName, Order ID, Order Date, Product Code, Product Description, Quantity Sold, Price, and Total. Limit the results to Orders between 07/06/2017 and 09/07/2017. Save the query as CustomerOrders.
Note: In order to accomplish the Customer Orders query, you will need to create the “Total” field in your query results by using the “’Builder” tab. The following reference provides the method used to create a calculation query in Microsoft Access.
7. Create Queries (continued)
CustomerOrders Query
ProductPrices Query
Create a query that displays the Company Name, Products Code, Product Description, Purchase Price, and Sale Price. Limit the query to products where purchase price is greater than sale price. Save the query as ProductPrices.
· Step 1: Click the “Create” tab on the top ribbon and select “Query Design”.
· Step 2: In the popup window, select the table you need for the query and click “Add”.
Once all tables are selected, click the “Close” button.
· Step 3: Select the fields required for the query.
· Step 4: Enter criteria for the query.
· Step 5: Click the “Run” button. Verify the query displays the correct data.
8. Reports
Your manager is impressed with your database skills and would like you to prepare the following information for reporting to the executive team. Your manager is a has high expectations on the reporting format, so you will need to display this information in a presentable format.
Create a report to display CustomerOrders. Include CustomerID, ShipName, Order ID, Order Date, Product Code, Product Description, Quantity Sold, Price, and Total. Include the title “Customer Report” in the page header. Include the run date, page number and total pages in the page footer. Save the report.
· Step 1: Click the “Create” tab on the top ribbon and select “Report Wizard” on the far
right.
· Step 2: In the popup window, select the query from the drop-down menu
(Tables/Queries). Select the fields you wish to use and move them to the
Selected Fields box by clicking the “>” button. Click “Next”.
· Step 3: Select the fields to group by. This is optional and is not always required. Click
“Next”.
· Step 4: Select the “sort order” of the report. Click “Next”.
· Step 5: Select the Format of the report and landscape orientation. Click “Next”.
· Step 6: Enter the name for the report. Click “Finish” and the report will display as a print
preview.
Note: In order to accomplish the Customer Report, you will need to use custom configuration via Design View. The following reference provides the method used to create this report.
Runtime: 28:14
9. Project Assessment
Your manager is impressed with your performance supporting this information system and wants to measure your competency in the scope of your assignment. She has asked for your assessment of the following.
· What are the major advantages of DBMS software applications such as Microsoft Access?
· What are the components of a relational database table (entity)?
· What are the benefits of using queries (views) in management information systems?
· Describe one lesson learned in your efforts to complete this project assignment
· Step 1: Provide a comprehensive summary statement in paragraph form using Microsoft Word and name the file CIS 3100 Response (Enter your first name and last name).
· Step 2: Upload your Microsoft Word file to the Employee table, attachment field of your personal record created in section 3 of this assignment.
10. Project Deliverables
Upload your Microsoft Access file to Blackboard, including your project assessment uploaded to your personal record (created in section 3 of this assignment) according to the specific instructions provided by your instructor.
11. Microsoft Access Training Videos
Use the following references to brief yourself on Microsoft Access and supporting activities to succeed in this project and any future work with relational databases. It is not necessary to navigate completely through each course for this assignment.
The additional three learning series are provided to further enable your success in this project. You should be able to find a section within this reference to support any questions you may have.
· Relational Structures
· Breaking Data Down Into Its Components
· Understanding Entities and Table
· Develop Relationships
· Develop Subtypes and Supertypes
· Following a Naming Convention
· Creating Tables in Access
· Establish Relationships in Access
· Write Queries in Access
123 Java Street Willow Island NV 64328 USA ¤ 0.00 ¤ 0.00 Credit Card 1
181 133
9/28/17
9/30/17 1
Adrian Cox
4124 Baker Boulevard Orviston WA 64329 USA
¤ 29.00
¤ 0.00 Credit Card 2
182 134 4/22/17
Amelia Howard
1244 Hawthorne Way Ranchette Estates MA 64330 USA ¤ 0.00 ¤ 0.00 Credit Card 2
183 135 8/15/17
Alex Ward
5325 Judge Lane Wichita Falls CA 64331 USA ¤ 0.00 ¤ 6.76 Credit Card 1
184 136 7/29/17 8/2/17 3
Melanie Torres
213 Ruby Street Zapata NY 64332 USA ¤ 0.00 ¤ 0.00 Credit Card 1
185 137 1/23/18
Willie Leena
123 School Route Lake Wynonah MN 64333 USA ¤ 0.00 ¤ 0.00 Credit Card 1
186 138 1/1/18
Jarrod Peterson
2131 Jewel Lane Soper WI 64334 USA ¤ 0.00 ¤ 0.00 Credit Card 1
187 139 7/17/17 7/21/17 3
Alva Ira
546 Wright Street
Orlinda ID 35365 USA ¤ 0.00 ¤ 0.00 Credit Card 1
188 140 11/9/17 11/12/17 2
Gemma Gray
8667 Knight Street Roselle OR 35366 USA ¤ 0.00 ¤ 0.58 Credit Card 2
189 141 7/14/17 7/15/17
7/20/17
1
Connor Ramirez
455 Trinity Passage St. Joseph UT 35367 USA ¤ 0.00 ¤ 0.00 Credit Card 1
190 142
6/18/17
6/19/17
6/24/17
1
Arletha Jerrie
435 Ashland Way Mantachie NE 35368 USA
¤ 19.49
¤ 0.00 Credit Card 1
191 143 9/18/17 9/19/17 3
Vanita Alona
789 Feathers Route Casar PA 35369 USA
¤ 20.50
¤ 0.00 Credit Card 1
192 144
6/10/17
6/12/17 6/16/17 3
Elin Kaycee
435 Snowflake Boulevard Powersville OR 35370 USA ¤ 0.00 ¤ 11.71 Credit Card 2
193 145
3/9/17
3/11/17 2
Caroll Cheryll
435 Hart Boulevard Venus WA 20106 USA ¤ 0.00 ¤ 0.00 Credit Card 1
194 146
2/28/17
3/4/17
3
Amber James
123 Prince Avenue Myersville OR 64342 USA ¤ 0.00
¤ 7.83
Credit Card 2
195 147 1/25/18 1/29/18 1
Salena Nita
878 Coach Route Aliquippa OR 64343 USA ¤ 0.00
¤ 17.73
Credit Card 2
196 148 5/9/17 5/12/17 2
Mathew Watson
8763 Steam Row Panora AZ 64344 USA ¤ 0.00
¤ 8.41
Credit Card 2
197 149 3/24/17 3/27/17 3/31/17 1
Otelia Charise
2434 Bay View Street Bonnieville VA 64345 USA ¤ 0.00 ¤ 0.00 Credit Card 1
198 150 1/18/18
Vanessa Brooks
678 Winter Lane Rosburg VA 64346 USA ¤ 0.00 ¤ 0.00 Credit Card 2
199 151 1/18/18 1/20/18 3
Margie Aracelis
4532 Meadow Row Hawley OK 48291 USA ¤ 0.00 ¤ 0.00 Credit Card 2
200 152
8/16/17
Elnora Lakisha
123 Tower Avenue Kiawah Island TN 48292 USA
¤ 65.70
¤ 0.00 Credit Card 1
201 153
10/6/17
10/8/17
1
Refugia Lanette
1323 Onyx Boulevard North Utica CO 48293 USA ¤ 16.30 ¤ 0.00 Credit Card 1
202 154
8/28/17
Marilee Maryanne
123 Parkside Street Salmon HI 48294 USA ¤ 0.00 ¤ 0.00 Credit Card 2
203 155 8/11/17
Simon Kelly
345 Globe Lane Old Mill Creek CA 48295 USA ¤ 0.00
¤ 4.28
Credit Card 1
204 156 10/22/17
Iris Kieth
123 Anchor Street Waipio WA 48296 USA
¤ 37.60
¤ 0.00 Credit Card 2
205 157 10/6/17
10/7/17
10/9/17 3
Taylor Sanders
456 Flax Street Amberg MA 48297 USA ¤ 0.00 ¤ 0.00 Credit Card 1
206 158 1/20/18 1/21/18 1
Doug Ciera
345 Meadow Street Flemingsburg NV 48298 USA
¤ 48.20
¤ 0.00 Credit Card 1
207 159
1
2/19/17
1
2/22/17
2
Tama Era
523 Kingwood Street Edgerton WA 48299 USA
¤ 51.30
¤ 0.00 Credit Card 1
208 160 4/12/17
Alysia Silvia
756 Dawn Passage
Regina MA
48300
USA ¤ 0.00 ¤ 0.00 Credit Card 2
209 161 2/21/17 2/23/17 3
Nichelle Lino
456 Luna Avenue
Adelino CA
48
301
USA ¤ 0.00
¤ 10.31
Credit Card 2
210 162
2/13/17
George Price
1
424
Earl Way
Welaka NY
20124
USA ¤ 0.00 ¤ 0.00 Credit Card 1
211 163 4/2/17
Tiara Yuri
4124 Brewer Route
Fedora MN
20125
USA ¤ 0.00 ¤ 0.00 Credit Card 1
212 164 4/22/17 4/27/17 5/1/17 3
Gabrielle Bennett
123 Shadow Boulevard
Ladson WI
20126
USA ¤ 0.00 ¤ 0.00 Credit Card 2
213 165 9/20/17 9/25/17 9/28/17 3
Adriana Jamey
213 Parkview Way
Ascutney ID 20127 USA ¤ 0.00 ¤ 0.00 Credit Card 2
214
166 12/26/17
12/28/17
3
Edward Wood
123 Justice Route
Basin City OR
20128
USA
¤ 47.10
¤ 38.86
Credit Card 2
215 167 3/10/17 3/15/17 1
Renee Barnes
3123 Lowland Lane Pekin UT
20129
USA ¤ 0.00 ¤ 0.00 Credit Card 1
216
168 8/30/17 9/2/17 2
Harley Ross
3214 Ironwood Passage
Cimarron Hills
NE 48308 USA ¤ 0.00 ¤ 0.00 Credit Card 1
217
169 5/9/17
Bethany Henderson
3123 Heirloom Passage Lake Norden NE 48309 USA
¤ 17.79
¤ 0.00 Credit Card 1
218 170 2/6/17 2/10/17 2
Hyacinth Jaunita
4355 Blossom Avenue
Zionsville OK 48310 USA
¤ 21.70
¤ 0.00 Credit Card 2
219 171 3/13/17
Joe Belkis
132 Starlight Street
Olimpo VA 48311 USA ¤ 0.00 ¤ 0.00 Credit Card 1
220 172 4/6/17
Angus Coleman
312 Monument Lane Salisbury AZ 48312 USA ¤ 0.00
¤ 29.20
Credit Card 1
221
173 2/15/17 2/19/17 2/22/17 1
Moriah Carlena
132 Java Way Hermon VA 48313 USA ¤ 0.00 ¤ 0.00 Credit Card 1
222 174 7/25/17
7/30/17
8/1/17 2
Zella Kathie
5345 Arctic Boulevard Hosmer AZ 48314 USA
¤ 19.90
¤ 16.41
Credit Card 2
223
175 1/8/18 1/9/18 1/12/18 3
Casey Jenkins
435 Beaver Lane North Rock Springs NJ 78277 USA ¤ 0.00 ¤ 6.68 Credit Card 2
224 176 1/29/17
1/31/17
2/1/17
2
Shane Perry
312 Middle Way East Liberty NY 78278 USA ¤ 0.00 ¤ 0.00 Credit Card 2
225 177 2/1/17
Shawnda Cheri
123 Cross Street Thousand Island Park VA 78279 USA ¤ 0.00 ¤ 0.00 Credit Card 2
226 178 11/9/17
Alana Powell
654 Redwood Lane
Burlison AZ 78280 USA ¤ 0.00
¤ 20.87
Credit Card 1
227
179 4/3/17 4/5/17 1
Max Long
2344 Silver Boulevard
Acacia Villas OR 78281 USA ¤ 0.00 ¤ 2.22 Credit Card 2
228 180 10/21/17
Jacinta Patterson
412 Ironwood Street Lovelady UT 78282 USA ¤ 0.00 ¤ 0.00 Credit Card 1
229
2
2/21/18
1 Nichelle Lino 456 Luna Avenue Adelino CA 48301 USA ¤ 0.00 ¤ 0.00 Credit Card 2
1 27 7/6/17 Dylan Bennett 21146 Park Portland OR 49506 USA ¤ 0.00
¤ 7.42
Credit Card 1
2 4 3/19/17
3/23/17
3/27/17 1 Christina Lee 123 4th Street New York NY
70831
USA ¤ 0.00 ¤ 0.00 Credit Card 1
OrderLineID
OrderID
ProductID
QuantitySold
Price
1 1 56 1
¤ 32.99
2 1 5 1
¤ 6.99
3 1 37 5
¤ 49.95
4 2 22 3
¤ 29.97
5 3 41 5
¤ 29.95
6 4 57 1 ¤ 6.99
7 5 40 1
¤ 10.99
8 6 34 1
¤ 80.99
9 7 38 1
¤ 105.99
10 8 41 1
¤ 5.99
11 9 34 2
¤ 161.98
12 10 8 1
¤ 9.99
13 11 7 1
¤ 3.99
14 12 51 2
¤ 65.98
15 13 19 1
¤ 162.99
16 14 49 5
¤ 9.95
17 15 43 1 ¤ 9.99
18 16 21 1
¤ 2.99
19 17 43 1 ¤ 9.99
20 18 5 1 ¤ 6.99
21 19 41 2
¤ 11.98
22 20 40 5
¤ 54.95
23 21 48 1
¤ 71.99
24 22 19 1 ¤ 162.99
25 23 3 2
¤ 7.98
26 23 34 1 ¤ 80.99
27 24 48 1 ¤ 71.99
28 25 7 3
¤ 11.97
29 26 51 3
¤ 98.97
30 27 8 1 ¤ 9.99
31 27 13 1
¤ 389.99
32 27 42 1
¤ 27.99
33 28 31 1 ¤ 9.99
34 29 48 1 ¤ 71.99
35 29 20 1
¤ 4.99
36 30 43 1 ¤ 9.99
37 31 17 1
¤ 58.99
38 32 6 1
¤ 1.99
39 33 34 1 ¤ 80.99
40 34 52 1 ¤ 9.99
41 34 19 1 ¤ 162.99
42 35 4 2 ¤ 7.98
43 36 1 1 ¤ 9.99
44 36 25 1
¤ 72.99
45 37 48 1 ¤ 71.99
46 38 4 1 ¤ 3.99
47 39 48 1 ¤ 71.99
48 39 8 1 ¤ 9.99
49 40 41 2 ¤ 11.98
50 41 43 1 ¤ 9.99
51 42 59 1 ¤ 2.99
52 42 18 3
¤ 23.97
53 43 43 1 ¤ 9.99
54 44 56 1 ¤ 32.99
55 44 40 2
¤ 21.98
56 45 1 1 ¤ 9.99
57 45 56 1 ¤ 32.99
58 46 8 1 ¤ 9.99
60 47 19 1 ¤ 162.99
61 48 30 1
¤ 22.99
62 49 6 1 ¤ 1.99
63 50 22 2
¤ 19.98
64 50 22 1 ¤ 9.99
65 50 17 1 ¤ 58.99
66 51 12 1
¤ 259.99
67 52 7 1 ¤ 3.99
68 53 26 1 ¤ 9.99
69 54 53 1
¤ 25.99
70 54 27 1 ¤ 2.99
71 55 34 1 ¤ 80.99
72 55 21 1 ¤ 2.99
73 55 16 1 ¤ 9.99
74 55 37 17
¤ 169.83
75 56 59 1 ¤ 2.99
76 56 34 1 ¤ 80.99
77 57 51 1 ¤ 32.99
78 57 6 1 ¤ 1.99
79 57 24 1
¤ 14.99
80 58 12 1 ¤ 259.99
81 58 57 1 ¤ 6.99
82 59 18 3 ¤ 23.97
83 60 31 1
¤ 113.99
84 60 22 2 ¤ 19.98
85 60 18 1
¤ 7.99
86 60 12 1 ¤ 259.99
87 61 36 1 ¤ 32.99
88 62 7 1 ¤ 3.99
89 63 52 3 ¤ 29.97
90 63 55 1 ¤ 22.99
91 63 22 3 ¤ 29.97
92 63 45 1
¤ 12.99
93 64 45 1 ¤ 12.99
94 65 1 1 ¤ 9.99
95 65 13 1 ¤ 389.99
96 65 58 1 ¤ 22.99
97 66 59 1 ¤ 2.99
98 66 39 2
¤ 91.98
99 67 4 4
¤ 15.96
100 67 2 1 ¤ 9.99
101 67 31 1 ¤ 113.99
102 68 44 2
¤ 5.98
103 69 38 1 ¤ 105.99
104 69 16 1 ¤ 9.99
105 70 44 1 ¤ 2.99
106 70 48 1 ¤ 71.99
107 70 21 1 ¤ 2.99
108 70 46 1
¤ 103.99
109 71 19 1 ¤ 162.99
110 72 45 1 ¤ 12.99
111 73 4 3 ¤ 11.97
112 74 7 1 ¤ 3.99
113 75 53 1 ¤ 25.99
114 75 12 1 ¤ 259.99
115 75 46 1 ¤ 103.99
116 76 43 1 ¤ 9.99
117 76 3 3 ¤ 11.97
118 76 3 3 ¤ 11.97
119 76 51 2 ¤ 65.98
120 77 43 2 ¤ 19.98
121 77 38 1 ¤ 105.99
122 77 8 1 ¤ 9.99
123 77 49 3
¤ 5.97
124 78 3 1 ¤ 3.99
125 78 38 1 ¤ 105.99
126 78 46 1 ¤ 103.99
127 78 24 1 ¤ 14.99
128 79 29 1 ¤ 1.99
129 80 33 1 ¤ 7.99
130 81 22 2 ¤ 19.98
131 81 38 1 ¤ 105.99
132 81 23 1 ¤ 4.99
133 82 4 1 ¤ 3.99
134 82 54 1 ¤ 32.99
135 82 27 1 ¤ 2.99
136 82 13 1 ¤ 389.99
137 83 52 5 ¤ 49.95
138 83 58 1 ¤ 22.99
139 83 40 1 ¤ 10.99
140 83 29 2
¤ 3.98
141 84 7 1 ¤ 3.99
142 84 51 3 ¤ 98.97
143 84 57 1 ¤ 6.99
144 85 12 1 ¤ 259.99
145 85 14 1 ¤ 80.99
146 85 30 1 ¤ 22.99
147 85 20 2
¤ 9.98
148 86 1 1 ¤ 9.99
149 86 58 1 ¤ 22.99
150 86 24 1 ¤ 14.99
151 87 18 3 ¤ 23.97
152 88 21 1 ¤ 2.99
153 88 20 1 ¤ 4.99
154 88 20 1 ¤ 4.99
155 88 37 18
¤ 179.82
156 89 8 1 ¤ 9.99
157 89 17 1 ¤ 58.99
158 89 37 19
¤ 189.81
159 90 42 1 ¤ 27.99
160 90 27 1 ¤ 2.99
161 90 29 1 ¤ 1.99
162 91 52 2 ¤ 19.98
163 91 3 3 ¤ 11.97
164 91 20 1 ¤ 4.99
165 92 59 2 ¤ 5.98
166 92 46 1 ¤ 103.99
167 93 59 1 ¤ 2.99
168 93 54 1 ¤ 32.99
169 93 49 6
¤ 11.94
170 93 37 15
¤ 149.85
171 94 39 2 ¤ 91.98
172 95 35 1 ¤ 3.99
173 95 1 1 ¤ 9.99
174 95 12 1 ¤ 259.99
175 95 58 1 ¤ 22.99
176 96 55 1 ¤ 22.99
177 96 18 2
¤ 15.98
178 96 56 1 ¤ 32.99
179 97 21 1 ¤ 2.99
180 98 33 1 ¤ 7.99
181 99 3 4 ¤ 15.96
182 99 21 1 ¤ 2.99
183 99 50 1 ¤ 9.99
184 100 52 3 ¤ 29.97
185 100 34 3
¤
242
.97
186 100 18 1 ¤ 7.99
187 101 11 1
¤ 292.99
188 101 30 1 ¤ 22.99
189 101 23 2 ¤ 9.98
190 101 40 2 ¤ 21.98
191 102 34 2 ¤ 161.98
192 103 4 5
¤ 19.95
193 103 14 1 ¤ 80.99
194 103 20 1 ¤ 4.99
195 103 24 1 ¤ 14.99
196 104 6 1 ¤ 1.99
197 105 7 1 ¤ 3.99
198 105 38 1 ¤ 105.99
199 106 52 2 ¤ 19.98
200 106 11 1 ¤ 292.99
201 106 8 1 ¤ 9.99
202 107 7 1 ¤ 3.99
203 107 28 1 ¤ 1.99
204 107 34 1 ¤ 80.99
205 107 58 1 ¤ 22.99
206 108 54 1 ¤ 32.99
207 108 3 4 ¤ 15.96
208 108 36 1 ¤ 32.99
209 109 21 1 ¤ 2.99
210 110 10 1 ¤ 2.99
211 111 4 4 ¤ 15.96
212 111 38 1 ¤ 105.99
213 111 29 3 ¤ 5.97
214 111 24 1 ¤ 14.99
215 112 45 1 ¤ 12.99
216 113 15 1 ¤ 162.99
217 113 14 1 ¤ 80.99
218 114 17 1 ¤ 58.99
219 115 48 1 ¤ 71.99
220 115 5 1 ¤ 6.99
221 116 53 1 ¤ 25.99
222 117 4 4 ¤ 15.96
223 117 2 1 ¤ 9.99
224 117 7 1 ¤ 3.99
225 117 25 1 ¤ 72.99
226 118 31 1 ¤ 113.99
227 118 1 1 ¤ 9.99
228 119 32 1
¤ 15.99
229 120 22 1 ¤ 9.99
230
120 56 1 ¤ 32.99
231 120 12 1 ¤ 259.99
232 121 53 1 ¤ 25.99
233
121 53 1 ¤ 25.99
234 121 48 1 ¤ 71.99
235 122 34 1 ¤ 80.99
236 122 33 1 ¤ 7.99
237 122 14 1 ¤ 80.99
238 123 35 1 ¤ 3.99
239 123 24 1 ¤ 14.99
240 124 25 1 ¤ 72.99
241 125 34 1 ¤ 80.99
242 125 29 2 ¤ 3.98
243 125 19 1 ¤ 162.99
244 126 34 2 ¤ 161.98
245 126 51 2 ¤ 65.98
246 127 19 1 ¤ 162.99
247
128 27 1 ¤ 2.99
248 128 50 2 ¤ 19.98
249 128 20 3
¤ 14.97
250 128 17 1 ¤ 58.99
251 129 54 1 ¤ 32.99
252 129 26 2 ¤ 19.98
253
130 42 1 ¤ 27.99
254 130 31 1 ¤ 113.99
255 130 48 2
¤ 143.98
256
131 55 1 ¤ 22.99
257 131 30 1 ¤ 22.99
258 131 57 1 ¤ 6.99
259 131 50 1 ¤ 9.99
260 132 1 1 ¤ 9.99
261
132 1 1 ¤ 9.99
262
132 18 3 ¤ 23.97
263 132 19 1 ¤ 162.99
264
133 4 2 ¤ 7.98
265 134 2 1 ¤ 9.99
266 135 53 1 ¤ 25.99
267 136 40 4
¤ 43.96
268 137 14 1 ¤ 80.99
269 137 50 1 ¤ 9.99
270
137 49 3 ¤ 5.97
271 137 24 1 ¤ 14.99
272 138 18 1 ¤ 7.99
273
138 26 3 ¤ 29.97
274
138 9 1 ¤ 4.99
275 139 22 2 ¤ 19.98
276 140 43 1 ¤ 9.99
277 140 55 1 ¤ 22.99
278 140 6 1 ¤ 1.99
279 140 23 3 ¤ 14.97
280 141 11 1 ¤ 292.99
281 142 43 1 ¤ 9.99
282 142 13 1 ¤ 389.99
283 142 49 2 ¤ 3.98
284 142 24 1 ¤ 14.99
285
143 52 1 ¤ 9.99
286 143 22 3 ¤ 29.97
287
144 12 1 ¤ 259.99
288 144 47 2 ¤ 5.98
289 145 15 1 ¤ 162.99
290 146 1 1 ¤ 9.99
291 146 38 1 ¤ 105.99
292 147 1 1 ¤ 9.99
293 147 5 1 ¤ 6.99
294 148 55 1 ¤ 22.99
295 148 14 1 ¤ 80.99
296 149 4 3 ¤ 11.97
297 150 35 1 ¤ 3.99
298 150 28 1 ¤ 1.99
299 151 35 1 ¤ 3.99
300 151 43 1 ¤ 9.99
301 151 42 1 ¤ 27.99
302 152 55 1 ¤ 22.99
303
153 21 1 ¤ 2.99
304 153 50 1 ¤ 9.99
305 153 41 4
¤ 23.96
306
154 39 2 ¤ 91.98
307 155 33 1 ¤ 7.99
308 155 57 1 ¤ 6.99
309 155 41 3
¤ 17.97
310 156 53 1 ¤ 25.99
311 156 55 1 ¤ 22.99
312 156 55 1 ¤ 22.99
313 156 29 4
¤ 7.96
314 157 4 3 ¤ 11.97
315
157 44 5
¤ 14.95
316 157 3 4 ¤ 15.96
317 158 21 1 ¤ 2.99
318 158 50 1 ¤ 9.99
319 159 54 1 ¤ 32.99
320
160 56 1 ¤ 32.99
321 160 15 1 ¤ 162.99
322 160 20 2 ¤ 9.98
323 161 5 1 ¤ 6.99
324
161 30 1 ¤ 22.99
325 161 20 1 ¤ 4.99
326 162 55 1 ¤ 22.99
327 163 24 1 ¤ 14.99
328 164 28 1 ¤ 1.99
329 164 32 1 ¤ 15.99
330 164 9 1 ¤ 4.99
331 164 17 1 ¤ 58.99
332 165 41 2 ¤ 11.98
333 166 59 3
¤ 8.97
334 167 40 1 ¤ 10.99
335
168 2 1 ¤ 9.99
336 169 51 3 ¤ 98.97
337
169 15 1 ¤ 162.99
338 170 4 3 ¤ 11.97
339 170 45 1 ¤ 12.99
340 170 51 3 ¤ 98.97
341
170 29 5 ¤ 9.95
342 171 19 1 ¤ 162.99
343 172 55 1 ¤ 22.99
344 172 31 1 ¤ 113.99
345 172 3 5 ¤ 19.95
346 172 46 1 ¤ 103.99
347
173 56 1 ¤ 32.99
348 173 13 1 ¤ 389.99
349
173 30 1 ¤ 22.99
350 173 24 1 ¤ 14.99
351 174 30 1 ¤ 22.99
352 175 35 1 ¤ 3.99
353 175 33 1 ¤ 7.99
354
175 47 5 ¤ 14.95
355 176 43 1 ¤ 9.99
356 176 27 1 ¤ 2.99
357 176 45 1 ¤ 12.99
358
176 58 1 ¤ 22.99
359
177 38 1 ¤ 105.99
360 178 26 2 ¤ 19.98
361 178 20 3 ¤ 14.97
362
179 4 4 ¤ 15.96
363 179 49 1 ¤ 1.99
364 180 34 3
¤ 242.97
365 180 21 1 ¤ 2.99
366 181 31 1 ¤ 113.99
367 181 45 1 ¤ 12.99
368 181 15 1 ¤ 162.99
369 182 52 5 ¤ 49.95
370 182 34 3 ¤ 242.97
371 182 32 1 ¤ 15.99
372
182 40 1 ¤ 10.99
373 183 30 1 ¤ 22.99
374 183 17 1 ¤ 58.99
375 184 24 1 ¤ 14.99
376 185 21 1 ¤ 2.99
377 186 55 1 ¤ 22.99
378 186 42 1 ¤ 27.99
379 186 51 2 ¤ 65.98
380 186 17 1 ¤ 58.99
381 187 54 1 ¤ 32.99
382 187 21 1 ¤ 2.99
383 187 5 1 ¤ 6.99
384
187 37 3 ¤ 29.97
385
188 57 1 ¤ 6.99
386 189 32 1 ¤ 15.99
387 189 8 1 ¤ 9.99
388 190 22 4
¤ 39.96
389 190 21 1 ¤ 2.99
390
190 38 1 ¤ 105.99
391
190 58 2
¤ 45.98
392 191 35 1 ¤ 3.99
393 191 15 1 ¤ 162.99
394 191 32 1 ¤ 15.99
395 191 40 2 ¤ 21.98
396
192 51 3 ¤ 98.97
397
192 8 1 ¤ 9.99
398 192 40 3
¤ 32.97
399 193 42 1 ¤ 27.99
400 193 7 1 ¤ 3.99
401 193 46 1 ¤ 103.99
402 194 4 3 ¤ 11.97
403 194 28 2 ¤ 3.98
404
194 28 3 ¤ 5.97
405
194 25 1 ¤ 72.99
406 195 55 1 ¤ 22.99
407 195 44 5 ¤ 14.95
408 195 5 2
¤ 13.98
409 195 19 1 ¤ 162.99
410 196 27 1 ¤ 2.99
411 196 45 2
¤ 25.98
412 196 25 1 ¤ 72.99
413 197 5 3
¤ 20.97
414 198 11 1 ¤ 292.99
415 198 8 1 ¤ 9.99
416 198 20 1 ¤ 4.99
417 199 4 3 ¤ 11.97
418 199 49 5 ¤ 9.95
419 199 19 1 ¤ 162.99
420 200 12 1 ¤ 259.99
421
200 13 1 ¤ 389.99
422 200 57 1 ¤ 6.99
423
201 15 1 ¤ 162.99
424 202 26 1 ¤ 9.99
425 202 10 3 ¤ 8.97
426 203 59 1 ¤ 2.99
427
203 52 3 ¤ 29.97
428
203 1 1 ¤ 9.99
429 203 10 3 ¤ 8.97
430 204 31 1 ¤ 113.99
431 204 12 1 ¤ 259.99
432 204 49 1 ¤ 1.99
433 205 44 3 ¤ 8.97
434 205 33 1 ¤ 7.99
435 205 8 1 ¤ 9.99
436 206 13 1 ¤ 389.99
437 206 39 2 ¤ 91.98
438 207 34 3 ¤ 242.97
439
207 1 1 ¤ 9.99
440
207 12 1 ¤ 259.99
441 208 52 1 ¤ 9.99
442 208 52 4 ¤ 39.96
443
209 59 1 ¤ 2.99
444
209 53 1 ¤ 25.99
445 209 14 1 ¤ 80.99
446 209 24 1 ¤ 14.99
447 210 43 1 ¤ 9.99
448 211 4 4 ¤ 15.96
449 211 43 1 ¤ 9.99
450 211 5 4
¤ 27.96
451
211 6 1 ¤ 1.99
452 212 22 2 ¤ 19.98
453 212 20 1 ¤ 4.99
454 212 29 5 ¤ 9.95
455 212 19 1 ¤ 162.99
456 213 28 4 ¤ 7.96
457 213 45 1 ¤ 12.99
458 213 57 1 ¤ 6.99
459 213 26 2 ¤ 19.98
460 214 14 1 ¤ 80.99
461 214 13 1 ¤ 389.99
462
215 27 1 ¤ 2.99
463 215 21 1 ¤ 2.99
464 215 9 1 ¤ 4.99
465 216 5 2 ¤ 13.98
466 217 44 5 ¤ 14.95
467 217 15 1 ¤ 162.99
468 218 53 1 ¤ 25.99
469 218 31 1 ¤ 113.99
470
218 7 1 ¤ 3.99
471
218 25 1 ¤ 72.99
472 219 1 1 ¤ 9.99
473
219 33 1 ¤ 7.99
474 219 37 19 ¤ 189.81
475
220 54 1 ¤ 32.99
476 220 42 1 ¤ 27.99
477 220 11 1 ¤ 292.99
478 221 18 2 ¤ 15.98
479
221 6 1 ¤ 1.99
480 221 36 1 ¤ 32.99
481 222 53 1 ¤ 25.99
482 222 15 1 ¤ 162.99
483 222 23 2 ¤ 9.98
484 223 14 1 ¤ 80.99
485
224 59 1 ¤ 2.99
486 224 50 1 ¤ 9.99
487 225 59 2 ¤ 5.98
488 225 42 ¤ 0.00
489 225 50 1 ¤ 9.99
490 226 43 1 ¤ 9.99
491
226 34 3 ¤ 242.97
492 227 41 2 ¤ 11.98
493
227 10 5 ¤ 14.95
494 228 59 1 ¤ 2.99
495 228 49 3 ¤ 5.97
496 228 24 1 ¤ 14.99
ProductID
ProductCode
ProductDescription
SalePrice
ProductCategory
ID
UnitOfMeasure
Attachments
Discontinued
1
TF-2
TF Starting Blocks
¤ 103.99 9
Each
false
2
Mi-2
Mouthguard
¤ 2.99 25 Each false
3
FH-2
Field
Hockey
Net
¤ 71.99 15 Each false
4
RB-1
Rugby
Cones
¤ 1.99 10
Package
false
5
RB-2
Rugby Ball
¤ 9.99 10 Each false
6
FB-6
Football
Pads
¤ 32.99 1 Each false
7
Ba-5
Baseball
Batting Gloves
¤ 9.99 3
Pair
false
8
Ba-6
Baseball Bats
¤ 25.99 3 Each false
9
Ba-7
Baseball Catcher Glove
¤ 32.99 3 Each false
10
Ba-8
Baseball Catchers Mask
¤ 22.99 3 Each false
11
GF-8
Golf
Bag
¤ 32.99 4 Each false
12
HK-5
Hockey Pads
¤ 6.99 5 Each false
13
HK-7
Hockey Skates
¤ 22.99 5 Pair false
14
BD-2
Badminton
Racket
¤ 2.99 16 Each false
15
FB-1
Football ¤ 9.99 1 Each false
16
BB-1
Basketball
¤ 9.99 2 Each false
17
BB-2
Basketball Net
¤ 3.99 2 Each false
18
Ba-1
Baseball ¤ 3.99 3
Box
false
19
GF-1
Golf Ball
¤ 6.99 4 Package false
20
HK-1
Hockey Puck
¤ 1.99 5 Box false
21
CR-1
Cricket
Bat
¤ 3.99 6 Each false
22
HK-2
Hockey Net ¤ 9.99 5 Each false
23
SO-1
Soceer
Ball
¤ 4.99 7 Each false
24
TS-1
Tennis
Ball
¤ 2.99 8 Box false
25
GF-2
Golf Club Iron
¤ 292.99 4 Each false
26
GF-3
Golf Club Putter
¤ 259.99 4 Each false
27
GF-4
Golf Club Wood
¤ 389.99 4 Each false
28
GF-5
Golf Club Wedge
¤ 80.99 4 Each false
29
GF-6
Golf Club Hybrid
¤ 162.99 4 Each false
30
GF-7
Golf Club Chipper
¤ 9.99 4 Each false
31
TS-2
Tennis Net
¤ 58.99 8 Each false
32
FB-2
Football Gloves
¤ 7.99 1 Each false
33
TF-1
TF Hurdles
¤ 162.99 9 Box false
34
RB-3
Rugby Kicker Tee
¤ 4.99 10 Box false
35
FB-3
Football Cones
¤ 2.99 1 Box false
36
BX-1
Boxing
Gloves
¤ 9.99 11 Each false
37
HK-3
Hockey Stick
¤ 4.99 5 Each false
38
VB-1
Volleyball
¤ 14.99 12 Each false
39
VB-2
Volleyball Net
¤ 72.99 12 Each false
40
MM-1
MMA Gloves
¤ 9.99 13 Each false
41
CR-2
Cricket Ball
¤ 2.99 6 Box false
42
CR-3
Cricket Glove
¤ 1.99 6 Each false
43
Mi-1
Tape
¤ 1.99 25 Box false
44
HK-4
Hockey Goal
¤ 22.99 5 Each false
45
BB-3
Basketball Hoop
¤ 113.99 2 Each false
46
HK-6
Hockey Mask
¤ 15.99 5 Each false
47
FB-4
Football Flags
¤ 7.99 1 Box false
48
FH-1
Field Hockey
Stick
¤ 80.99 15 Each false
49
BD-1
Badminton Birdie
¤ 3.99 16 Package false
50
TS-3
Tennis Racket
¤ 32.99 8 Each false
51
Mi-3
Water Bottle
¤ 9.99 25 Each false
52
FB-5
Football Helmet
¤ 105.99 1 Each false
53
SO-2
Soceer Net
¤ 45.99
7 Each false
54
SO-3
Soceer Gloves
¤ 10.99 7 Each false
55
SO-4
Soceer Cones
¤ 5.99 7 Package false
56
Ba-2
Baseball Glove
¤ 27.99 3 Each false
57
Ba-3
Baseball Bases
¤ 9.99 3 Box false
58
Ba-4
Baseball Cones
¤ 2.99 3 Package false
59
Mi-4
Duffel Bag
¤ 12.99 25 Each false
ProductCategoryID ProductCategory
Active
1 Football false
2 Basketball false
3 Baseball false
4 Golf false
5 Hockey false
6 Cricket false
7 Soceer false
8 Tennis false
9
Track & Field
false
10 Rugby false
11 Boxing false
12 Volleyball false
13
MMA
false
14
MotoGP
false
15 Field Hockey false
16 Badminton false
17
Cycling
false
18
Swimming
false
19
Snooker
false
20
Table Tennis
false
21
Gymnastics
false
22
Handball
false
23
Wrestling
false
24
Skiing
false
25
Misc
false
Product
SupplierID
ProductID SupplierID
PurchasePrice
6 1 4
¤ 7.50
51 2 7
¤ 15.00
7 2 10 ¤ 7.50
8 3 10
¤ 3.25
9 4 10
¤ 3.00
2 5 2
¤ 5.00
47 5 6
¤ 4.25
10 6 2
¤ 1.25
11 7 8 ¤ 3.25
3 8 2 ¤ 7.50
48 8 6
¤ 6.25
12 9 6
¤ 3.75
52 9 8 ¤ 5.00
13 10 1
¤ 2.00
53 10 2
¤ 1.00
54 11 7
¤ 225.00
55 12 7
¤ 200.00
56 13 9
¤ 300.00
58 14 1
¤ 62.50
57 15 8
¤ 125.00
49 16 6 ¤ 7.50
14 17 1
¤ 45.00
59 17 5
¤ 50.00
15 18 4 ¤ 6.25
60 18 10
¤ 10.00
16 19 7 ¤ 125.00
17 20 6 ¤ 3.75
1 21 3 ¤ 2.00
46 21 4
¤ 1.50
61 22 7
¤ 12.50
18 22 10 ¤ 7.50
19 23 2 ¤ 3.75
62 23 10 ¤ 5.00
20 24 1
¤ 11.25
63 24 10 ¤ 6.25
64 25 1 ¤ 50.00
21 25 6
¤ 56.25
22 26 1 ¤ 7.50
65 26 8 ¤ 5.00
23 27 8
¤ 2.50
66 27 9 ¤ 2.00
67 28 3 ¤ 1.00
24 28 8 ¤ 1.25
25 29 5 ¤ 1.25
68 29 10 ¤ 2.50
5 30 2
¤ 17.50
50 30 6
¤ 20.00
69 30 8
¤ 30.00
70 31 7
¤ 75.00
26 31 10
¤ 87.50
27 32 2 ¤ 12.50
71 32 6 ¤ 7.50
28 33 3 ¤ 6.25
72 33 9
¤ 21.25
29 34 1 ¤ 62.50
73 35 7 ¤ 3.75
30 35 9 ¤ 3.00
31 36 1
¤ 25.00
74 36 4 ¤ 30.00
32 37 1 ¤ 7.50
75 37 6 ¤ 1.25
33 38 7
¤ 81.25
76 38 8
¤ 35.00
77 39 6
¤ 8.75
34 39 8 ¤ 35.00
35 40 6 ¤ 8.75
78 40 8 ¤ 6.25
36 41 6
¤ 4.50
79 41 9 ¤ 3.75
37 42 6 ¤ 21.25
80 42 8 ¤ 11.25
81 43 5
¤ 3.50
38 43 6 ¤ 7.50
39 44 6 ¤ 2.00
82 44 10
¤ 1.75
83 45 4 ¤ 12.50
40 45 6 ¤ 10.00
84 46 4
¤ 31.25
41 46 7
¤ 80.00
85 47 1 ¤ 3.75
42 47 7 ¤ 2.50
43 48 1
¤ 55.00
86 48 7 ¤ 45.00
44 49 6 ¤ 1.75
87 49 7 ¤ 5.00
45 50 6 ¤ 7.50
88 50 7 ¤ 8.75
89 51 8 ¤ 25.00
90 52 3 ¤ 7.50
91 53 1 ¤ 20.00
92 54 4 ¤ 25.00
93 55 4 ¤ 17.50
4 56 2 ¤ 25.00
94 56 5
¤ 37.50
95 57 9 ¤ 5.00
96 58 9 ¤ 17.50
97 59 8 ¤ 2.50
EmployeeID
Department
SalespersonID
Commission
4
10359
2 0.1
1 10359 1
0.075
SupplierID
CompanyName
Address1 Address2 City State ZIP Country Phone
FaxNumber
EmailAddress
WebPage
Notes Attachments
1
Anderson Co
8888 Valley Blvd
Seattle WA
74363
USA
1336595424
8860937020
2
Bottle Rocket Corp
123 1st Street Memphis TN 85096 USA
3264589241
9209950314
3
Wired Keys
789 28th Street Salt Lake City UT
88890
USA
7811594120
1263848342
4
Lights Out
123 9th Street Denver CO 88326 USA
5111426643
2000606049
5
Table Top Supplies
789 29th Street Los Angelas CA
47174
USA
2210064903
9301520951
6
Rope & Stuff Inc
123 3rd Street Milwaukee WI 24520 USA
4218930217
1679279903
7
Last Hope Corp
123 6th Street Miami FL
13803
USA
5053252680
3330132162
8
Flowers Inc
789 26th Street Denver CO
85678
USA
3803076535
6093917995
9
Sandberg Custom Designs
789 29th Street Milwaukee WI
10213
USA
4034088702
5221651845
10
Sweet Little Supplies
123 6th Street Miami FL 13803 USA
8879125346
5648692867
SupplierContactID
SupplierID ContactID
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 7 7
8 8 8
9 9 9
10 10 10
11 1 11
12 1 12
SELECT [ID], [Company]
FROM [Customers Extended]
ORDER BY [Company];
SELECT [ID], [Employee Name]
FROM [Employees Extended]
ORDER BY [Employee Name];
SELECT [ID], [Company]
FROM [Shippers Extended]
ORDER BY [Company];
SELECT Inventory.[Product ID], Inventory.[Product Name], Inventory.[Qty Available]
FROM Inventory
ORDER BY Inventory.[Product Name];
SELECT [Customer].[CustomerID]
FROM Customer
ORDER BY [CustomerID];
PARAMETERS __Order.OrderID Value;
SELECT DISTINCTROW *
FROM [SELECT OrderLine.OrderID, OrderLine.ProductID, Product.ProductCode, Product.ProductDescription, OrderLine.[QuantitySold], Product.SalePrice, orderline.[QuantitySold]*product.salePrice AS LineTotal FROM Product INNER JOIN OrderLine ON Product.[ProductID] = OrderLine.[ProductID]]. AS Order
WHERE ([__Order].OrderID = OrderID);
SELECT ProductCategory.*
FROM ProductCategory;
PARAMETERS __ProductID Value;
SELECT DISTINCTROW *
FROM [SELECT ProductSupplier.ProductSupplierID, ProductSupplier.ProductID, ProductSupplier.SupplierID, ProductSupplier.PurchasePrice, Supplier.CompanyName, [Contact].[FirstName]+” “+[Contact].[LastName] AS Contact FROM ((Supplier INNER JOIN ProductSupplier ON Supplier.SupplierID = ProductSupplier.SupplierID) INNER JOIN SupplierContact ON Supplier.SupplierID = SupplierContact.SupplierID) INNER JOIN Contact ON SupplierContact.ContactID = Contact.ContactID]. AS Product
WHERE ([__ProductID] = ProductID);
SELECT ID, [Employee Name]
FROM [Employees Extended]
ORDER BY [Employee Name];
SELECT ID, [Employee Name]
FROM [Employees Extended]
ORDER BY [Employee Name];
SELECT ID, [Employee Name]
FROM [Employees Extended]
ORDER BY [Employee Name];
SELECT [ID], [Company]
FROM [Suppliers Extended]
ORDER BY [Company];
SELECT Id, [Product Name]
FROM Products
ORDER BY [Product Name];
SELECT [Sales Reports].[Group By], [Sales Reports].Title
FROM [Sales Reports]
ORDER BY [Sales Reports].Title;
SELECT Order.*, [LastName] & ” ” & [FirstName] AS FullName, Order.OrderID
FROM Customer INNER JOIN Order ON Customer.CustomerID = Order.CustomerID
ORDER BY Order.OrderID;
SELECT Product.ProductID, Product.ProductCode, Product.ProductDescription, Product.SalePrice, Product.ProductCategoryID, Product.[UnitOfMeasure], Product.Attachments, Product.Discontinued, ProductCategory.ProductCategory
FROM ProductCategory INNER JOIN Product ON ProductCategory.ProductCategoryID = Product.ProductCategoryID;
SELECT DISTINCTROW *
FROM Customer;
What Will You Get?
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Premium Quality
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Experienced Writers
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
On-Time Delivery
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
24/7 Customer Support
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Complete Confidentiality
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
Authentic Sources
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Moneyback Guarantee
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
Order Tracking
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Preferred Writer
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Grammar Check Report
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
One Page Summary
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
Plagiarism Report
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Free Features $66FREE
Most Qualified Writer
$10FREE
Plagiarism Scan Report
$10FREE
Unlimited Revisions
$08FREE
Paper Formatting
$05FREE
Cover Page
$05FREE
Referencing & Bibliography
$10FREE
Dedicated User Area
$08FREE
24/7 Order Tracking
$05FREE
Periodic Email Alerts
$05FREE
Our Services
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
On-time Delivery
24/7 Order Tracking
Access to Authentic Sources
Academic Writing
We create perfect papers according to the guidelines.
Professional Editing
We seamlessly edit out errors from your papers.
Thorough Proofreading
We thoroughly read your final draft to identify errors.
Thorough Proofreading
We thoroughly read your final draft to identify errors.
Delegate Your Challenging Writing Tasks to Experienced Professionals
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
We Analyze Your Problem and Offer Customized Writing
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
Clear elicitation of your requirements.
Customized writing as per your needs.
We Mirror Your Guidelines to Deliver Quality Services
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
Proactive analysis of your writing.
Active communication to understand requirements.
We Handle Your Writing Tasks to Ensure Excellent Grades
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.
Thorough research and analysis for every order.
Deliverance of reliable writing service to improve your grades.
