Consider the following conceptual design database schema, design the relational model for the database by mapping the following ER diagram to relational schema then answer the questions in LMS

-Do we need an entity type to represent the COMPANY?

-Which entity type is a weak entity?

DEPARTMENT

PROJECT

TEAM

SPECIALIST

-The address attribute in SPECIALIST entity type consider as

Simple

Composed

Multi-valued

Derived

-The cardinality ratio of TEAM : DEPARTMENT is:

1:M

1:1

M:1

M:N

-How many relationships between TEAM and specialist?

1.12.23.34.No relation between them

-Participation of TEAM in in the relationship with DEPARTMENT is

total participationpartial participation

-The correct mapping of LOAN entity type is:

:The correct mapping of LOAN entity type is 9 :The correct mapping of BANK_BRANCH entity type is :The correct mapping of CUSTOMER entity type is 11 :The correct mapping of A-C relationship is No mapping is needed :The correct mapping of LOAN entity type is 9 :The correct mapping of BANK_BRANCH entity type is :The correct mapping of CUSTOMER entity type is 11 :The correct mapping of A-C relationship is No mapping is needed