Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your firm maintains a citation index of biomedical journal articles used by a variety of medical research institutes and pharmaceutical firms. Each article is identified
Your firm maintains a citation index of biomedical journal articles used by a variety of medical research institutes and pharmaceutical firms. Each article is identified by a unique "DOI number"; in addition to this number, you want the database to store each article's title, abstract, date of publication, journal volume number, journal issue number, and journal pages. Each article is authored by one or more researchers. For each researcher, your database should store a family name, given name, date of birth, and current employer. The database should remember which researchers authored each article, and the order they appear in the article writing credits. Each article appears in a single journal, and each journal is identified by a unique "ISSN" number. The database should be able to identify which journal each article appeared in. Furthermore, for each journal, the database should remember its name and the name of the organization that publishes it. Sometimes journals change names, and one journal "continues' another journal. For example, the ORSA Journal on Biomedical Computation might become the INFORMS Journal on Biomedical Computation when its publishing organization merges with another organization. The name change makes it a different journal but the database should be able to remember which journal (if any) "continues" any given journal. Finally, articles usually contain multiple citations to other articles. For example, an article about clinical treatment of a particular disease might contain citations to dozens of prior research articles about that disease. This information can be very useful to researcher, so the database should be able to store the full pattern of citations between articles. Note that an article not only usually cites many other articles but may also be cited by many other articles. 1. Create a high-level ERD which shows only the cardinality and modality between the main entities. 2. Write out the tables including the primary keys and the foreign keys. 3. Complete a full ERD with all tables, cardinalities, and modalities
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started