Anexo - NorthWind
Para mayor comodidad de uso se adjunta la base de datos Northwind adaptada para los gestores de base de datos más populares.
Código extraído de Wikiversity con licencia Creative Commons BY-SA 4.0
Diagrama Entidad-Estado (ER):
erDiagram
Customers ||--|{ Orders : CustomerID
Employees ||--|{ Orders : EmployeeID
Shippers ||--|{ Orders : ShipperID
Orders ||--|{ OrderDetails : OrderID
OrderDetails }|--|| Products: ProductID
Products }|--|| Categories: CategoryID
Products }|--|| Suppliers: SupplierID
Orders{
INT OrderID
INT CustomerID
INT EmployeeID
DATETIME OrderDate
INT ShipperID
}
OrderDetails{
INT OrderDetailID
INT OrderID
INT ProductID
INT Quantity
}
Products{
INT ProductID
TEXT ProductName
INT SupplierID
INT CategoryID
TEXT Unit
NUMERIC Price
}
Employees{
INT EmployeeID
TEXT LastName
TEXT FirstName
DATE BirthDate
TEXT Photo
TEXT Notes
}
Categories{
INT CategoryID
TEXT CategoryName
TEXT Description
}
Customers{
INT CustomerID
TEXT CustomerName
TEXT ContactName
TEXT Address
TEXT City
TEXT PostalCode
TEXT Country
}
Shippers{
INT ShipperID
TEXT ShipperName
TEXT Phone
}
Suppliers{
INT SupplierID
TEXT SupplierName
TEXT ContactName
TEXT Address
TEXT City
TEXT PostalCode
TEXT Country
TEXT Phone
}