Changes between Version 2 and Version 3 of RelationalDesign

Timestamp:

12/20/22 21:20:47 (3 years ago)

Author:

201087

Comment:

--

RelationalDesign

@@ -1 +1 @@
 = Логички и физички дизајн
+
+==Релациска шема
+
+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))
+