مساء الخير

شحالكم ان شالله بخير
يا جماعه عندي سؤال ياريت تقدرون تساعدوني فيه
هذا دومين كلاس وابيكم تشوفون اللي سويته صح ولالا ؟؟ واذا في غلط ولا شي ساعدوني بكون شاكرة لكم
هذا نص السؤال
A construction company has many divisions. A division operates between two to five departments. A division has a name and location. A department has at least 10 employees. Each employee can work only in one department. A department has a name, and building number. Each department has one secretary. An employee may be work in many projects in the department or he/she may not be assigned to any project. A project has a name. An employee has a name, office number, and email. Each division has one supervisor who is not an employee. A supervisor has a name, and office number. An employee can be a worker or non-worker. A worker gets paid a weekly wage based on number of hours worked, while non-worker gets fixed monthly salary.

Based on the above description, do the following:
1. Draw the domain model class diagram for the above situation.
2. Show the connectivity.
3. Show the attributes; identify the primary key and the foreign key.
4. Show the cardinality
ماحطيت attributes
لاتضحكون على رسمتي ههه

يمكن اعتبار السكرتير secretary تصنيف لنوع الوظيفة للموظفين employees
وبالتالى لا يكون له كلاس منفصل
وانما يأخذ نفس صفات الموظف