123

Apuntes

• Subtopic: Database Schema Design The document "Buen Sabor" outlines a database schema design for a restaurant management system. The diagram provides a conceptual overview of the relationships between different entities such as "Mozo" (waiter), "Mesa" (table), "Cliente" (customer), "Articulo" (item), and "Pedido" (order). Each entity is associated with specific attributes and relationships, which are later translated into database tables. • Subtopic: Entity-Relationship Diagram The diagram includes the following entities and their attributes: - **Mozo**: Identified by `idmozo`, with attributes `nombre` (name) and `apellido` (surname). It is related to `nromesa` (table number). - **Mesa**: Identified by `nromesa`, with an attribute `capacidad` (capacity). - **Cliente**: Identified by `idcliente`, with an attribute `nombre` (name) and an optional `telefono` (phone number). - **Articulo**: Identified by `idarticulo`, with attributes `tipo` (type), `nombre` (name), and `precio` (price). - **Pedido**: Identified by `nropedido`, with attributes `nromesa` and `preciototal` (total price). The relationships between these entities are defined as follows: - **Atiende**: A relationship...