Create an ER Diagram using ERDPlus software as described below. i-soft is a software company. The operations database will keep track of the following: software, coders, coding languages, and editors.

Tables:

Software table: SoftwareID (char 4), SoftwareTitle (varchar 20), Genre (char 10), ReleaseDate (Date), and Price (float)

Coder table: CoderID (char 4), FirstName (varchar 20), and LastName (varchar 30), Yearofexperience (int)

Language table: LanguageID (char 4), LangName (varchar 20), and Purpose (varchar 20) CodeReviewer table: CodeReviewerID (char 4), FirstName (varchar 20), LastName (varchar 20), and Expertise (varchar 10)

Relationships:

Each software product can be coded by one or many coders, and each coder can code many software products or none.

Each coder knows one or many coding languages. Each language is known by many coders, or none.

Each software product must have exactly one code reviewer. Each code reviewer can edit at least one or many software products.

Save the ER diagrams picture in your computer and then insert it below.

#---------------------------- ER DIAGRAM BELOW------------------------------ #------------------------------------------------------------------------------------------

Create a schema using isoft ER diagram and then generate the SQL code using this schema. Copy and paste the SQL code below:

#-------------------------------- SQL CODE BELOW ---------------------------------- #--------------------------------------------------------------------------------------------