Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Heff Heff
wrote...
Go to Answer
Posts: 1330
Rep: 3 0
6 years ago
Based on the tables below, which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo, CustName, RepName?

GENERAL SALES DATABASE:

   SALESREP
SalesRepNo   RepName   HireDate
654   Jones   01/02/1999
734   Smith   02/03/2000
345   Chen   01/25/1998
434   Johnson   11/23/1998

   CUSTOMER
CustNo   CustName   Balance   SalesRepNo
9870   Winston   500   345
8590   Gonzales   350   434
7840   Harris   800   654
4870   Miles   100   345

A) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER;
B) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
C) SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
D) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
E) CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 240 times
4 Replies
Replies
Answer verified by a subject expert
bestavinashbestavinash
wrote...
#1
Top Poster
Posts: 675
Rep: 7 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here

Related Topics

Heff Author
wrote...
#2
5 years ago
This board has been a life saver!
wrote...
#3
3 years ago
Thank you
wrote...
#4
3 years ago
Great
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1248 People Browsing
 123 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 1318
  
 845
  
 9059
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352
Previous poll results: What's your favorite math subject?