السلام عليكم ورحمة الله وبركاته
لا اعلم ان كان هذا القسم المناسب لوضع موضوعي ام لا عذرا ادارتنا الموقره ان كنت وضعته في المكان الغير مناسب! :mellow:
لدي سؤال بخصوص entity,relationship
The database that you are about to design in this project is for Bookstore. The main function of Bookstore is to provide information about the (books, journals, authors, publications). You are required to design the Database as the following requirements:
1- Publishers are published books and journals which are collectively referred as publication.
2- All publications are characterized by their serial number (ISBN), title, year of publication.
3- A publisher has a name and address.
4- Books are characterized by their edition number.
5- Journals are characterized by their volume and number.
6- A Book or journal can be published by one publisher only.
7- Journals contain articles.
8- Articles are characterized by their title, subject category and it can appear in only one journal.
9- A book or an article can have more than one author (one or more).
10- Authors are characterized by their SSN, name and date of birth
انا حددت الــ entity كالتالي:publication,Publisher,book,journal,articale, author
هل تحديدي هذا صحيح وهل سيكون هناك علاقة ثلاثية بين Publisher,book,journal ؟؟
ارجو الرد وجزاكم الله خير