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

1.1 Трансформација на множества ентитети

Customers(Embg, Email, Firstname, Lastname, Phonenumber, Address, Idnumber)

Vehicletypes(Id, Name)

Vehicles(VIN, Registrationnumber, Brandname, Fueltype, Transmissiontype, Numberdoors, Numberseats, Mileage, Vehicletypesid*) *reference from Vehicletypes(Id)

Bookings(Bookingid, CustomerEMBG*, Numberinstallments, Vehiclevin*, Status, Amount, Date) *reference from Vehicles(VIN)

Payments(Paymentid, Bookingid*, Totalamount, Date, Advance_amount) *reference from Bookings(Bookingid)

Managers(Id, Fromdate, Todate) *reference from Employees(Embg)

Employees(Embg, Managerid*, Email, Firstname, Lastname, Phonenumber, Address, Dateemployed)

Shifts(Id, Fromdate, Todate, Name)

1.2 Трансформација на множествата релации меѓу ентитети

Books – 1:N

Is_For – 1:N

Has_been_booked 1:N

Is_Of - 1:1

Reviews(Embg*, Bookingid*) *references from Employees *References from Bookings

Manages – 1:N

Works(Embg*, Id*) *references Employees *references Shifts

Линкови

Скрипта за креирање на табели ​

Скрипта за полнење на табели ​

Релациски дијаграм