Customer Order Table (Event) Order # Employee # Customer # Date Comments 1003 M24SP B104 01/03/2011 1004 R63SP P202 01/03/2011 Ship ASAP 1005 M24SP S200 01/03/2011 1006 W11SP C100 01/03/2011 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar $0.20 $0.40 13025 1500 Almond Delight $0.25 $0.45 5010 1600 Gummy Lions $0.60 $0.95 20109 1700 Pecan Bar $0.70 $1.09 4508 1800 Milky Bars $0.18 $0.30 2207 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 Amanda Wills 22 Yellow Ln. Charlotte NC 79803 $20,000.00 B104 Boris Bailey 321 Church St. Oxford OH 45056 5,000.00 C100 Carly Riccardi P202 Peggy Martin S200 Bill Safer 1899 Green St. 1260 Main St. 860 Broad St. Dayton OH 43299 10,000.00 Columbus OH 43320 10,000.00 Fairfax VA 22030 5,000.00 Salesperson Table (Agent) Employee # Name Address A06SP M24SP Sally Anderson Randy Merit R63SP Barry Rogers 3026 Skye Ln. 262 Main St. 80 N. Long St. City Columbus OH 43213 Bexley State Zip Code Dept ID Date Hired 247 1/31/1989 OH 43209 182 7/2/1999 Gahanna OH 43215 247 1/16/2001 R73SP Jim Rudolph 64 Lantern Ave. Columbus OH 43213 76 8/15/2000 W11SP John Walker 1028 Fields Ln. Lancaster OH 43307 182 9/1/1992 FIGURE 3-11 Four sample tables in a relational database. Customer Order Table (Event) Order # Employee # Customer # Date Comments 1003 M24SP B104 01/03/2011 1004 R63SP P202 01/03/2011 Ship ASAP 1005 M24SP S200 01/03/2011 1006 W11SP C100 01/03/2011 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar $0.20 $0.40 13025 1500 Almond Delight $0.25 $0.45 5010 1600 Gummy Lions $0.60 $0.95 20109 1700 Pecan Bar $0.70 $1.09 4508 1800 Milky Bars $0.18 $0.30 2207 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 Amanda Wills 22 Yellow Ln. Charlotte NC 79803 $20,000.00 B104 Boris Bailey 321 Church St. Oxford OH 45056 5,000.00 C100 Carly Riccardi P202 Peggy Martin S200 Bill Safer 1899 Green St. 1260 Main St. 860 Broad St. Dayton OH 43299 10,000.00 Columbus OH 43320 10,000.00 Fairfax VA 22030 5,000.00 Salesperson Table (Agent) Employee # Name Address A06SP M24SP Sally Anderson Randy Merit R63SP Barry Rogers 3026 Skye Ln. 262 Main St. 80 N. Long St. City Columbus OH 43213 Bexley State Zip Code Dept ID Date Hired 247 1/31/1989 OH 43209 182 7/2/1999 Gahanna OH 43215 247 1/16/2001 R73SP Jim Rudolph 64 Lantern Ave. Columbus OH 43213 76 8/15/2000 W11SP John Walker 1028 Fields Ln. Lancaster OH 43307 182 9/1/1992 FIGURE 3-11 Four sample tables in a relational database. Customer Order Table (Event) Order # Employee # Customer # Date Comments 1003 M24SP B104 01/03/2011 1004 R63SP P202 01/03/2011 Ship ASAP 1005 M24SP S200 01/03/2011 1006 W11SP C100 01/03/2011 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar $0.20 $0.40 13025 1500 Almond Delight $0.25 $0.45 5010 1600 Gummy Lions $0.60 $0.95 20109 1700 Pecan Bar $0.70 $1.09 4508 1800 Milky Bars $0.18 $0.30 2207 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 Amanda Wills 22 Yellow Ln. Charlotte NC 79803 $20,000.00 B104 Boris Bailey 321 Church St. Oxford OH 45056 5,000.00 C100 Carly Riccardi P202 Peggy Martin S200 Bill Safer 1899 Green St. 1260 Main St. 860 Broad St. Dayton OH 43299 10,000.00 Columbus OH 43320 10,000.00 Fairfax VA 22030 5,000.00 Salesperson Table (Agent) Employee # Name Address A06SP M24SP Sally Anderson Randy Merit R63SP Barry Rogers 3026 Skye Ln. 262 Main St. 80 N. Long St. City Columbus OH 43213 Bexley State Zip Code Dept ID Date Hired 247 1/31/1989 OH 43209 182 7/2/1999 Gahanna OH 43215 247 1/16/2001 R73SP Jim Rudolph 64 Lantern Ave. Columbus OH 43213 76 8/15/2000 W11SP John Walker 1028 Fields Ln. Lancaster OH 43307 182 9/1/1992 FIGURE 3-11 Four sample tables in a relational database. Customer Order Table (Event) Order # Employee # Customer # Date Comments 1003 M24SP B104 01/03/2011 1004 R63SP P202 01/03/2011 Ship ASAP 1005 M24SP S200 01/03/2011 1006 W11SP C100 01/03/2011 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar $0.20 $0.40 13025 1500 Almond Delight $0.25 $0.45 5010 1600 Gummy Lions $0.60 $0.95 20109 1700 Pecan Bar $0.70 $1.09 4508 1800 Milky Bars $0.18 $0.30 2207 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 Amanda Wills 22 Yellow Ln. Charlotte NC 79803 $20,000.00 B104 Boris Bailey 321 Church St. Oxford OH 45056 5,000.00 C100 Carly Riccardi P202 Peggy Martin S200 Bill Safer 1899 Green St. 1260 Main St. 860 Broad St. Dayton OH 43299 10,000.00 Columbus OH 43320 10,000.00 Fairfax VA 22030 5,000.00 Salesperson Table (Agent) Employee # Name Address A06SP M24SP Sally Anderson Randy Merit R63SP Barry Rogers 3026 Skye Ln. 262 Main St. 80 N. Long St. City Columbus OH 43213 Bexley State Zip Code Dept ID Date Hired 247 1/31/1989 OH 43209 182 7/2/1999 Gahanna OH 43215 247 1/16/2001 R73SP Jim Rudolph 64 Lantern Ave. Columbus OH 43213 76 8/15/2000 W11SP John Walker 1028 Fields Ln. Lancaster OH 43307 182 9/1/1992 FIGURE 3-11 Four sample tables in a relational database