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
Get step-by-step solutions from verified subject matter experts
