Answered step by step
Verified Expert Solution
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.
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 AdventureStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started