Construct a reasonable ERD to capture the data requirements. List the entities, relationships with multiplicities, and attributes. Specify the primary key of an entity whenever possible. Note that you should use the Crow's Foot notation as supported by ER Assistant v2.1. ER Assistant supports attributes for relationships and your ERD may have relationship attributes

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Simple Team Modeling Tool (TMT) Prototype 

Modelers from a consortium of multiple organizations can work on developing
multiple Software and Engineering models. TMT provides some very simplistic
supports.


A model has a unique model Id, a name, an optional description, and a start date.
This can be regarded as the description of the model.


A model is composed of one or more top-level components. A component has a id, name and an optional description. A component has a predefined type, e.g.


'Conceptual', 'Mongo_Logical', MySQL_Logical', etc. A component may have subcomponents. The actual component content may be an ER model, UML model, SysML model, etc. A component may have some relationships with other components, and the descriptions of these relationships should be stored.

 

Construct a reasonable ERD to capture the data requirements.
List the entities, relationships with multiplicities, and attributes. Specify the primary
key of an entity whenever possible. Note that you should use the Crow's Foot
notation as supported by ER Assistant v2.1. ER Assistant supports attributes for
relationships and your ERD may have relationship attributes.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education