Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am currently working on making an a public library database E/R diagram and was looking for input regarding whether this format is correct. Are

I am currently working on making an a public library database E/R diagram and was looking for input regarding whether this format is correct. Are the entities on the chart valid enough to be entities? is there anything I'm doing wrong and/or can fix about it? Explanation would be much appreciated.

image text in transcribed

ami MEMBER integer(10) U Member ID First Name Last Name Date of Brth a Email Address har(60 Telephone Number integer(10 HOME ADDRESS a Street Address varchar(30) A Apt. City a zip code EMPLOYEE Employee ID integer(10 U A First Name Last Name Job Position B Date of Brth Telephone Number integer(10) varchar(60) U Email Address Lbrarlan Assistant Directo Technician Specialist Coordinato Manager Uses Uses Uses MEMBER SERVICES H Item Reservation Return integer(10) U Canoel Membership integer(10 BILL SUMMARY Name of Fee Date of Fee integer(8) Amount Due decimal 2,9) Pad Total decimal(2,9) LIBRARIAN SERVICES Modify Book Information integer(10) Add New Book Remove Book LIBRARY ASSISTANT SERVICES Modify Account Block Membership integer(10) Charge tem Fee A Maintain Member Details integer(10 Reserves LITERATURE Format Type char(60) B Publisher a Release Date integer(8) A Availability status integer(10 integer(8) U ISSN integer(13) U ISBN B00 eB00 Aud Kob00 Magazne Joumal Pape Newspaper ComCS Science Fiction Fantasy ste Poet HE torical Drama HEtory Science Cookboo Bbgraphy Suspense Adventure

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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions