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

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

[https://develop.finki.ukim.mk/projects/LZDT1324/attachment/wiki/SQL%20%26%20DDL/Truck%20Simulator%20DDL.2.txt V2__init_db.txt] 

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

[https://develop.finki.ukim.mk/projects/LZDT1324/attachment/wiki/SQL%20%26%20DDL/V1.1__data_init.txt.2.txt V1__init_db.txt] 

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

[[Image(DBEAVER.png)]]\\