AUTHOR | My Assignment Tutor

AUTHORP * author id * author fname * author (nameNUMERIC (4) VARCHAR (50) VARCHAR (50)writesBD AUTHORPF • book_call_no PF • author idVARCHAR (20) NUMERIC (4)BD SUBJECTPF * subject_code PF * book_call_noNUM ERIC (4) VARCHAR (20)0 has 0BOOK DETAILhasis_rese Nedcall l_no * book_title * book classification * book no pages • book_pub_year book edition * pub_idVARCHAR (20) VARCHAR (100) CHAR (1) NUMERIC (4) Date VARCHAR (3) NUMERIC (4)hascoverspublishes BOOK COPY0RESERVEPF * PF P Fbranch code be id reserve_date_time_placed bor noNUMERIC (2) NUM ERIC (6) Date NUMERIC (6)QLreservesPF branch_code P be id bc_purchase_price ‘ bc reserve flag F* book cal l_noNUMERIC (2) NUMERIC (6) NUMERIC (7,2) CHAR (1) VARCHAR (20)BORROWERP bor_no NUMERIC (6) * bor_fname VARCHAR (59) • bor(name VARCHAR (50) * bor street VARCHAR (80) bor_suburb VARCHAR (50) * bor_postcode CHAR (4) F * branch_code NUMERIC (2)houseswSUBJECTP * subject_code NUMERIC (4) U * subject_details VARCHAR (80)PUBLISHERP Upub_id pub name pub_city pub state pub_countryNUMERIC (4) VARCHAR (50) VARCHAR (50) VARCHAR (50) VARCHAR (50)BRANCHborrowed fiborrowsLOANPF PF Pbranch code be id loan date time loan_due_date loan_actual_return_date bor noNUMERIC (2) NUMERIC (6) Date Date Date NUMERIC (6) 0- branch code * branch name * branch address * branch contact no * branch count_books • man_idNUMERIC (2) VARCHAR (50) VARCHAR (100) CHAR (10) NUMERIC (5) NUMERIC (2)managesMANAGERP * man id • man_fna me • man _l na me • man_contact_noNUMERIC (2) VARCHAR (50) VARCHAR (50) CHAR (10)

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Leave a Reply

Your email address will not be published. Required fields are marked *