The Ph$.$D$.$ in Business Administration program is in need of a database solution that can keep track of the research and teaching interest of faculty and doctoral students and track student progress throughout the program from entry to graduation. The solution will be used to facilitate faculty$/$student match for dissertation work and enrich research seminars with faculty research expertise. The program is designed in way that each research topic is taught by an expert faculty of either Coles college or outside the KSU. Faculty experts outside of KSU are called Golobal Scholars.

The final solution should be able to:

Functional Requirements

Using forms, add new faulty along with their research and teaching interests.

The following information needs to be captured: first name, last name, email address, cell phone number, KSU faculty or Global scholar?, research interests, and teaching interests.

Using forms, Add new students along with their research interests.

The following information needs to be captured: first name, last name, email address, cell phone number, research interests, teaching interests, and dissertation topic.

Using forms, Add new research module

The following information needs to be captured: module name, faculty who teaches the module, module content, module semester$/$year$.$

Generate a report of faculty teaching interests.

Generate reports of faculty and student research interest match.

The end$-$user should be able to clearly identify that, for example, faculty A research interest matches that of Students B and C and vice versa $($Student B research interests matches that of Faculty A and D$).$

Generate reports of students$$ dissertation committee information

Each committee has a chair, a second, and a reader.

Generate reports of graduated student placement and status

What job did you end up getting as a result of graduation from the program? It needs to capture employer information $($the name would be enough$)$

Generate reports indicating which faculty taught any specific module and vice versa.

For example, faculty A can teach research modules VV$,$ BB and a research module can be taught by different faculty at different times $($semesters$)$