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.
(j) 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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more