Softcraft Ltd$.$ is a corporation involved in the design, development, and

marketing of software products for a family of advanced personal computers. The list of entities and the relationships among them are listed below. DRAW the ER diagram constructs for these entities and the associated relationships. State any assumptions.

The entities that this enterprise would be interested in includes:

Company:

$-$ Attributes: CompanyID $($Primary Key$),$ Name, Location, Contact Information

Software Product:

$-$ Attributes: ProductID $($Primary Key$),$ Name, Version, Description, Release Date

Development Team:

$-$ Attributes: TeamID $($Primary Key$),$ Team Lead, Number of Developers, Project$($s$)$ Assigned

Customer:

$-$ Attributes: CustomerID $($Primary Key$),$ Name, Contact Information

Sales Order:

$-$ Attributes: OrderID $($Primary Key$),$ Date, CustomerID $($Foreign Key$)$

Development Project:

$-$ Attributes: ProjectID $($Primary Key$),$ Name, Description, Start Date, End Date, Budget

Employee:

$-$ Attributes: EmployeeID $($Primary Key$),$ Name, Position, Contact Information

The relationships among these entities are:

$-$ Company: Software Product $1$:N $($because a company can have multiple software products$).$

$-$ Development Team: Development Project $$ M:N $($a development team can work on many projects and a project can have many teams working on it$).$

$-$ Sales Order: Customer $$ N:$1($a customer can place multiple orders and a sales order belongs to one customer$).$

$-$ Employee: Development Team $$ M:N $($because an employee can be a part of multiple development teams and a development team can consist of multiple employees$).$