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

**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 **
- ProductID (PK, FK → Product)
- HP

** Trailer **
- ProductID (PK, FK → Product)
- Capacity

**Procurement**\\
- TransactionID (PK)
- EmployeeID (FK → Employee)
- CustomerID (FK → Customer)
- ProductID (FK → Product)
- ProcurementDate
- Quantity
- Status
- Notified
- GroupID

**T_Type**\\
- TransactionID (PK, FK → Procurement)
- 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 → Employee)
- ProductID (FK → Product)
- MainDate
- Description
- Cost
- Status
- StartTime
- EndTime

**Views**\\
- CustomerID (PK, FK → Customer)
- ProductID (PK, FK → Product)

* Wallet **\\

- WalletID (PK)
- CustomerID (FK → Customer)
- Balance
- CardNumber
- ExpiryDate
- CVV
- CardHolderName



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

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

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

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

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

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