Changes between Version 15 and Version 16 of RelationalDesign


Ignore:
Timestamp:
02/01/22 10:51:34 (3 years ago)
Author:
183022
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v15 v16  
    1313----
    1414
    15 * Person (__**id_person**__, **name**,** surname**, address, town, **phone_num**)
    16 * Employee (**id_person***(Person), **id_library***(Library), **position**)
    17 * Member (**id_person***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**)
    18 * Library (**id_library**, **name**, **city**)
    19 * SchoolType (**id_school**, **id_membership***(MemberShipType), **primary**,** high_school**, **other**)
    20 * MembershipType (**id_membership**, **id_school***(SchoolType), **month**, **year**)
    21 * Price (**id_price**, **id_membership***(MemberShipType), **month_price**,** year_price**, **primary_price**, **highSchool_price**)
    22 * Genre (**id_genre**, **id_book***(Book), **name**)
    23 * Writer (**id_writer**, **id_book***(Book),** name**)
    24 * Review (**id_review**, **id_book***(Book), **rate**, **rent_num**)
    25 * Room (**id_room**, **id_library***(Library), **places**, **free_places**)
    26 * OnlineDownload (**id_onlineDown**, **id_book***(Book), **id_person_member***(Member)),
    27 * ReservationBook (**id_resBook**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
    28 * Book (**id_book**, **id_writer***(Writer), **id_library***(Library), **name**, **book_num**, **if_free**, **book_price**, **book_price_late**)
    29 * ReservationPlace (**id_resRoom**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**)
    30 * Membership_of_SchoolType(**id_membership***(MembershipType), **id_school***(SchoolType))
    31 * Who_Wrote_Book (**id_book***(Book), **id_writer***(Writer))
     15* Person (**__id_person__**, **name**,** surname**, address, town, **phone_num**)
     16* Employee (**__id_person__***(Person), **id_library***(Library), **position**)
     17* Member (**__id_person__***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**)
     18* Library (**__id_library__**, **name**, **city**)
     19* SchoolType (**__id_school__**, **id_membership***(MemberShipType), **primary**,** high_school**, **other**)
     20* MembershipType (**__id_membership__**, **id_school***(SchoolType), **month**, **year**)
     21* Price (**__id_price__**, **id_membership***(MemberShipType), **month_price**,** year_price**, **primary_price**, **highSchool_price**)
     22* Genre (**__id_genre__**, **id_book***(Book), **name**)
     23* Writer (**__id_writer__**, **id_book***(Book),** name**)
     24* Review (**__id_review__**, **id_book***(Book), **rate**, **rent_num**)
     25* Room (**__id_room__**, **id_library***(Library), **places**, **free_places**)
     26* OnlineDownload (**__id_onlineDown__**, **id_book***(Book), **id_person_member***(Member)),
     27* ReservationBook (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
     28* Book (**__id_book__**, **id_writer***(Writer), **id_library***(Library), **name**, **book_num**, **if_free**, **book_price**, **book_price_late**)
     29* ReservationPlace (**__id_resRoom__**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**)
     30* Membership_of_SchoolType(**__id_membership__***(MembershipType), **id_school***(SchoolType))
     31* Who_Wrote_Book (**__id_book__***(Book), **id_writer***(Writer))
    3232
    3333