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)

I solved the problem (the picture), but I know

ID 1 1 Phone has Battery n n n Type Other parts is manufactured by Purchased from Is_stored in m ID 1 manufacturer ID Supplier IS-A IS-A m City domestic Warehouse international Internal manufacturer External supplier capacity Transports by Transports by ID Location truck ID Company name transport capacity Expected travel time IS-A plane boat Past_total flying hours Home port

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!