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

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

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

*Faculty(FacultyID,CityName*(City),Fname) *Building(BuildingID,CityName*(City),Building_Adress) *City(CityName) *Apartment(ApartmentID, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size) *ApartmentAgreement(AgreementID, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent) *User(UserID,Name,Surname,Password,Phone_Number,City_of_Residency) *Post(PID, CityName*(City), Num_Roomates, Price, Date_Posted, Description) *Apartment_photos(PID,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),Apartment_photos)

Moderates_Posts_For(CityName*(City),UserID*(Admin))

Student_Signs(UserID*(Student),AgreementID*(Agreement))