Problem

Fragment the Customer table so that customers of rep 15 form a fragment named CustomerRep1...

Fragment the Customer table so that customers of rep 15 form a fragment named CustomerRep15, customers of rep 30 form a fragment named CustomerRep30, customers of rep 45 form a fragment named Customer- Rep45, and customers of rep 60 form a fragment named CustomerRep60. (Include all fields from the Customer table in each fragment.) In addition, you need to fragment the Orders table so that orders are distributed and stored with the customers that placed the orders. For example, fragment OrdersRep15 consists of those orders placed by customers of rep 15. Write the SQL-type statements to create these fragments.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search