[solved]-Given Following Erd Write Table Definitions Entities Displayed Indicate Data Types Null C Q39036383

Given the following ERD, write the table definitions for theentities displayed below. You do not have to indicate data typesnor “not null” constraints in this lab. Use the format TableName (attribute, attribute…attribute). Designate primary keys with anunderline and foreign keys with a broken underline.

Example:

Regions (RegionID, RegionName)

Countries(CountryID, CountryName, RegionID)

EndDate StartDate AssignedTo- Projects Clients Contracts ProjectiD ProjectName BO—- Includes—- BO-Signs -Client ContractiD ContractDesc me ClientName Employees – Manages Records EmplD +FirstName Worksin Has LastName Email Salary Supervises WorkHours ContractTypes Logs VDay Month Year HoursWorked ContractTypeID ContractTypeNa Offices OfficeD OfficeName Livesin Countries Locatedin Country D CountryName -IncorporatedIn Regions Is Ir RegionD RegionName Show transcribed image text EndDate StartDate AssignedTo- Projects Clients Contracts ProjectiD ProjectName BO—- Includes—- BO-Signs -Client ContractiD ContractDesc me ClientName Employees – Manages Records EmplD +FirstName Worksin Has LastName Email Salary Supervises WorkHours ContractTypes Logs VDay Month Year HoursWorked ContractTypeID ContractTypeNa Offices OfficeD OfficeName Livesin Countries Locatedin Country D CountryName -IncorporatedIn Regions Is Ir RegionD RegionName

Expert Answer

---

Answer to Given the following ERD, write the table definitions for the entities displayed below. You do not have to indicate data … . . .