Visiting Speakers Program Specification

Visiting Speakers Program Specification


I. Introduction

We want to build a system which allows administrators to add speaking specialties in the database and topics under these specialties. The administrator should then be able to map current physicians in the database to these topics. There is an excel sheet with the current data we need to import.

II. Specialties
  • Specialty ID
  • Name
III. Topics
  • Topic ID
  • Name
IV. Physician Topic Mapping
  • Topic ID
  • Physician ID
  • Mapping Date
V. Data Model Requirements
  • Use Categories Table for Specialties and Topics
  • Table for Topic to Physician Mapping
VI. Admin Requirements
  • View all specialties
  • Add a specialty
  • Edit specialty
  • Delete specialty
  • View all topics within a specialty
  • Add a topic within a specialty
  • Edit topic
  • Delete topic
  • View all physicians within a topic
  • Map physicians to a topic
    • Method 1: Search for a physician
    • Method 2: Select physician from select box
VII. User Requirements
  • View Specialties
  • View Topics within Specialties
  • View all physicians within a topic
VIII. Importing Data
  • Import data from excel file

avni@avni.net