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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started