Professors Records Database Design.

1Professors Records Database Design
PROFFESORS RECORDS DATABASE DESIGN
[Student name]
[College Name]
[Lecture Name]
[Due Date]

2Professors Records Database Design
Table of Contents
Dependency Diagram......................................................................................................................3
Identified Multi-valued Dependencies............................................................................................3
Dependency Diagrams of Tables Structures in 1-3NF.....................................................................4
Crows Foot’s ERD.............................................................................................................................5
Reference.........................................................................................................................................6

3Professors Records Database Design
Dependency Diagram
(Thomas, 2013)
Identified Multi-valued Dependencies
a) EMP_NUM, PROF_RANK, EMP_NAME----------> DEPT_CODE,
DEPT_NAME ,PROF_OFFICE
b) EMP_NUM, EMP_NAME, PROF_RANK----------> ADVISEE, COMMITEE_CODE,
JOURNAL_CODE (Shamkant, 2015).
c) DEPT_NAME, DEPT_CODE ----------> PROF_OFFICE (Ramez, 2015).
EMP_NUM PROF_RANK EMP_NAME DEPT_CODE DEPT_NAME PROF_OFFICE ADVISEE COMMITEE_CODE JOURNAL_CODE

4Professors Records Database Design
Dependency Diagrams of Tables Structures in 1-3NF
a. 3NF
PROFESSOR
EMP_NUM PROF_RANK EMP_NAME PROF_OFFICE PHONE_NO EMAIL DEPT_CODE ADV_CODE COMMITEE_CODE JOURNAL_CODE
(Stephen, 2014).
DEPARTMENT
DEPT_COD
E
DEPT_NAME LOCATION
ADVISEE
ADV_CODE ADV_NAME PHONE_NO EMAIL
COMMITTEE
COMMITEE_CODE NAM
E
DUTIES
JOURNAL
JOURNAL_COD
E
TITTLE PUBLISHER AUTHORS EDITION_NO
(Elmasri, 2013).
b. 2 NF
EMP_NUM PROF_RANK EMP_NAME PROF_OFFICE PHONE_NO EMAIL DEPT_CODE DEPT_NAME LOCATION
EMP_NUM PROF_RANK EMP_NAME PROF_OFFICE PHONE_NO EMAIL ADV_CODE ADV_NAME PHONE_NO EMAIL
EMP_NUM PROF_RANK EMP_NAME PROF_OFFICE PHONE_NO EMAIL COMMITEE_CODE NAME DUTIES
EMP_NUM PROF_RANK EMP_NAME PROF_OFFICE JOURNAL_CODE TITTLE PUBLISHER AUTHORS EDITION_NO
c. 1NF
EMP_NUM PROF_RANK EMP_NAME DEPT_CODE DEPT_NAME PROF_OFFICE ADVISEE COMMITEE_CODE JOURNAL_CODE

5Professors Records Database Design
DEPARTMENT
PKDEPT_CODE
DEPT_NAME
LOCATION
ADVISEE
PKADV_CODE
ADV_NAME
PHONE_NO
EMAIL
COMMITEE
PKCOMMITEE_CODE
NAME
DUTIES
JOURNAL
PKJOURNAL_CODE
TITTLE
PUBLISHER
AUTHORS
EDITION_NO
PROFFESOR
PKEMP_NUM
PROF_RANK
EMP_NAME
PROF_OFFICE
PHONE_NO
EMAIL
FKDEPT_CODE
FKADV_CODE
FKCOMMITEE_CODE
FKJOURNAL_CODE
Crows Foot’s ERD
(Dick, 2018).

6Professors Records Database Design
Reference
Dick,B.(2018) IT Project Management Essentials: Information Systems Project Methodology
Kindle Edition.1st edn.New York:Amazon Digital Services LLC.
Elmasri,E.(2013) Database Systems: Models, Languages, Design and Application Programming.
2nd edn India: PEARSON EDUCATION.
Ramez,E.(2015) Database Systems: Models, Languages, Design and Application Programming
- International Edition Paperback.2nd edn. India:PEARSON EDUCATION.
Shamkant, B.(2015) Fundamentals of Database Systems (7th Edition).India:pearson.
Thomas,C.(2013) Database Systems: A Practical Approach to Design, Implementation and
Management: WITH Success in Your Project.1st edn. USA:Addison Wesley.
Stephen,H.(2014) Management Information Systems with student CD and MISource.3rd edn. New
York:McGraw-Hill.