Changes between Version 24 and Version 25 of RelationalDesign

Timestamp:

02/09/22 14:26:53 (3 years ago)

Author:

183022

Comment:

--

RelationalDesign

@@ -15 +15 @@
 * Person (**__id_person__**, **name**,** surname**, address, town, **phone_num**)
 * Employee (**__id_person__***(Person), **id_library***(Library), **position**)
-* Member (**__id_person__***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**) 
+* Member (**__id_person__***(Person), **id_school***(!SchoolType), **id_membership***(!MembershipType), **id_library ***(Library), **birth**, **email**, **pass**) 
 * Library (**__id_library__**, **name**, **city**)
-* SchoolType (**__id_school__**,** school_type_name**)
-* MembershipType (**__id_membership__**, **mem_stype_name**)
-* PriceList (**__id_price__**, **id_membership***(MemberShipType), **price**)
+* !SchoolType (**__id_school__**,** school_type_name**)
+* !MembershipType (**__id_membership__**, **mem_stype_name**)
+* !PriceList (**__id_price__**, **id_membership***(!MemberShipType), **price**)
 * Genre (**__id_genre__**, **name**) 
 * Writer (**__id_writer__**, ** name**)
 * Review (**__id_review__**, **id_book***(Book), **rate**, **rent_num**)
 * Room: (**__id_room__**, **id_library***(Library), **places**, **free_places**)
-* OnlineDownload (**__id_onlineDown__**, **id_book***(Book), **id_person_member***(Member))
-* ReservationBook (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
+* !OnlineDownload (**__id_onlineDown__**, **id_book***(Book), **id_person_member***(Member))
+* !ReservationBook (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
 * Book: (**__id_book__**, **id_writer***(Writer), **id_library***(Library), **name**, **book_num**, **if_free**, **book_price**, **book_price_late**)
-* ReservationPlace (**__id_resRoom__**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**) 
-* Membership_of_SchoolType (**__id_membership__***(MembershipType), **id_school***(SchoolType))
+* !ReservationPlace (**__id_resRoom__**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**) 
+* Membership_of_SchoolType (**__id_membership__***(!MembershipType), **id_school***(!SchoolType))
 * Who_Wrote_Book: (**__id_book__***(Book), **id_writer***(Writer))