السلام عليكم ورحمة الله وبركاته
انا عندي مشروع في البنية التحتيه او االاساسيه لشركة ما

وانا بصراحه ما اعرف كيف ابدآ
علماانه لم بقي وقت يسعفني

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

بليز انا والله في امس الحاجه له
وهذي صيغه المشروع

LG Infrastructure

LG is an electronic manufacturing company that consists of various departments like “Human
Resource”, “Product and Services”, “Sales & Support”, “Assembling Materials” etc.
Department are categorized by its type like M: Manufacturing, S: Sales, U: Support etc. .
LG has large infrastructure in terms of various buildings with multiple floors.
Each department may be located in more than one building.
A building has more than one floor and each floor has many rooms.
In many rooms there are more than one cubicle sections where employees are sitting.
Any cubical is considered as empty if there is no employee assigned to it (shown in figure 1).
A department consists of more than one employee and no employee belongs to more than one department.
Main office of each department is considered as main location in a building, however rooms are belong to department and those rooms may be located in more than one building.
In one room, only employees from one department are located.
Each employee works under some Manager (who is also employee), each Manager works under Director of this company.

The following relations represent the LG infrastructure as described in the above case brief (need to be modified and normalized as per ER design & required forms).

Employee(employee_no, first_name, last_name, tel_no, email, dno)
Department(dno, department_name, location)
Buidling(B_No, B_Name, Location)

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

(shown in figure 1).

اين هذا الشكل او الرسم

مرفق ملف به رسمة ال ERD

ما شاء الله عليك اخوي أمجد..