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

**Customer**\\

- CustomerID (PK)
- CustomerName
- CustomerSurName
- Email
- Address
- CustomerContact

**Employee**
- EmployeeID (PK)
- EmployeeName
- EmployeeSurName
- Position
- Department

**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)
- 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 скрипта за бришење на табелите и креирање на табелите