Changes between Version 19 and Version 20 of RelationalDesign

Timestamp:

02/08/22 20:18:30 (3 years ago)

Author:

193047

Comment:

--

RelationalDesign

@@ -13 +13 @@
 ----
 
-* 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**) 
-* Library(**__id_library__**, **name**, **city**)
-* 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**)
-* 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))
-* Who_Wrote_Book(**__id_book__***(Book), **id_writer***(Writer))
+* 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**) 
+* Library: (**__id_library__**, **name**, **city**)
+* 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**)
+* 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))
+* Who_Wrote_Book: (**__id_book__***(Book), **id_writer***(Writer))
 
 
@@ -39 +39 @@
 == DML скрипта за полнење на табела со податоци  ==
 
-[attachment:polnenje.2.sqll]
+[attachment:polnenje.2.sql]]