Changes between Version 4 and Version 5 of RelationalDesign


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

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v4 v5  
    33== Релациска шема
    44
    5 BOLD=not null
    6 Underline = Primary Key
    7 * - takes from
     5*BOLD=not null
     6*Underline = Primary Key
     7** - takes from
    88
    9 Faculty(FacultyID,CityName*(City),Fname)
    10 
    11 Building(BuildingID,CityName*(City),Building_Adress)
    12 
    13 City(CityName)
    14 
    15 Apartment(ApartmentID, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size)
    16 
    17 ApartmentAgreement(AgreementID, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent)
    18 
    19 User(UserID,Name,Surname,Password,Phone_Number,City_of_Residency)
    20 
    21 Post(PID, CityName*(City), Num_Roomates, Price, Date_Posted, Description)
    22 
    23 Apartment_photos(PID,Apartment_photos)
    24 
    25 Admin(UserID*(User), Role)
    26 
    27 Owner(UserID*(User))
    28 
    29 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)
    3020
    3121StudentPost(PID*(Post),UserID*(Student))