Question: 1. Manipulate Relational Database Customer Table Customer # Customer name Address Credit Customer limit Age 137651 387902 Adams, john Jones, Andy 20000 35 15000 40

1. Manipulate Relational Database Customer Table Customer # Customer name Address Credit Customer limit Age 137651 387902 Adams, john Jones, Andy 20000 35 15000 40 4651 Adam Ct Sunnyvale Ca 230 Yeadon Way San Jose Ca 4949 Hood Dr Gilroy Ca 7813 Moon Dr Windsor Ca 445567 497622 Tracy. Ben Adams John 10000 28 8000 65 Order Table Order # Order Date Order Amount Order Customer 4972 5573 6421 7575 2/5/2020 2/19/2020 4/15/2020 5/8/2020 8500 3500 S500 1500 Order Product Type Appliance Electronic Garment Electronic 387902 137651 387902 497622 Customer # Customer name Address Credit Customer limit Age 137651 387902 Adams, john Jones, Andy 20000 35 15000 40 4651 Adam Ct Sunnyvale Ca 230 Yeadon Way San Jose Ca 4949 Hood Dr Gilroy Ca 7813 Moon Dr Windsor Ca 445567 497622 Tracy. Ben Adams, John 10000 28 8000 65 Order Table Order # Order Date Order Amount Order Customer 4972 5573 6421 7575 2/5/2020 2/19/2020 4/15/2020 5/8/2020 8500 3500 5500 1500 Order Product Type Appliance Electronic Garment Electronic 387902 137651 387902 497622 Questions: a. What is the primary key of Customer Table, Order Table (2 points) b. Why is customer name not chosen as primary key? (2 points) C What is the foreign key in order table? (1) d. How do you logically connect customer table and order table? What is the average order amount for customer# 387902 (9)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Manipulate Relational Database Customer Table Customer # Customer name Address Credit limit Customer Age 137651 Adams, john 4651 Adam Ct Sunnyvale Ca 20000 35 387902 Jones, Andy 230 Yeadon Way San...

Customer #Customer name Address Customer Agel Credit limit 137651 387902 445567 497622 Adams, john Jones, Andy Tracy, Ben Adams, John 4651 Adam At Sunnyvale Ca 20000 230 Yeadon Way San Jose Ca 15000...

2. Standardized Financial Statements Using the Amazon Financials provided below, prepare the common-size income statements and balance sheets for the two most recent years. and 3. Financial Ratios....

Financial Statement analysis - Homework case number 4. Accounting for Software Revenue Recognition Is Computer Associates Being Too Aggressive? Annual Revenues at Computer Associates (CA) dropped...

Customer Order Table (Event) Order # Employee # Customer # Date Comments 1003 M24SP B104 01/03/2011 1004 R63SP P202 01/03/2011 Ship ASAP 1005 M24SP S200 01/03/2011 1006 W11SP C100 01/03/2011...

Using PowerPoint or similar software, create a visual architectural layout of a relational database program that will track the receivables owed by your customers. The layout must include: 1. At...

database ! Project Description You have been asked to design a database for Healthway Hospital. Healthway depends on a large number of persons for its continued success. There are four groups of...

We are asked to design a database management system for all information related to a real-estate company which has several branches throughout the United States. The first step is to organize the...

For Lamar Company, a mixed cost is $20,000 plus $16 per direct labor hour. Diagram the behavior of the cost using increments of 500 hours up to 2,500 hours on the horizontal axis and increments of...

Provide a brief history of how front desk operations have evolved over the last 25 years, including how tasks have changed, evolved, and/or disappeared. The front desk is considered the heart of...

Which of the flollowing are inverstment decisions, and which are financing decisions? Stuation Decision a . Should we slock we eth inverdory alead of the holdies season? b . Do we reed a bark loan to...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...