Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Identify primary key and foreign key for each of the following tables. Customers Invoices Payments Cust Num Customer Status Name InvoiceCustInvoice Invoice Cust Check Invoice

image text in transcribedimage text in transcribedimage text in transcribed

Identify primary key and foreign key for each of the following tables. Customers Invoices Payments Cust Num Customer Status Name InvoiceCustInvoice Invoice Cust Check Invoice Check Num Check Amount Num Date Amount Num Number Number Date 101 102 103 104 21 1001101 1/1/05 1002101 1/2/05 1003103 1/4/05 1004104 1/6/05 1005102 1/8/05 1006102 1/10/05 2,180 102 141 1007101 1/11/05 10042/2/05 2,245 894 103 0287 1003 2/2/05 1,725 1,750101 115681001 2/2/05 1,176 824 508 1006 2/4/05 1,180 10062/4/05 1,000 104 8191 Target Walmart 27 K-Mart BestBuy 18 1,176 16 2,245101 11569 1002 2/4/05 633 101 11570 1007 2/4/05 551 102 142 According to the tables in Exercise 13, answer the following queries. Note. For each query, answer the Tables, Links, Conditions and Fields (step 1,2,3) ONLY Q.1. Display Customer Number, Customer Name, Invoice Date, and Invoice Amount of Invoice# 1006. - Which TABLES do you need and how they are LINKed? -What are the conditions? Which fields do you want to see? Q.2. How many invoices were issued to Customer 102? Which TABLES do you need and how they are LINKed? What are the conditions? Which fields do you want to see? Q.3. What is the total invoice amount issued to Customer 102? Which TABLES do you need and how they are LINKed? - What are the conditions? Which fields do you want to see? Q.4. What is the total payment amount we received from Customer 102? Which TABLES do you need and how they are LINKed? What are the conditions? Which fields do you want to see? Q.5. There are times where customers would pay less than the invoice amount. Display the amount difference of invoice 1002. Which TABLES do you need and how they are LINKed? What are the conditions? Which fields do you want to see

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago