= ''Логички и физички дизајн'' =

== Релациска шема (со мапирачка трансформација) ==

''Регуларни ентитети:'' : Person, !SchoolType, !MemberShipType, !PriceList, Employee, Member, Library, !ReservationBook, !OnlineDowlnoad,Room, !ReservationPlace, Book, Genre, Review, Writer \\
 

* Примарни клучеви: underline and bold \\
* Надворешни клучеви: bold, со ознака * и до нив стои во заграда на која табела покажуваат \\
* Not null атрибути: bold \\
* Останати атрибути: без ознака \\

----

* Person (**__id_person__**, **name**,** surname**, address, town, **phone_num**, **birth**, **email**, **pass**)
* Employee (**__id_person__***(Person), **id_library***(Library), **position**)
* Member (**__id_person__***(Person), **id_school***(!SchoolType), **id_membership***(!MembershipType), **id_library ***(Library_DB), **isPayedMembership**, **isPayedBook**) 
* Library_DB (**__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), **downloaded**)
* !ReservationBook (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**, **isReservedBook**)
* 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),**coming_date**, **comingTime**, **leavingTime**) 
* Membership_of_SchoolType (**__id_membership__***(!MembershipType), **id_school***(!SchoolType))
* Who_Wrote_Book: (**__id_book__***(Book), **id_writer***(Writer))


== DDL скрипта за креирање и бришење на табелите ==

[attachment:kreiranje.sql]


== DML скрипта за полнење на табела со податоци  ==

[attachment:polnenje.sql]


== Релациски дијаграм изваден од DBeaver ==

[[Image("vintageLibrary_ER Diagram.png")]]