Database Design for Professors Records: Project Overview

This project focuses on the design of a database for professors' records. It begins with a dependency diagram illustrating the relationships between different data elements such as employee number, rank, name, department, and office. The project identifies and addresses multi-valued dependencies, providing a breakdown of how these dependencies impact the database structure. The solution then presents the database structures in 1st, 2nd, and 3rd Normal Forms (1NF, 2NF, and 3NF), showcasing the process of normalization to reduce data redundancy and improve data integrity. A Crows Foot's Entity-Relationship Diagram (ERD) is included to visually represent the database schema and relationships between entities. The project references several database systems and project management textbooks to support the design choices and methodologies. The project demonstrates the practical application of database design principles, offering a comprehensive guide to creating an efficient and well-structured database for managing professor data.

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.