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

---

Регуларни ентитети: 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 скрипта за креирање и бришење на табелите'

---

https://develop.finki.ukim.mk/projects/VintageLibrary/attachment/wiki/RelationalDesign/kreiranje.sql

---

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

---

https://develop.finki.ukim.mk/projects/VintageLibrary/attachment/wiki/RelationalDesign/polnenje.sql

---

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

---