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

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

[https://develop.finki.ukim.mk/projects/LZDT1324/attachment/wiki/CamelCase/Truck%20Simulator%20DDL.txt V1__init_db.txt] 

[https://develop.finki.ukim.mk/projects/LZDT1324/attachment/wiki/CamelCase/V1.1__data_init.txt.txt V1__init_db.txt] 

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