Changes between Initial Version and Version 1 of RelationalDesign

Timestamp:

02/01/22 03:01:55 (3 years ago)

Author:

193047

Comment:

--

RelationalDesign

@@ +1 @@
+''Релациска шема (со мапирачка трансформација)''
+----
+
+
+{{{
+
+Регуларни ентитети: Person,  Employee, Member, SchoolType, MemberShipType, Price, Library, Room, Genre, Review, Writer
+Слаби ентитети: OnlineDownload, ReservationBook, Book, ReservationPlace 
+
+Примарни клучеви: underline and bold
+Надворешни клучеви*: bold, со ознака * и до нив стои во заграда на која табела покажуваат
+Not null атрибути: bold
+}}}
+
+
+----
+
+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**, **id_membership***(MemberShipType), **primary**,** high_school**, **other**)
+MembershipType (**id_membership**, **id_school***(SchoolType), **month**, **year**)
+Price (**id_price**, **id_membership***(MemberShipType), **month_price**,** year_price**, **primary_price**, **highSchool_price**)
+Genre (**id_genre**, **id_book***(Book), **name**) 
+Writer (**id_writer**, **id_book***(Book),** 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))
+
+
+----
+
+**DDL скрипта за креирање и бришење на табелите**''''
+----
+
+