Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
pagnor pagnor
wrote...
Go to Answer
Posts: 1540
Rep: 12 0
6 years ago
Use the database below to answer the following question.

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

Using the CUSTOMER.Balance column as the column providing the data, create a view to display the results of a computed column. Specifically, assume that all customers are required to maintain a minimum balance of 100, and use the view to display customer name and a number named BalanceOverMinimum that calculates (Balance - 100) for all customers in the GENERAL SALES DATABASE.
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 38 times
2 Replies
Genuine Coder
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
1

Related Topics

pagnor Author
wrote...
#2
6 years ago
How do you know everything Grinning Face with Smiling Eyes

Thank you
Genuine Coder
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1006 People Browsing
 159 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 24
  
 318
  
 522
Your Opinion
What's your favorite math subject?
Votes: 293
Previous poll results: Which 'study break' activity do you find most distracting?