Changes between Version 5 and Version 6 of RelationalDesign


Ignore:
Timestamp:
12/20/22 21:22:10 (2 years ago)
Author:
201087
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v5 v6  
    55*BOLD=not null
    66*Underline = Primary Key
    7 ** - takes from
     7* * - takes from
    88
    9 *Faculty(FacultyID,CityName*(City),Fname)
    10 *Building(BuildingID,CityName*(City),Building_Adress)
    11 *City(CityName)
    12 *Apartment(ApartmentID, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size)
    13 *ApartmentAgreement(AgreementID, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent)
    14 *User(UserID,Name,Surname,Password,Phone_Number,City_of_Residency)
    15 *Post(PID, CityName*(City), Num_Roomates, Price, Date_Posted, Description)
    16 *Apartment_photos(PID,Apartment_photos)
    17 *Admin(UserID*(User), Role)
    18 *Owner(UserID*(User))
    19 *Student(UserID*(User),FacultyID*(Faculty),Age,Gender)
     9* Faculty(FacultyID,CityName*(City),Fname)
     10* Building(BuildingID,CityName*(City),Building_Adress)
     11* City(CityName)
     12* Apartment(ApartmentID, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size)
     13* ApartmentAgreement(AgreementID, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent)
     14* User(UserID,Name,Surname,Password,Phone_Number,City_of_Residency)
     15* Post(PID, CityName*(City), Num_Roomates, Price, Date_Posted, Description)
     16* Apartment_photos(PID,Apartment_photos)
     17* Admin(UserID*(User), Role)
     18* Owner(UserID*(User))
     19* Student(UserID*(User),FacultyID*(Faculty),Age,Gender)
     20* StudentPost(PID*(Post),UserID*(Student))
     21* OwnerPost(PID*(Post), ApartmentID*(Apartment),UserID(Owner),Apartment_photos)
     22* Moderates_Posts_For(CityName*(City),UserID*(Admin))
     23* Student_Signs(UserID*(Student),AgreementID*(Agreement))
    2024
    21 StudentPost(PID*(Post),UserID*(Student))
    22 
    23 OwnerPost(PID*(Post), ApartmentID*(Apartment),UserID(Owner),Apartment_photos)
    24 
    25 Moderates_Posts_For(CityName*(City),UserID*(Admin))
    26 
    27 Student_Signs(UserID*(Student),AgreementID*(Agreement))
    28