Give some examples of field names that you would use for the Customer table in Figure. What data type would you assign to each field using Microsoft Access, and how large would you make each text field? Would you use one data field or two for the customer name?Why?

Transcribed Image Text:

Customer Order Table (Event Order # Employee # Customer # Date Comments 1003 1004 1005 1006 M24SP B104 P202 01/03/02 Ship ASAP 01/03/02 M24SP W11SP 01/03/02 01/03/02 Inventory Table Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar 1500 Almond Delight S0.25 1600 Gummy Lions $0.60 1700 Pecan Bar 1800 Milky Bars $0.40 $0.45 $0.95 $1.09 $0.30 8 20109 S0.70 S0.18 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 B104 C100 Amanda Wills 22 Yellow Ln. Chatte NC 79803 $20,000.00 Boris Bailey 321 Church St. Oxford Carly Riccardi 1899 Green St. Dayton OH 4329910,000.00 Peggy Martin 1260 Main St. Columbus OH 43320 Bill Safer OH 45056 860 Broad St. Fairfax VA 22030 5,000.00 Salesperson Table( Employee # Name Address City State Zip Code Dept ID Date Hired Sally Anderson 3026 Skye Ln. Columbus OH 43213 247 1/31/1989 Randy Mer 262 Main St. Bexley Barry Rogers 80N. Long St Gahanna OH 43215 247 1/16/2001 Jim Rudolph 64 Lantern Ave. Columbus OH 43213 John Walker 028 Fields Ln. Lancaster OH 43307 OH 43209 182 7/2/1999 W11SP 182 9/1/1992