I am currently working on making an a public library database E/R diagram and wa

Question

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.

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

Explanation / Answer

The ER diagram has some of the notations to be followed to create the diagram. Like rectangle for entity and oval for attributes. So please change your diagram as per the standard notations of ER diagram.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.