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

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

• Примарен клуч: 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 скрипта за бришење на табелите и креирање на табелите

ddlscript-create.sql​

ddlscript-delete.sql​

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

dmlscript-populate.sql​

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