Chapter $6$

BITS Corporation

$1.$ Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants.

DBDL:

ENTITY ClientConsultant

PK $\{$ClientID$,$ ConsultantID$\}$ ClientID INT

ConsultantID INT DateStarted DATE END$\_$ENTITY

$2.$ Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between client and consultant. When a client places an order $($services request$),$ it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order.

DBDL:

ENTITY ServiceRequest PK ServiceRequestID ClientID INT FK ConsultantID INT FK

$...$ END$\_$ENTITY

$3.$ Indica the changes you need to make the BITS database design to design to support the following situation. The region where clients are located is divided into territories. For each territory. Each client also is assigned to a single territory, but the territory must be the same as the territory to which the client$$s consultants is assigned.

DBDL:

ENTITY Territory

PK TerritoryID

TerritoryName VARCHAR $(50)$ END$\_$ENTITY

ENTITY Consultant PK ConsultantID

$...$

TerritoryID INT FK END$\_$ENTITY

Natali Ospina HIM$361$ Spring$2024$

ENTITY Client PK ClientID

$...$

TerritoryID INT FK

ConsultantID INT FK END$\_$ENTITY