Customer Rental :
Customer Rental (Customer_No, Property_No, CName, PAddress, RentStart,RentFinish, Rent, Owner_No, OName).
Customer Rental , . , , . , Customer_Rental .
(2). , .. , . , , , 2. , 2, . , , (Rent) PG4. Customer Rental. , .
2 , , , .
1- 2- , Customer_Rental (. . 16). , - .
. . 13 ( fdl fd6) Customer_Rental (Customer_No, Property_No) . Customer Rental :
. 13. Customer_Rental
Customer_Rental . . , CName , , Customer_No ( . 13 fd2). , (PAddress, Rent, Owner_No, OName) , Property_No ( . 13 fd3). , (RentStart RentFinish) , .. Customer_No Property_No ( c . 13 fd1).
|
|
, (transitive dependence) ( . 13 fd4). , o 2. 3.
Customer Rental , . Customer Rental 2 , , , , , . Customer, Rental Property_Owner, . 1719 . , , , . ( ):
Customer (Customer_No. CName)
Rental (Customer_No, Property_No, RentStart, RentFinish)
Property_Owner (Property_No. PAddress, Rent, Owner_Mo, OMame)
17
Customer
18
Rental
19
Property_Owner
(3). 2- , 1-, . , (, Tony Shaw 093 ( Owner No)) erty_Owner. , . , . . .
, > > , , ( , , ).
, , :
> > .
> . , .
3 , , .
2- 3- . , - .
|
|
. , Customer, Rental Property_Owner.
Customer
fd2 Customer No > CName
Rental
fd1 Customer No, Property No > RentStart, RentFinish
fd5* Customer No, RentStart > Property_No, RentFinish
fd6* Property No, RentStart > Customer No, RentFinish
Property Owner
fd3 Property No > PAddress, Rent, Owner No, OName
fd4 Owner No > OName
Customer Rental . , Customer Rental , . ( , (fd) (*), ( .)
Property_Owner , OName, Owner_No ( fd4). , (OName) , (Owner_No). . 13.
Property_Owner Property_for Rent Owner, . 20 21 . :
Property_for_Rent (Property.No. PAddress, Rent, Owner_No)
Owner (Owner No. OName)
20