Problem 1 (25%): You are asked to design a database for Kangaroo Package Shipping (KPS) company that satisfies the following requirements: a. KPS has several types of shipping service. Each type has a unique code, a rate, and a type of insurance. The rate is composite of a base rate for the first 20 ounces and an incremental rate for each additionl ounce after that b. KPS has many local offices. Each local office has a unique number, a name, an address, a manager, a telephone number, and the types of shipping service available. Not all types of shipping service are available in every office c. The database maintains records of customers. The record includes a unique customer's num- ber, name, address, telephone number. Some queries access the records by the last name of the customer. Some queries need to refer to city, state, and zip code in the address. d. The database keeps a record for each package. The record has a unique package number, a customer, a date, a type of service, the local office that accepts the package, and the name of the employee who processes the package e. Each package has several tracking records. The record has a sequence number that is unique for the package, the date of the record, the local office where the record is inserted, and the employee who inserts the record. Design the database using ER model. Show your design by an ER diagram