Exercise Ian's place sells pet supplies to dog and cat owners. To sell its products, the marketing department requires sales personnel to call on the pet store retailers within their assigned geographic territories. Salespeople have an application on their mobile phones that allows them to record sales orders and send these sales orders directly to the company network for updating the company's sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are "net 30 ." when the billing department receives a payment, the billing clerk credits the customer's account and records the cash received. Requirements: ER diagram is provided below - Identify the database tables, and define attributes for each table. Exercise Ian's place sells pet supplies to dog and cat owners. To sell its products, the marketing department requires sales personnel to call on the pet store retailers within their assigned geographic territories. Salespeople have an application on their mobile phones that allows them to record sales orders and send these sales orders directly to the company network for updating the company's sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are "net 30 ." when the billing department receives a payment, the billing clerk credits the customer's account and records the cash received. Requirements: ER diagram is provided below - Identify the database tables, and define attributes for each table