Ans both task 1 and 2

Task 1: Open with Bikes-R-Us sells standard and customized bicycles over the Web. The company buys components from various vendors in its supply chain and assembles the components into bicycles. Standard bicycles are produced to inventory, while custom bicycles are only made to order. Bikes-R-Us wants to develop a database for certain parts of its business. The company needs an E-R diagram to use as a basis for a database design. Develop the E-R diagram from the following statements: (a) Bikes-R-Us will keep track of materials. The materials are of two kinds: components and bikes. (b) Materials are related to each other by their bill of material structure. Each bike requires M components. Each component may go into 1 or more bikes. (c) Components are provided by vendors. A component must be ordered from one or more vendors. A vendor must provide one or more components. (d) Inventoried material is known as a material lot. A lot is a grouping of the same material either supplied by the same vendor (components) on a particular shipment or produced in the same production run (bikes). (e) A material lot may be provided by a vendor. When a material lot is provided by a vendor, it is associated with one and only one vendor. A vendor may have provided zero, one, or many material lots. Some material lots (e.g., bikes) are not provided by vendors. (f) A warehouse location is a place where a material lot is stored. A material lot may be stored in more than one location. A warehouse location may have zero, one, or many material lots. (g) A material lot may be produced on an assembly line. Each assembly line is associated with one or more material lots. Some material lots (e.g., components) are not produced on an assembly line. (h) An assembly line is composed of stations. Each assembly line has one or more stations, and each station is associated with exactly one assembly line. (i) An assembly process plan describes the steps by which a bike is assembled. Each bike has one assembly process plan, but the same assembly process plan may be used by more than one bike. () Each assembly process plan has several steps. A step is associated with one process plan. (k) Each process plan step is associated with a station, where that step is executed. Each step is associated with one and only one station. However, a station may be used in many process plan steps. Task 2: Translate your ER diagram into a relational schema. Select approaches that yield the fewest number of relations, merge relations where appropriate. Specify the key of each relation in your schema