Design an E-R diagram to represent the information needed in the scenario described by the prompt at the end of the assignment.
Assignment may be drawn on paper and handed in or turned in electronically as Dia files, pdfs, or image files. Do not submit Visio or Draw files as I do not have a way to read them. Do not submit Word or Powerpoint files because the drawings often mess up cross-platform. You may use those programs, but please export to pdf or image files (jpeg, bmp, png, gif).
A factory is trying to keep track of its machinery and supplies. They would like you to design a database which will help them to do this. The factory produces several different items. Each item has a type, a color, and they have a certain quantity of that item which they have already produced. They have a several different machines. Each machine produces one item from a set of raw materials. They want to keep track of which machines use which raw materials and produce which items, how much of each different type of raw material they have, and how many of each item they have produced. In addition, they would also like to know how old each of their machines are and when the last time each machine had a breakdown was.
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services