Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered 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