مساعده في الاتا بيز

السلام عليكم

اود من الاخوه والاخوات الكرام مساعدتي في رسم قاعدة البينات الموجوده اسفل

Entity-Relationship Diagram

Considerthe following information about an academic institute which likes to develop adatabase:

· Instructorshave an ISSN, a name, an age, a rank, and a research specialty.

· Assignmentshave an assignment number, a sponsor name, a starting date, an

endingdate, and a budget.

· Workingstudents have an WSSN, a name, an age, and a degree program (e.g., M.S.

orPh.D.).

· Each assignmentis managed by one instructor (known as the Assignment's Leader).

· Each assignmentis worked on by one or more instructors (known as the assignment's

co-assistants).

· Instructorscan manage and/or work on multiple assignments.

· Each assignmentis worked on by one or more working students (known as the

assignment'sresearch assistants).

· When workingstudents work on an assignment, an instructor must supervise their work

on the assignment.Working students can work on multiple assignments, in which case

they may havedifferent supervisors for the different assignments.

· Departmentshave a dep-num, a dep-name, and an office.

· Departmentshave an instructor (known as the head) who runs the department.

· Instructorswork in one or more departments, and for each department that they

work in,a time-limit is associated with their job.

· Workingstudents have one major department in which they are working on their

degree.

· Each workingstudent has another, more senior working student (known as a

studentadvisor) who advises him or her on what courses to take.

Develop an ER diagram that models the above informationabout the academic institute. Use only the ER notations. Identify any key andrelationships' participation

وشكرا