## Medical_Journals

id | name | publisher
--- | --- | ---
1 | Lancet | Elsevier
2 | New England Journal of Medicine | Massachusetts Medical Society
3 | The BMJ | BMJ Group
4 | JAMA - The Journal of the American Medical Association | American Medical Association
5 | Nature Medicine | Springer Nature

## Articles

id | title | abstract | type
--- | --- | --- | ---
1 | Effective Treatment of Diabetes | This study explored new treatment options for diabetes... | Research_Article
2 | Advances in Cancer Therapy | Recent developments in cancer therapy have shown promising results... | Review_Article
3 | Innovations in Cardiac Surgery | The field of cardiac surgery has seen significant innovations over recent years... | Research_Article
4 | Understanding Alzheimer's Disease | Alzheimer's disease is a complex neurological disorder that affects millions... | Review_Article
5 | Psychological Factors in Chronic Pain Management | Chronic pain management often requires an interdisciplinary approach including psychological factors... | Research_Article

## Authors

id | firstName | lastName | affiliation
--- | --- | --- | ---
1 | John | Doe | University of California San Francisco
2 | Jane | Smith | Stanford University
3 | Michael | Brown | Harvard Medical School
4 | Emily | White | Columbia University
5 | David | Black | Yale School of Medicine

## Journal_Authors

journalId | authorId
--- | ---
(→ Medical_Journals.id) | (→ Authors.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Article_Authors

articleId | authorId
--- | ---
(→ Articles.id) | (→ Authors.id)
1 | 1
1 | 2
2 | 3
3 | 4
4 | 5

## Medical_Journals_Articles

medicalJournalId | articleId
--- | ---
(→ Medical_Journals.id) | (→ Articles.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5