Question: Draw ERD using Crows foot notation based on the following scenario. Many inventions are made by scientists. To capture the inventions made by scientists,

Draw ERD using Crow’s foot notation based on the following scenario. • Many inventions are made by scientists. To capture the inventions made by scientists, an international organization considers to develop a database. The organization collect data about scientists (ID, first name, last name, email, affiliation, research area, country) and inventions (ID, title, patent, description). A scientist can make zero or many inventions and one invention can be made by either one or many scientists. A scientist must register his or her invention and registration number, registration date, and valid date must be stored in database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

In the given scenario you have two main entities Scientists and Inventions The relationship between them is manytomany as one scientist can make multi... View full answer

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 Programming Questions!