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

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

Truck Simulator DDL Final

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

DML Final

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