Релациска шема

Customer

• CustomerID (PK)
• CustomerName
• CustomerSurName
• Email
• Address
• CustomerContact
• Password

Employee

• EmployeeID (PK)
• EmployeeName
• EmployeeSurName
• Position
• Department
• Email
• Password

Product

• ProductID (PK)
• Model
• Price
• LicensePlate
• Status

Truck / Trailer

• Truck: ProductID (FK), HP
• Trailer: ProductID (FK), Capacity

Procurement

• TransactionID (PK)
• EmployeeID (FK)
• CustomerID (FK)
• ProductID (FK)
• ProcurementDate
• Quantity

T_Type

• TransactionID (PK, FK)
• Type (Rent/Buy)
• Duration (ако е Rent)
• MonthlyPay (ако е Rent)
• TotalPrice (ако е Buy)

CustomerFeedback

• FeedbackID (PK)
• TransactionID (FK)
• CustomerID (FK)
• ProductID (FK)
• Rating (1-5)
• Comment
• FeedbackDate

Maintenance

• MainID (PK)
• EmployeeID (FK)
• ProductID (FK)
• MainDate

Views

• CustomerID (PK, FK)
• ProductID (PK, FK)

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

V2__init_db.txt

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

V1__init_db.txt

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