Develop a database using Microsoft Word or Excel with 4-5 tables that will contain the data for this application. The system will collect information

about faculty members as follows:

Faculty ID, position (e.g. full-time) and title (e.g. Associate Professor)

Faculty degrees, institutions and year of degree awarded

Resumes (text blob)

Academic Accomplishments (papers published, books, honorary degrees)

Courses Taught including changes, innovations, etc.

Decide what databases you need to support the transaction and describe them in the data dictionary for your tables.

Each table should include field name, data type, data length, key fields, source and whether the data can have a null value.

**Also create an entity relationship diagram for the protoypes above using powerpoint

Menu Screen: CC Faculty Information System File Home Create External Data Database Tools Ascending Y selection New E Totals Descending va Advanced Save spelling copy View Paste Format Painter Piter Refresh Find Remove Sort Y Toggle Filter X Delete E More Clipboard Sort & Filter Records Find Text Formatting CO Businsess Division Faculty Information System Faculty Navigation CC Businsess Division Faculty Information System Search. Fac Faculty Details Faculty ust .la Aur Faculty Emergency contact Inform... Faculty Address Book Enter Personal Info A Enter Course Information la Faculty by Department la Faculty by ype ,la Faculty Phone List Query Menu Enter Professional Info upporting objects Faculty Enter Awards, Report Menu Faculty Extended Publications, etc. Unassigned objects Awards Enter Professional Quit System organizations courses. FacultyED Profcert Prof org v Record Id 4 1 of 1 No Filter Search Num Lock K Form View Menu Screen: CC Faculty Information System File Home Create External Data Database Tools Ascending Y selection New E Totals Descending va Advanced Save spelling copy View Paste Format Painter Piter Refresh Find Remove Sort Y Toggle Filter X Delete E More Clipboard Sort & Filter Records Find Text Formatting CO Businsess Division Faculty Information System Faculty Navigation CC Businsess Division Faculty Information System Search. Fac Faculty Details Faculty ust .la Aur Faculty Emergency contact Inform... Faculty Address Book Enter Personal Info A Enter Course Information la Faculty by Department la Faculty by ype ,la Faculty Phone List Query Menu Enter Professional Info upporting objects Faculty Enter Awards, Report Menu Faculty Extended Publications, etc. Unassigned objects Awards Enter Professional Quit System organizations courses. FacultyED Profcert Prof org v Record Id 4 1 of 1 No Filter Search Num Lock K Form View