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

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

* BOLD=not null
* Underline = Primary Key
* * - takes from
----

* Faculty(**__FacultyID__,CityID*(City),Fname**)
* Building(**__BuildingID__,CityID*(City),Building_Adress**)
* City(**__CityID__**,CityName)
* Apartment(**__ApartmentID__, BuildingID*(Building),UserID*(Owner),Apartment_FloorAndRoomNumber,Size**)
* ApartmentAgreement(**__AgreementID__, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent**)
* User(**__UserID__,Name,Surname,Password,Phone_Number**,City_of_Residency)
* Post(**__PID__, CityID*(City), Num_Roomates, Price, Date_Posted**, Description)
* Apartment_photos(**__PostID*(OwnerPost),Apartment_photos__**)
* Admin(**__UserID*(User)__, Role**)
* Owner(**__UserID*(User)__**)
* Student(**__UserID*(User)__,FacultyID*(Faculty)**,Age,Gender)
* StudentPost(**__PID*(Post)__,UserID*(Student)**)
* OwnerPost(**__PID*(Post)__, ApartmentID*(Apartment),UserID(Owner)**)
* Moderates_Posts_For(**__CityID*(City),UserID*(Admin)__**)
* Student_Signs(**__UserID*(Student),AgreementID*(Agreement)__**)

== DDL скрипта за бришење на табелите и креирање на табелите
[attachment:kreiranjenew.sql kreiranjenew.sql]

== DML скрипта за полнење на табелите со податоци
[attachment:vnesuvanjenew.sql vnesuvanjenew.sql]

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

[[Image(Diagram.JPG)]]