Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please draw a clear ER diagram with explanation and show if it's mandatory or optional or unspecified. 2. Do not use MS Word or MS

Please draw a clear ER diagram with explanation and show if it's mandatory or optional or unspecified.


attachment1.png


 

2. Do not use MS Word or MS PowerPoint to draw the ER diagram. Use tools such as https://erdplus.com/, https://www.smartdraw.com, or https://app.diagrams.net/. The Question Draw a completely labeled ER diagram for the following description. Use the (min, max) notation to specify cardinality ratios and participation constraints. "A medical research group is keeping a database about its published papers relating to viruses. The group keeps details about institutes who produce papers. For every institute, the database stores its name (unique), address (which consists of apartment number, street name, city, & country), and type. For every paper produced by an institute, the database stores details about its number (unique), title, journal name, volume number, issue number and year. A paper may refer to other papers, and it has several authors. For every author, the database stores his/her number (unique), name, nationality and date of birth. A paper writes details about viruses and a virus can be described by many papers. For every virus, the database stores its name (unique), and description. A paper is funded by one contract, but a contract may fund several papers. A contract has a number (unique), amount, start-date and end-date.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions