21
Owner
Property_for_Rent Owner , .
. 16 Customer_Rental , . . 14 , , 1H- -, :
Customer (Customer_.No, CName)
Rental (Customer_No. Property.No, RentStart, RentFinish)
Property for Rent (Property_No, PAddress, Rent, Owner_No)
Owner (Owner_No. OName)
Customer Rental, . 16, Customer, Rental, Property_for_Rent Owner. . , Owner_No Owner , , Property for Rent . Ovner_No, , Property_for_Rent Owner , .
. 14. 1- Customer Rental
Customer_No Customer Rental. , Rental Customer_No , . , Property_No Property_for Rent Rental , .
, Customer_Rental . , (nonloss) ( (nonadditive)) . .
Customer, Rental, Property_for_Rent Owner, , . 2225.
22
Customer
23
Rental
24
Property for Rent
25
Owner
. () , , . .
|
|
, .
, . , , .
3 , > 3-, , . - , . , 3, - 3-, 3- -.
, Customer, Rental, Property for Rent Owner (. . 2225). Customer, Property_for_Rent Owner -, , . , Rental (Customer No, Property No), (Customer No, RentStart) (Property_No, RentStart) :
fd1 Customer_No, Property No > RentStart, RentFinish
fd5* Customer_Mo, RentStart >Property_No, RentFinish
fd6* Property No, RentStart > Custoroer No, RentFinish
Rental , Rental . , :
( ) ;
, .. , , .
, , . Client Interview, . , , . . , . : (Client No, Interview Date), (Staff No, Interview Date, Interview Time) (Room No, Interview Date, Interview Time). , Client Interview , , .. Interview Date. (Client No, Interview Date). . 26 :
Client_Interview (Client_No. Interview.Date. Interview_Time, Staff_No, Room No)
26