[يسار][/يسار]The VLDB (Very Large Databases) conference is an international conference which is held every year in one city. A database is decided to maintain information about different occurrences of the VLDB conference.
 Each occurrence of the conference is identified by the year (unique) and described by city, location, chairman, an organizing committee, a set of participants, and a set of papers (articles). It is required to keep track of the total number of participants and papers for each conference occurrence.
 Each conference occurrence is organized as a set of sessions. Each session is identified by a number which is unique for all sessions of the same conference occurrence. In addition, a session is described by location, chairman, co-chairman, start time (month-day-hour-minute), end time (month-day-hour-minute), and a set of papers.
 Each paper (article) presented in any conference occurrence is identified by a number which is unique for all papers of the same occurrence. In addition, each paper is described by one or more authors (considered as participant in the conference occurrence), a type (research, tutorial, industrial, lecture... etc.), and a set of references (papers presented in previous occurrences of the conference). Each paper is presented in only one of the sessions of the conference occurrence.
 Each participant is identified by a number (unique), and described by a name, category (distinguished lecturer, chairman, member of an organizing committee, author... etc.) and E-mail address. A participant in any conference occurrence may pay certain fees which is determined according to his/her category. It is required to keep track of the total fees for each particular conference occurrence.

For_each_of_the_following_data_requirements.doc

ارجو الرد لو سمحتم اليوم

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

يمكن استخراج مجموعة ال entities التالية ... ويمكنك باستخدام احد البرامج المساعدة ان تعد رسمة ال ERD مثل برنامج ال VISIO or POWERDESIGNER

Conference(Conference _year, city, location, participant_ID, organizing committee)

Session(Conference _year, session_id, location, participant_ID, co- participant_ID, start_time, end_time)

Article(Conference _year, Article_ID, session_id, Article_type_code)
Article_ references(Conference _year, Article_ID,REF_ Article_ID)
Participant(participant_ID, Participant_Name, Participant_category_code, E-mail_address)
Article_ participant(Article_ID, participant_ID)
Article_type_Code(Article_type_code, Article_type_description)
category(Participant_category_Code ,category_ description, category_fee)