Релациска шема (со мапирачка трансформација)

Ознаки

• Примарните клучеви се означени со bold и underline
• Надворешните клучеви се означени со *
• Задолжителни атрибути, односно not null со bold

Табели

• Address (AddressId, Street, City, PostCode, PhoneNumber, StreetNumber)
• WineType (WineTypeId, WineTypeName, WineTypeDescription, WineTypeRegion)
• Wine (WineId, !WineTypeID*(WineType), WineName, BasePrice, YearProduced)
• CustomerType (CustomerTypeId, CustomerTypeName, CustomerTypeDescription)
• Customer (CustomerId, CustomerTypeId*(CustomerType), AddressId*(Address), CustomerName, CustomerEmail)
• VehicleType (VehicleTypeId, VehicleTypeName)
• Vehicle (VehicleId, VehicleTypeId*(VehicleType), Make, Model, Registration, Capacity)
• ExpenseType (ExpenseTypeId, ExpenseTypeName, ExpenseTypeDescription)
• Employee (EmployeeId, EmployeeName, EmployeeSurname)
• Warehouse (WarehouseId, AddressId*(Address), WarehouseName)
• Shipment (ShipmentId, EmployeeId*(Employee), PaymentId*(Payment), VehicleId*(Vehicle), ShipmentDate)
• Payment (PaymentId, PaymentStatus)
• Load (LoadId, ShipmentId*(Shipment),CustomerId*(Customer), WineId*(Wine), Quantity, BasePrice, AgreedPrice)

DDL скрипта за бришење на табелите и креирање на табелите

V1_Init_DB.sql​

DML скрипта за полнење на табелите со податоци

V1_Polnenje_DB.sql​

Релациски дијаграм изваден од DBeaver