Question: I solved the problem (the picture), but I know there are mistakes, and I need it to be fixed please. A phone manufacturer Colocho wants
I solved the problem (the picture), but I know there are mistakes, and I need it to be fixed please.
A phone manufacturer Colocho wants to develop a logistic management system (LMS) using an SQL database. Some of the main functionalities in the LMS are to track the transport of the phones to the warehouses and to manage the parts of the phone. You are appointed as the project manager of the development project and have to collaborate with software engineers. You are asked to formulate the data requirements using an ER diagram. Phone: Each phone has ID and type. Each phone has one battery. Battery Manufacturer: The battery can be manufactured either inside the factory or purchased from an external supplier. The database should store the ID of the manufacturer. The external manufacturer has company name and the internal manufacturer has location. A manufacturer can deliver many batteries but the batteries can only be delivered by one manufacturer. The rest of the phone parts are purchased from suppliers that are either domestic or international. The supplier has ID. All parts purchased from an international supplier are transported by plane or boat. Each plane has past total flying hours. Each boat has a home port where the maintenance take places. The transport mean has ID, capacity, and expected travel time. The domestic supplier transports the parts by truck and delivers them into the nearest warehouse. (Is not included in the ER diagram) The assembled phones are stored in a warehouse. The warehouse has capacity, ID, and city. Many phones can be store in different warehouses. Draw the ER diagram using drawing tool like power point, visio, etc.! The ER diagram has to include the following: a. Entities and their (key) attributes. b. The relationships, their attributes and cardinalities. c. IS-A (10 P)

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
