Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Product Table 2101 Caoking oilKa 395 29 Chocolse b) Customer Table 21017 c) Order Table 2. Create Queries The Sales and Marketing Departments would

image text in transcribed
a) Product Table 2101 Caoking oilKa 395 29 Chocolse b) Customer Table 21017 c) Order Table 2. Create Queries The Sales and Marketing Departments would like to use the data in these tables for the purpose of querying the database in order to get answers to specific questions. Construct the following queries. You will need to link the tables together by using the primary keys a List the customer information (all fields) for all customers in Nairobi List the customer information (all fields) for customers who purchased flour item. o List the customer information (all fields) for customers who purchased items worthy 300 and 3. Create Reports After you have entered the data into the three tables, create three reports reflecting the three table data. Remember reports are designed to be used and viewed by other users, so you will need to make them informative. Use the report formatting features and be creative

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

LO4 Identify a system for controlling absenteeism.

Answered: 1 week ago