Class Diagram

Class Diagram of Gestor DD

In this Class Diagram, we can see the different tables, attributes, and relations.

Diagram

Tables

The tables that makes up the diagram are detailed below:

• Administrator
  • CIF: String
  • Name: String
  • Email: String
• Warehouse
  • Code: String
  • Product code: Product
  • Maximum quantity: int
  • Current quantity: int
• Product
  • Code: String
  • Warehouse code: Warehouse
  • Name: String
  • Description: String
  • Available quantity: int
  • Cost price: Double
  • Sales price: Double
  • Supplier Code: Supplier
• Supplier
  • CIF: String
  • Name: String
  • Address: String
  • Telephone number: String
• Order
  • Code: String
  • Product code: Product
  • Cost price : Product
  • Supplier CIF: Supplier
  • Order Date: String
  • Quantity: int
  • Total: Double
  • Paid: boolean

Relations

On the other hand, the relations between the tables are described below:

• Between administrator and warehouse we find an association relationship, an administrator belongs / manages a single warehouse.
• In the same way, we have between administrator and order another association relationship, an administrator can make one or many orders.
• Between warehouse and product there is a composition relationship, because a warehouse is composed of products, and if these disappear, the warehouse will disappear.
• Between product and supplier we find another association relationship; in this case, a product is provided by one or more suppliers.
• Finally, between product and order we find an association relationship, a product can be contained in one or many orders.