TOPIC : Collect a simple ER diagram with explanation

R&D SCHEMA:

  1. Every topic should contain name, code and research area.
  2. The topics can have several reports and the reports may contain several topics in them.
  3. The report should have a title.
  4. A department can publish more than one report. A report can be published only by a single department.
  5. The department must have its name and address.
  6. Reports can be written by many contractors and contractors can write many reports.
  7. Each contractor should have name and address.
  8. A publication can include several topics and a topic can be present in more than one publications.
  9. A publication must have its title and code.
  10. One department can have many publications and a publication can be made only by one department.

ENTITIES:

  1. TOPIC-AREA
  2. REPORT
  3. PUBLICATION
  4. CONTRACTOR
  5. DEPARTMENT

RELATIONSHIPS:

1.The topics can have several reports and the reports may contain several topics in them.

2.A department can publish more than one report. A report can be published only by a single department.

3.Reports can be written by many contractors and contractors can write many reports.

4.A publication can include several topics and a topic can be present in more than one publications.

5.One department can have many publications and a publication can be made only by one department.

KEY ATTRIBUTES:Image

  • PUBLICATION—CODE
  • DEPARTMENT—NAME
  • CONTRACTOR–  NAME
  • TOPIC AREA – CODE
  • REPORT —  TITLE

 RELEVANT ATTRIBUTES:

  • PUBLICATION—CODE,TITLE
  • DEPARTMENT—NAME,ADDRESS
  • CONTRACTOR—NAME,ADDRESS
  • TOPIC AREA—CODE,NAME,RESEARCH AREA
  • REPORT—TITLE

ER Diagram:

:Image

Advertisements