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

=== Ознаки ===
* Примарните клучеви се означени со **__задебелени и подвлечени букви__**\\

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

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

=== Табели ===
* DESTINATION (**__idDest__**, **locationName**, locationDesc, typesOfPlaces, recommendedSeason, averageTemp, geoLocation, country, popularity, importantLocations)    
* USER (**__idUser__**, **loginName**, **eMail**, phoneNumber, birthDate)    
* STANDARD (**__idUser__**, **loginName**, **eMail**, phoneNumber, birthDate) 
* PREMIUM (**__idUser__**, **loginName**, **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**, **duration**, **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 скрипта за бришење на табелите и креирање на табелите
[wiki:ddlScript​ DDL скрипта] 

== DML скрипта за полнење на табелите со податоци
[wiki:dmlScript​​ DML скрипта] 

== Историјат
[[Image(relaciski.png, align=center)]]