Map the ER diagram shown below into a relational schema. Indicate primary key and foreign key...

 

Transcribed Image Text:

Map the ER diagram shown below into a relational schema. Indicate primary key and foreign key for each relation Book_id No_of_Copies) Title Branch_id BOOK N OWN M Author_name LIBRARY BRANCH Branch_name Address N PUBLISHE_BY Date_out Due_date LOANS Name Card_no Address Phone PUBLISHER Name BORROWER Address Phone Map the ER diagram shown below into a relational schema. Indicate primary key and foreign key for each relation Book_id No_of_Copies) Title Branch_id BOOK N OWN M Author_name LIBRARY BRANCH Branch_name Address N PUBLISHE_BY Date_out Due_date LOANS Name Card_no Address Phone PUBLISHER Name BORROWER Address Phone