Hi, I'm studying databases and I'm having trouble solving the problem below. Could anyone help me identify the entities?

A transportation company called Carregaki is responsible for delivering packages from a set of warehouses to a group of stores belonging to a chain. Currently, there are six warehouses and 45 stores. A truck can carry multiple packages on each trip, identified by a trip number, and can unload at different stores. Each package is identified by a number and includes the order date, weight, destination, etc. The trucks have different capacities, either in terms of volume or weight they can carry. Carregaki currently owns 150 trucks, and each truck is capable of making three to four trips per week. The goal is to design a database, used by both companies, that maintains information about truck usage and package distribution, and that can help in defining the distribution schedules.

Apr 12, 2025 - 21:35

Hi, I'm studying databases and I'm having trouble solving the problem below. Could anyone help me identify the entities?

A transportation company called Carregaki is responsible for delivering packages from a set of warehouses to a group of stores belonging to a chain. Currently, there are six warehouses and 45 stores.

A truck can carry multiple packages on each trip, identified by a trip number, and can unload at different stores. Each package is identified by a number and includes the order date, weight, destination, etc.

The trucks have different capacities, either in terms of volume or weight they can carry. Carregaki currently owns 150 trucks, and each truck is capable of making three to four trips per week.

The goal is to design a database, used by both companies, that maintains information about truck usage and package distribution, and that can help in defining the distribution schedules.