List 5 buisness rules relevent to this scenerio.
insert ERD
MMMM A B D E F G H K M N O 1 CustID LName FName Street City State Zip Balance Credit ReplD LName FName Street City State Zip 2 124 Adams Sally 481 Oak Lansing MI 49224 818.75 1000 3 Jones Mary 123 Main Grant 49219 3 124 Adams Sally 481 Oak Lansing MI 49224 818.75 1000 3 Jones Mary 123 Main Grant 49219 4 256 Samuels Ann 215 Pete Grant MI 49219 21.51500 6 Smith William 102 Rayn Ada 49441 5 311 Charles Don 48 College Ira MI 49034 825 75 1000 12 Diaz Miguel 419 Harpe Lansing MI 49224 6 311 Charles Don 48 College Ira MI 49034 825.75 1000 12 Diaz Miguel 419 Harpe Lansing, MI 49224 7 315 Daniels Tom 914 Cherry Kent MI 48391 770.75 750 6 Smith William 102 Rayn'Ada MI 49441 8 405 Williams Al 519 Watson Grant MI 49219 402 75 1500 12 Diaz Miquel 419 Harpe Lansing MI 49224 9 412 Adams Sally 16 Elm Lansing MI 49224 181752000 3 Jones Mary 123 Main Grant MI 49219 10 522 Nelson Mary 108 Pine Ada MI 494411 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 11 522 Nelson Mary 108 Pine Ada MI 49441 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 12 522 Nelson Mary 108 Pine Ada MI 49441 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 13 567 DOI Tran 808 Ridge Harper MI 48421 402.4 6 Smith William 102 Ray Ada MI 49441 14 587 Galvez Mara 512 Pine Ada MI 49441 114,6 1000 6Smith William 102 Rayn. Ada MI 49441 15 622 Martin Dan 419 Chip Grant MI 49219 1045 75 1000 3 Jones Mary 123 Main Grant MI 49219 16 17 18 750 W R S T U V Y Z AA AB te Zip Commission Rate OrdedD Order Date Quantity Quote PartiD Description On Hand Class Warehouse UnitPrice 49219 2150 0.05 12489 9/2/2001 11 14.95 AX12 Iron 104 HW 3 24.95 49219 2150 0.05 12500 9/5/2001 1 149.99 BT04 Gas Grill 11 AP 21 149.99 49441 4912.5 0.07 12495 9/4/2001 2 22.95 CX 11 Blender 112 HW 3 22.95 49224 2150 0.05 12491 9/2/2001 1 149.99 BT04 Gas Grill 11 AP 2 149.99 49224 2150 0.05 12491 9/2/2001 1 399.99 BZ66 Washer 52 AP 3 399.99 49441 4912.5 0.07 12494 9/4/2001 4 279.99 CB03 Bike 44 SG 1 299.99 49224 2150 0.05 49219 2150) 0.05 1 49224 2150 0.05 12498 9/5/2001 2 12.95 AZ52 Dartboard 20 SG 12.95 49224 2150 0.05 12498 9/5/2001 4 24.95 BA74 Basketball 1 29.95 49224 2150 0.05 12504 9/5/2001 2 325.99 CZ81 Treadmill 68 SG 349.95 11 49441 4912.51 0.07 11 49441 4912.5 0.07 MI 49219 2150 0.05 BH22 Compopper 95 HW 3 24.95 CA14 Griddle 78 HW 39.99 40 SG NEN Data Listing (table details) SalesRep Column Data Type Field Size (If Applicable) Comments/Rules/Details RepID LName FNume Street City State Zip Commission Rate Fill in the table above: Identify a data type for each column (Choose from among the generic types listed in Data Types in Mofor ROOMS in week 3 content.) Select a maximum field size for character data types Underline and/or put a # in front of the primary key column(s) Put (FK)" after any columns that are a foreign key. Add your own comments or anything that might help the person who implements your design. . MMMM A B D E F G H K M N O 1 CustID LName FName Street City State Zip Balance Credit ReplD LName FName Street City State Zip 2 124 Adams Sally 481 Oak Lansing MI 49224 818.75 1000 3 Jones Mary 123 Main Grant 49219 3 124 Adams Sally 481 Oak Lansing MI 49224 818.75 1000 3 Jones Mary 123 Main Grant 49219 4 256 Samuels Ann 215 Pete Grant MI 49219 21.51500 6 Smith William 102 Rayn Ada 49441 5 311 Charles Don 48 College Ira MI 49034 825 75 1000 12 Diaz Miguel 419 Harpe Lansing MI 49224 6 311 Charles Don 48 College Ira MI 49034 825.75 1000 12 Diaz Miguel 419 Harpe Lansing, MI 49224 7 315 Daniels Tom 914 Cherry Kent MI 48391 770.75 750 6 Smith William 102 Rayn'Ada MI 49441 8 405 Williams Al 519 Watson Grant MI 49219 402 75 1500 12 Diaz Miquel 419 Harpe Lansing MI 49224 9 412 Adams Sally 16 Elm Lansing MI 49224 181752000 3 Jones Mary 123 Main Grant MI 49219 10 522 Nelson Mary 108 Pine Ada MI 494411 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 11 522 Nelson Mary 108 Pine Ada MI 49441 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 12 522 Nelson Mary 108 Pine Ada MI 49441 98.75 1500 12 Diaz Miguel 419 Harpe Lansing MI 49224 13 567 DOI Tran 808 Ridge Harper MI 48421 402.4 6 Smith William 102 Ray Ada MI 49441 14 587 Galvez Mara 512 Pine Ada MI 49441 114,6 1000 6Smith William 102 Rayn. Ada MI 49441 15 622 Martin Dan 419 Chip Grant MI 49219 1045 75 1000 3 Jones Mary 123 Main Grant MI 49219 16 17 18 750 W R S T U V Y Z AA AB te Zip Commission Rate OrdedD Order Date Quantity Quote PartiD Description On Hand Class Warehouse UnitPrice 49219 2150 0.05 12489 9/2/2001 11 14.95 AX12 Iron 104 HW 3 24.95 49219 2150 0.05 12500 9/5/2001 1 149.99 BT04 Gas Grill 11 AP 21 149.99 49441 4912.5 0.07 12495 9/4/2001 2 22.95 CX 11 Blender 112 HW 3 22.95 49224 2150 0.05 12491 9/2/2001 1 149.99 BT04 Gas Grill 11 AP 2 149.99 49224 2150 0.05 12491 9/2/2001 1 399.99 BZ66 Washer 52 AP 3 399.99 49441 4912.5 0.07 12494 9/4/2001 4 279.99 CB03 Bike 44 SG 1 299.99 49224 2150 0.05 49219 2150) 0.05 1 49224 2150 0.05 12498 9/5/2001 2 12.95 AZ52 Dartboard 20 SG 12.95 49224 2150 0.05 12498 9/5/2001 4 24.95 BA74 Basketball 1 29.95 49224 2150 0.05 12504 9/5/2001 2 325.99 CZ81 Treadmill 68 SG 349.95 11 49441 4912.51 0.07 11 49441 4912.5 0.07 MI 49219 2150 0.05 BH22 Compopper 95 HW 3 24.95 CA14 Griddle 78 HW 39.99 40 SG NEN Data Listing (table details) SalesRep Column Data Type Field Size (If Applicable) Comments/Rules/Details RepID LName FNume Street City State Zip Commission Rate Fill in the table above: Identify a data type for each column (Choose from among the generic types listed in Data Types in Mofor ROOMS in week 3 content.) Select a maximum field size for character data types Underline and/or put a # in front of the primary key column(s) Put (FK)" after any columns that are a foreign key. Add your own comments or anything that might help the person who implements your design
