DATABASE DESIGN QUESTIONS Dahlia Antiques Business sells antiques at antiques fairs. Dahlia, the store owner, buys inventory at night markets and antique shops. Each time a purchase takes place, Dahlia, the store owner, will record the buyer's name and address, the details and price of the items purchased as well as the amount spent. Upon returning home, Dahlia will clean, research, provide inventory numbers and place a sale price for each inventory item. Dahlia buys price tags and exhibition supplies from businesses that operate night markets and antiques exhibitions. All purchases of inventory and exhibition supplies are paid for using cash or check from a bank account in the name of Dahlia Antiques Business. Cash received from customers is also deposited into the same bank account. Dahlia rents kiosks at antiques fairs three times a year. A deposit must be paid for the rental, while the balance of the rent must be paid at the beginning of the exhibition. Dahlia records the deposit and final payment, as well as the name and address of the exhibition organizer, in the same worksheet she records the purchase of inventory and supplies. Be required: a. Draw a REA (Resources, Events, Agents) diagram related to the purchase of inventory and supplies, kiosk rental, and payment of all items for the Dahlia Antique Business. b. Construct the tables to implement the above REA diagram into a related database. Specify the primary key, foreign key and other appropriate fields for each table. c. Assuming that the Purchase activity and the Cash Payment activity are 1: 1 related, discuss the effect of selecting a foreign key -placed schedule on the process of recording payments to suppliers. DATABASE DESIGN QUESTIONS Dahlia Antiques Business sells antiques at antiques fairs. Dahlia, the store owner, buys inventory at night markets and antique shops. Each time a purchase takes place, Dahlia, the store owner, will record the buyer's name and address, the details and price of the items purchased as well as the amount spent. Upon returning home, Dahlin will clean, research, provide inventory numbers and place a sale price for each inventory item. Dahlia buys price tags and exhibition supplies from businesses that operate night markets and antiques exhibitions. All purchases of inventory and cxhibition supplies are paid for using cash or chock from a bank account in the name of Dahlia Antiques Business. Cash received from customers is also deposited into the same bank account. Dahlia rents kiosks at antiques fairs three times a year. A deposit must be paid for the rental, while the balance of the rent must be paid at the beginning of the exhibition. Dahlia records the deposit and final payment, as well as the name and address of the exhibition organizer, in the same worksheet she records the purchase of inventory and supplies. Be required: a. Draw a REA (Resources, Events, Agents) diagram related to the purchase of inventory and supplies, kiosk rental, and payment of all items for the Dahlia Antique Business. b. Construct the tables to implement the above REA diagram into a related database. Specify the primary key, foreign key and other appropriate fields for each table. c. Assuming that the Purchase activity and the Cash Payment activity are 1: 1 related, discuss the effect of selecting a foreign key -placed schedule on the process of recording payments to suppliers