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

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

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))