Database Design for Professors: 3NF and ERD Implementation
VerifiedAdded on  2022/11/14
|5
|450
|63
Project
AI Summary
This document presents a comprehensive solution for a professor database design project. It begins with a dependency diagram illustrating the relationships between various attributes such as employee number, professor rank, employee name, department code, department name, professor office, advisee, committee code, and journal code. The solution identifies multi-valued dependencies and proceeds to normalize the data to the third normal form (3NF). The process involves breaking down the initial table into multiple tables to eliminate redundancy and ensure data integrity. The document outlines the table structures in 1NF, 2NF, and 3NF. The final 3NF structure includes separate tables for professors, departments, advisees, committees, and journals, with appropriate primary and foreign keys to maintain relationships. A Crow's Foot Entity-Relationship Diagram (ERD) visually represents the database schema, illustrating the entities and their relationships. Finally, the document provides a list of relevant references. This solution is designed to assist students with their database design assignments, providing a clear and structured approach to relational database modeling and normalization.
1 out of 5