Релациско мапирање - парцијална трансформација

Ознаки

• Примарните клучеви се означени со задебелени и подвлечени букви
  

• Задолжителните атрибути се означени со задебелени букви
  

• Надворешните клучеви се означени со *

Табели

• DESTINATION (idDest, locationName, locationDesc, typesOfPlaces, recommendedSeason, averageTemp, geoLocation, country, popularity, name, description)
• USER (idUser, name, lastName, eMail, phoneNumber, birthDate)
• STANDARD (idUser, name, lastName, eMail, phoneNumber, birthDate)
• PREMIUM (idUser, name, lastName, eMail, phoneNumber, birthDate, dateCreated, discount)
• REVIEW (idReview, username, quality, comment, reviewDate, voteCount, idDest* (DESTINATION), idReservation* (RESERVATION))
• METEOROLOGICAL CONDITION (idMeteo, currentTemp, weatherCondition, warnings, humidity, wind, month, idDest* (DESTINATION))
• PACKAGE (idPackage, packageName, price, start, end, idDest* (DESTINATION))
• ACTIVITY (idActivity, activityName, information, category, amount, idDest* (DESTINATION))
• RESERVATION (idReservation, timePoint, premiumDiscountApplied, discountАmount, totalPrice, idUser* (USER), idMeteo* (METEOROLOGICAL CONDITION))
• PREFERENCE (idPreference, typePreference, priority, idUser* (USER))
• EVENT (idEvent, eventName, eventType, startDate, endDate, deatils, idDest* (DESTINATION))
• TAG (idTag, tagTag)
• Destination_tag (idTag* (TAG), idDest* (DESTINATION))
• Activitiy_package (idActivity* (ACTIVITY), idPackage* (PACKAGE))
• Package_reservation (idPackage* (PACKAGE), idReservation* (RESERVATION))
• Activity_reservation (idActivity* (ACTIVITY), idReservation* (RESERVATION))
• Destination_user (idDest* (DESTINATION), idUser* (USER))

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

DDL скрипта

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

DML скрипта

Историјат