Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The figure below is a relational database schema for a Library database. Map the relational schema in the figure into an ER schema. This is

The figure below is a relational database schema for a Library database. Map the relational schema in the figure into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make.

image text in transcribed

BOOK \begin{tabular}{|l|l|l|} \hline Book_id & Title & Publisher_name \\ \hline \end{tabular} M44 BOOK_AUTHORS \begin{tabular}{|l|l|} \hline Book_id & Author_name \\ \hline \end{tabular} PUBLISHER \begin{tabular}{|c|c|c|} \hline Name & Address & Phone \\ \hline 4 \end{tabular} BOOK_COPIES \begin{tabular}{|l|l|l|} \hline Book_id & Branch_id & No_of_copies \\ \hline \end{tabular} BOOK_LOANS \begin{tabular}{|l|l|l|l|l|} \hline Book_id & Branch_id & Card_no & Date_out & Due_date \\ \hline \end{tabular} LIBRARY_BRANCH \begin{tabular}{|l|l|l|} \hline Branch_id & Branch_name & Address \\ \hline \end{tabular} BORROWER \begin{tabular}{|l|l|l|l|} \hline Card_no & Name & Address & Phone \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions