Company Data Requirements

1- qadam. Entity tiplarini aniqlash (Faqat entity jadvallarni yaratib olamiz)
Employee

emp_id

fname

lname

birth_date

sex

salary

Branch

branch_id

branch_name

Client

client_id

client_name

2-qadam. Weak Entity tiplarini aniqlash
Branch Supplier

branch_id

supplier_name

supply_type

3-qadam. 2 ta Entity o’rtasidagi 1:1 bog’lanishlarni aniqlash (Foreign Keyni qaysi jadvalda total participation bo’lsa shu jadvalga qo’yamiz)
Manages

branch_id

branch_name

mngr_id

mngr_start_date

4-qadam. 1:N bog’lanishlarni aniqlash. (Works for, Supervision, Handles. N tomoniga FK qo’shamiz)
Employee

emp_id

fname

lname

birth_date

sex

salary

super_id

branch_id

Client

client_id

client_name

branch_id

5-qadam. M:N bog’lanishlarni aniqlash. (2 ta regular Entity lar o’rtasida) Yangi jadval yaratamiz. Bu jadvalda ikkala jadvalning ham PK lari qatnashadi. Relationship attribute (aloqa atribut) lari ham qatnashadi.

Works with

emp_id

client_id

total_sales