Changes between Version 18 and Version 19 of RelationalDesign


Ignore:
Timestamp:
02/08/22 20:16:10 (3 years ago)
Author:
193047
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v18 v19  
    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__**,** school_type_name**)
    20 * MembershipType (**__id_membership__**, **mem_stype_name**)
    21 * PriceList (**__id_price__**, **id_membership***(MemberShipType), **price**)
    22 * Genre (**__id_genre__**, **name**)
    23 * Writer (**__id_writer__**, ** 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**)
     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__**,** school_type_name**)
     20* MembershipType(**__id_membership__**, **mem_stype_name**)
     21* PriceList(**__id_price__**, **id_membership***(MemberShipType), **price**)
     22* Genre(**__id_genre__**, **name**)
     23* Writer(**__id_writer__**, ** 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**)
    3030* Membership_of_SchoolType(**__id_membership__***(MembershipType), **id_school***(SchoolType))
    31 * Who_Wrote_Book (**__id_book__***(Book), **id_writer***(Writer))
     31* Who_Wrote_Book(**__id_book__***(Book), **id_writer***(Writer))
    3232
    3333
    3434== DDL скрипта за креирање и бришење на табелите ==
    3535
    36 [attachment:kreiranje.sql]]
     36[attachment:kreiranje.2.sql]]
    3737
    3838
    3939== DML скрипта за полнење на табела со податоци  ==
    4040
    41 [attachment:polnenje.sql]
     41[attachment:polnenje.2.sqll]
    4242
    4343
    4444== Релациски дијаграм изваден од DBeaver ==
    4545
    46 [[Image(vintageLibrary_diagram.png)]]
     46[[Image(er_dijagram.png)]]
    4747
    4848