Draw and ER diagram and write a database design outline for the scenario above.

a dala mak EcoBus Corporation: EcoBus Corporation gas-fueled buses for various clients, including diagram and city, state, and count tran- of buses. which has a 7.3 c authoritie EcoBus currently has dozens of basic bus models, each of s. This database is concerned with the orderin sit ht, basic gross unique model number along with a length, width, height, ba phone weight, and list price. For each of the firm's customers, you wa number, and contact person name (assume that you do not wa tain a separate table for zip codes). multiple orders; for each order, you want to store the date of the order and for example, "NJ Transit"), address, city, state zip, code, pho Over time, customers may place the percentage discount negotiated from the list price of the order. Each order consists of one or more "production batches." A production batch consists of a number of buses that are all the same model and have option packages. Each production batch is identified by the serial nu of the first bus in the batch; the remaining buses in the production batch have consecutive serial numbers. Your system needs to know the number of buses in each batch, the model of bus, and which option packages apply to buses in the batch. same umber Options are sold only in option "packages," each consisting of one or more options. Each option package has a unique catalog number, a name (for example, "cold climate engine kit" or "bicycle storage"), a description and and a list price. Each individual option has a unique option code description. Some individual options are in more than one option package Design a database to store this information