The Plano Art Gallery (TPAG) stocks and sells high quality artwork for home and office use. Its sales representatives (Consultants) use a specified form format to take orders from its customers. Customer Account Numbers on the form are unique. A Customer has only one Billing Address. The Billing Address is filled in the form when a new customer account is created or when there is a change of address for an existing customer. The Delivery Address is the place where the artwork is to be delivered. The Delivery Address is filled in the Order Form when the customer decides to use TPAG's delivery service. All artwork in one order is delivered to the same Delivery Address. TPAG offers free delivery service for orders with a total value exceeding $10,000. For smaller orders, TPAG charges a nominal fee of $500. The customer is not charged the nominal delivery fee if s/ he declines use of TPAG's delivery service for orders less than $10,000. TPAG owns several special Vehicles for delivering Customer Orders. Each vehicle has a Vehicle Number, License Plate Number, License Expiration Date, and Inspection Expiration Date. Each Vehicle is assigned to a Driver, who is an Employee of TPAG. Every Friday of the week the TPAG Operations Manager plans the following week's Delivery. Orders are broken down into delivery units called Shipments so that each Shipment may fit into one Vehicle. A large Order that cannot fit into a single Vehicle may be broken down into multiple Shipments, whereas a small order may be delivered as a single Shipment. Shipments are assigned to Vehicles that are available for the next week's delivery service. A Vehicle may carry more than one Shipment. All items included in a Shipment are delivered by one Vehicle. Each type of Artwork is identified by an Item Code. The Price of each Artwork Type and the quantity in stock are also tracked. TPAG employs several Employees. Each Employee has a Social Security Number, Name, Address, and Phone. A Driver, a type of Employee, has a Driver's License Number and License Expiration Date, in addition to other Employee information. Consultants are also a type of Employee. All Employees are Salaried. Consultants earn Commission in addition to Salaries. TPAG wants to create an Information System to manage its operations. TPAG's management team has outsourced this project to your team.