Changes between Version 8 and Version 9 of RelationalDesign


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

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v8 v9  
    77* * - 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)
    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))
     9__underline__
     10**bold**
     11* Faculty(**__FacultyID__,CityName*(City),Fname**)
     12* Building(**__BuildingID__,CityName*(City),Building_Adress**)
     13* City(**__CityName__**)
     14* Apartment(**__ApartmentID__, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size**)
     15* ApartmentAgreement(**__AgreementID__, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent**)
     16* User(**__UserID__,Name,Surname,Password,Phone_Number**,City_of_Residency)
     17* Post(**__PID__, CityName*(City), Num_Roomates, Price, Date_Posted**, Description)
     18* Apartment_photos(**__PID,Apartment_photos__**)
     19* Admin(**__UserID*(User)__, Role**)
     20* Owner(**__UserID*(User)__**)
     21* Student(**__UserID*(User)__,FacultyID*(Faculty)**,Age,Gender)
     22* StudentPost(**__PID*(Post)__,UserID*(Student)**)
     23* OwnerPost(**__PID*(Post)__, ApartmentID*(Apartment),UserID(Owner)**,Apartment_photos)
     24* Moderates_Posts_For(**__CityName*(City),UserID*(Admin)__**)
     25* Student_Signs(**__UserID*(Student),AgreementID*(Agreement)__**)
    2426