الرجاء كل الرجاء تساعدوني في حل هذه الاسئله

بسم الله الرحمن الرحيم

كيفكم اخواني اخواتي
انا عندي اسايمنت ولازم اسلمه الاسبوع الجاي وهو في قواعد البيانات
وفي بعض الاسئله اللي ماعرفت اجاوب فيها
ياليت تساعدوني
ولكم جزيل الشكر ..

هذي الاسئله

Scenario: Consider the following scenario modelling project management activities in a organization.
A software company has many business domains. Each business domain is managed by a domain head. A business domain is characterised by domain number, domain name and domain description. Domain head has employee number, name and skill set description. A domain head can handle more than one business domain. A domain has may have more than one project or may not have any project. A project has a project number, project title, project duration, priority and project description. A project should belong to at least one domain or might belong to more than one domain. A business domain has many project managers. There should be atleast one project manager in a business domain. A project manager belongs to exactly one business domain. A project manager has an employee id, name, grade and experience details. A project is managed by exactly one project manager. However, a project manager may manage more than one project or may not handle any project. All project manager reports to their respective
business heads. All project should have one quality expert. A quality expert might supervise quality related activities of many projects or may not handle any project. A quality expert has a employee id, name and certification details.

هنا يجي السؤال >>

Task 1:
Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify the different entities, attributes of each entity including primary key, not null, relationship between the entities and integrity constraints