Need help

For the following exercise, you will answer problems and questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises.

Fragment the Customer table so that customers of rep 15 form a fragment named CustomerRep15, customer of rep 30 form a fragment named CustRep30, customers of rep 45 form a fragment named CustomerRep45, 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 this orders placed by customers of rep 15. Write the SQL-type statements to create these fragments.

RepNum LastName FirstName Street CamposRafael 724 Vinca Dr. Grove GradeyMegan 632 Liatris St. Fullton CA90085 Tian 1785 Tyler Ave. Northfield CA 90098 267 Oukley St. Congaree CA 90097 State PostalCode Balance Creditlimit RepNum Brookings Direct 452 Columbus Dr. Grove CA 90092 The Everything 342 Magee St. Congaree CA 90097 $1,210.25 7,500.00 15 575.00 $10,000.00 30 $2,345.75 $7,500.00 45 Cards and More 167 Hale St. Cricket Gift Shop 372 Oxford St. 12 Rising Sun Ave. Grove Congaree CA 90097 Unique Gifts 786 Passmore St. Northfield CA 90098 945 Gilham St. 382 Wildwood Ave. Mesa Fullton All Season Gifts CA 90085 OrderNm OrderDate ItemNum CD33 Wood Block Set (48 piece) Giant Star Brain Teaser KD34 Pentominoes Brain Teaser Pick Up Sticks Zauberkasten Brain Teaser MT03 NI89 TR40 Wood Block Set (62 piece) Tic Tac Toe