Question: Can you write the ER diagram and database design outline for this problem You are building a data base of for Mathematics Genealogy Project. During

Can you write the ER diagram and database design outline for this problem

You are building a data base of for Mathematics Genealogy Project. During this project, you want to create a more detailed database than the Mathematics Genealogy Project of NDSU. For example, on top of genealogy information, you want to add some research paper database. Each researcher is identified by an ID number, and you want to store each researchers first name, last name, PhD institution, dissertation title, year degree earned, subject classification, and PhD advisors information. All PhD degree holder has a supervisor except for whom without supervisor or such information. You have an access to a table of subject classification, which contains subject classification code, and the description of subject. Furthermore, you also wants to keep track of researchers publication record. In many cases, researchers have more than one paper and each paper has multiple authors. For each paper, you want to store the name of journal and volume, issue number, the title, the authors, and the author number. Author number indicates the order in which each author appears on the publications title page. In the database, this author number field should be stored as integer. For example, the corresponding author has integer value 0, the first author has integer value 1, the second author has integer value 2, and so on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!