ASSESSMENT DESCRIPTION:

Consider the following Scenario:

Suppose you have been given the table structure and data given below, which was imported from an Excel spreadsheet. Attribute Name Sample Value Sample Value Sample Value Sample Value

EMP$\_$NUM

$123$

$104$

$118$

$120$

PROF$\_$RANK

Professor

Asst. Professor

Assoc. Professor

Assoc. Professor

EMP$\_$SALARY

$$150,000$

$$130,000$

$$130,000$

$$130,000$

EMP$\_$NAME

Ghee

Rankin

Ortega

Smith

DEPT$\_$CODE

CIS

CHEM

CIS

ENG

DEPT$\_$NAME

Computer Info. Systems

Chemistry

Computer Info. Systems

English

PROF$\_$CLASSES

Organic Chemistry

Computer Basics, Management Information Systems

English Literature

PROF$\_$OFFICE

KDD$-567$

BLF$-119$

KDD$-562$

PRT$-345$

ADVISEE

$1215,2312,3233,2218,2098$

$3102,2782,3311,2008,2876,2222,3745,1783,2378$

$2134,2789,3456,2002,2046,2018,2764$

$2873,2765,2238,2901,2308$

COMMITTEE$\_$CODE

PROMO, TRAF APPL, DEV

DEV

SPR$,$ TRAF

PROMO, SPR DEV

JOURNAL$\_$CODE

JMIS, QED, JMGT

JCIS, JMGT

The data reflect following rules:

$1.$

A professor can have multiple advisees, but an advisee can only be assigned one employee only.

$2.$

A professor can serve on multiple committees, and a committee can have multiple professors on it$.$

$3.$

A professor can edit more than one journal together with some other professors.

$4.$

A Professor can teach more than one classes but a class is taught by one professor only. A professor might be doing research only.

$5.$

In addition, the college intends to extend the database by incorporating student data including student information $($personal information, course information$)$ and information related to classes $($Teachers$,$ rooms, timings$).$Explain given business scenario and identified requirements. Explicitly mention any assumptions that you are making while working on the solution for this business scenario.