Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions