Changes between Version 17 and Version 18 of RelationalDesign


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

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v17 v18  
    33== Релациска шема (со мапирачка трансформација) ==
    44
    5 ''Регуларни ентитети:'' Person,  Employee, Member, SchoolType, MemberShipType, Price, Library, Room, Genre, Review, Writer \\
    6 ''Слаби ентитети:'' OnlineDownload, ReservationBook, Book, ReservationPlace \\
     5''Регуларни ентитети:'' : Person, SchoolType, MemberShipType, PriceList, Employee, Member, Library, ReservationBook, OnlineDowlnoad,Room, reservationPlace, Book, Genre, Review, Writer \\
     6 
    77
    88* Примарни клучеви: underline and bold \\
     
    1717* Member (**__id_person__***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**)
    1818* 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**)
     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**)
    2424* Review (**__id_review__**, **id_book***(Book), **rate**, **rent_num**)
    2525* Room (**__id_room__**, **id_library***(Library), **places**, **free_places**)