السلام عليكم

الاعضاء الكرام اطلب مساعدتكم في انشاء Entity Relational-Diagram , وهو يكون simple لأني مبتدئة في الداتا بيس ,

فقط يكون فيه زي ما السؤال مكتوب وبدون انشاء جداول لأني حاولت فيه كتير ولساتي مش عارفة

Draw an ER model for the following, showing all entity types and their primary keys, relationship details including cardinality ratios and participation.

يعني تتسلوا فيه

السؤال:

3. Library

A library has approximately 16,000 members, 100,000 titles, and 250,000 volumes. The librarian ensures that the books that members want to borrow are available when the members want to borrow them. Also, the librarians must know how many copies of each book are in the library or out on loan at any given time. A catalog of books is available online that lists books by author, title, and subject area. The reference librarian wants to be able to access this description when members request information about a book. Books can be checked out for 21 days.
To become a member of the library, applicants fill out a form including their SSN, campus and home mailing address, and phone numbers. The librarians then issue a numbered, machine-readable card with the member’s photo on it. This card is good for four years from the issue date. Professors at the institute are considered automatic members. When a new faculty member joins the institute, his or her information is pulled from the employee records and a library card is mailed to his or her campus address.
The library does not lend some books, such as reference books, rare books, and maps. The librarians must differentiate between books that can be lent and those cannot be lent. In addition, the librarians have a list of some books they are interested in acquiring but cannot obtain, such as rare or out-of-print books and books that were lost or destroyed but have not been replaced. The librarians must have a system that keeps tracks of books that cannot be lent as well as books that they are interested in acquiring.
Some books may have the same title; therefore, the title cannot be used as a means if identification. Every book is identified by its International Standard Book Number (ISBN), a unique international code assigned to all books. Two books with the same title can have different ISBNs if they are in different languages or have different bindings (hard cover or soft cover). Editions of the same book have different ISBNs.
The proposed database system must be designed to keep track of the members, the books, the catalog, and the borrowing activity.

الف شكر لكم وبليز يكون الرد قبل الساعة 12 بالليل

تم تعديل 12 مارس 201016 سنة بواسطة سمسورة

السلام عليكم ورحمة الله وبركاته

تفضلى

ومرفق لينك بالصورتين فى ملف مضغوظ

منقول من

http://www.databaseanswers.org/data_models/

2__library_Erd.rar

تم تعديل 12 مارس 201016 سنة بواسطة ENG_HOSSAM_WALLY

شكرا لك ENG_HOSSAM_WALLY على ردك , لكني اطلعت عليه و مو هو زي المطلوب فالسؤال بالضبط

اللي عنده حل ثاني أكون شاكرة له

وشكرا لك ENG_HOSSAM_WALLY مرة اخرى