Логички и физички дизајн

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

• Примарен клуч: underline
• Надворешен клуч: underline и *
• Not null: bold

---

User ( _UserID_, Name, Surname, Email, Password, Phone number, Date joined )

Flight ( _FlightID_, Flight number, _Departure Airport*_, _Arrival Airport*_, Departure time, Arrival time, Duration, Price, Available seats )

Departure Airport референцира кон Airport.
Arrival Airport референцира кон Airport.

Booking ( _BookindID_, _UserID*_, _FlightID*_, Booking date, Payment status, Total cost, Seat number )

UserID референцира кон User.
FlightID референцира кон Flight.

Destination ( _DestinationID_, Name, Country, Description, Popular Attraction, Best time to visit )

Review ( _ReviewID_, _UserID*_, _TargetID*_, Review comment, Rating, Date )

UserID референцира кон User.
TargetID референцира кон Flight, Destination, Airport, Booking.

Airport ( _AirportID_, Name, _City*_, Country, Code )

City рефенцира кон Destination.

Payment ( _PaymentID_, _BookingID*_, _UserID*_, Payment method, Amount, Transaction date, Payment Status )

BookingID референцира кон Booking.
UserID референцира кон User.

Notification ( _NotificationID_, _UserID*_, Message, Type, Date Sent )

UserID референцира кон User.

Wishlist ( _WishlistID_, _UserID*_, _TargetID*_, Date added )

UserID референцира кон User.
TargetID референцира кон Flight, Destination.

Administrator ( _AdminID_, Email )

Support Ticket ( _TicketID_, _UserID*_, Subject, Description, Status, Date created, Date resolved, Assigned to )

UserID референцира кон User.

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

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

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