Question: 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,

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!