Question

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

13 Sep 2024
Answer :
Word Count : 982

To design normalized tables in 3NF (Third Normal Form) based on an ER diagram, the steps involved include identifying the entities, relationships, and attributes, and then applying the normalization rules progressively from 1NF (First Normal Form) through 2NF (Second Normal Form) and ultimately to 3NF. Below, we will discuss how to achieve the normalized form based on an ER diagram without seeing the actual diagram. For this example, let’s assume a simple ER diagram with entities like `Employee`, `Department`, and `Project`, with attributes associated with each and relationships between them.

### Step 1: Identify Entities, Attributes, and Relationships
Assuming the following entities and relationships in the ER diagram:

1. Employee:
   - Attributes: `EmpID` (Primary Key), `EmpName`, `EmpSalary`, `DeptID` (Foreign Key referencing Department)
   
2. Department:
   - Attributes: `DeptID` (Primary Key), `DeptName`, `DeptLocation`
   
3. Project:
   - Attributes: `ProjID` (Primary Key), `ProjName`, `EmpID` (Foreign Key referencing Employee)
   
4. Employee_Project (Many-to-Many relationship between Employee and Project):
   - Attributes: `EmpID` (Foreign Key), `ProjID` (Foreign Key), `Role`, `HoursWorked`
   
### Step 2: Convert the ER diagram into Unnormalized ________ _____ __________ ______ ___ _______ _____.
________ ___ ____ ________ ______.
_______ _____ ___ ___ ________ ______ _________ _________ _________.
_____ __________ _________ ____ _____ ___ _________ ____ _____ _______.
____ _________ _______ ______ ___ ___ _______ _________ ___.
________ ____ ___ _________ __________ _____ _______.
_____ _________ ______ ______ ________ _________ _______ ____ ________ __________.
____ _________ ____ _________ ___ _________ ________ ______ ________ ___ __________.
___ ____ ____ ________ ________ ______ __________.
________ ___ _______ __________ ______ _______ _____.
___ ___ _____ _________ ________ __________ ______ ____ ______ _________ _________.
_________ _______ ________ _______ _______.
___ ________ __________ _________ _____ ______ _________ ________ ___ ___ ______.
_____ __________ _________ ___ _______ __________ _____ ____ _________.
_____ ______ __________ ________ _________ _______ ___ ________ __________ ______ ________.
________ ________ _______ _____ ______ __________ ____ ________ ___.
____ _________ _____ ___ ____ __________.
__________ _____ ___ ________ _________ _______ ______ _______ _______.
____ _______ ____ _________ _______.
_________ _____ _________ _______ _______.
__________ _____ ____ _______ ________ _____ __________ _______ _____ ___ _______ _________.
______ ____ __________ ______ ________ __________ __________ _________ _____ _________ ________ ______.
______ _______ ______ _____ _______ ____ ______ __________.
__________ ________ ______ ______ _______ ____ __________ ______.
_________ _____ ___ ______ __________ __________ _______ ____ ____ ___ __________.
_________ _______ ________ ____ _________ _________ _____ ___ __________.
__________ _____ ______ _____ ___ __________.
___ _____ ________ _________ _________ ________ _______ ____ ________ _________ __________.
_____ _______ __________ _____ _____ _______ ___ _____ ________ ___ ________.
________ __________ _________ ___ ___ ______ ___ ______ _______ _________ ____ ___.
_________ _________ ____ _________ _____ ___ _________.
_________ _____ _______ ________ ____ ____ ____.
______ _________ __________ _________ _________ _________ _________.
______ _______ _________ _________ _________ ___ _______ ________ ____ ____.
________ ___ ________ _________ ____.
__________ __________ ________ ______ ____.
__________ _________ _________ _______ ________ ____ ______ _____.
_____ ___ _____ _________ _______ ________ ____ _____ ______ ____ _________ ____.
____ ____ ______ ______ _________ ____ _________ ______ ________ _________.
_____ ________ _______ ________ __________ ______ ___ __________.
________ _________ _______ _______ __________ _____ ________ ________ ____ __________ ___ _________.
____ ______ _____ _________ _________ ____ ____ _____ ______ _________ ___.
___ _________ ______ _____ ________ ________ _____ ___ ____ ____.
________ ______ __________ ____ ____ ___ ____ ______ _____ ___.
____ ______ _______ __________ ________ __________ ___.
__________ __________ _____ ______ _________ ______.
___ ____ _______ ________ ____ ___ __________ _________ ______ _____ ______.
__________ _________ ______ _______ _____.
_________ ____ ______ ___ __________ _________ ______.
__________ ________ ________ ___ ________.
_____ ___ _____ __________ _________ __________ _________ __________ ___ ___.
___ _______ ___ __________ _________ __________ ________ ______ ________ _______.
_________ _________ ________ ___ _______ _______ ______ ___ _________ __________ _______ ___.
_______ _______ ____ ___ ___ __________ ________ _______ ________ __________ ______.
_______ ________ __________ ____ _____ ______ __________ ________ __________.
________ __________ _________ _________ ______ ___ ________ ______.
_________ ________ ______ ___ __________ ___ __________ ______ ______ ____ ________ ______.
___ _________ ______ ______ _______ _______ ______ __________ ________ _____ _______ ______.
_____ ____ _______ ____ ____ __________.
____ _________ _________ _______ ______ __________ ________ ______ ______.
_____ ______ __________ ____ ____.
______ ______ ______ _____ ______ _______ _____ ____.
______ ______ _________ _____ __________ _______ _________.
_________ ____ ________ _________ ____.
________ ____ ________ ________ ____ ________ ____.
______ ________ _______ ___ _____ _____ __________ _____ ________ ________ ___ ____.
______ _______ _________ __________ _________ ________ ___ ___ _____.
__________ _______ _______ ______ __________ _______ __________ ____ ________ _________ _______ _____.
________ ________ ________ __________ ___ ___ __________ ____.
_____ _____ __________ ___ ________ ___ __________ _______.
_____ _________ __________ _________ ______ __________.
_________ ________ __________ ____ ____ ________ ________ ________ ________ __________.
____ _______ ___ ______ ____ _________ _________ _____ ______ _______.
___ _____ ___ _________ ______ ___ _________.
_______ _______ _________ ___ __________ _________ _________ ___ __________.
__________ _______ __________ ________ ____ _________ ___ ______.
________ ____ ________ ____ ____ ____ __________.
_____ ________ _________ _______ _________ __________ _______ ____ ___ _______ ________ _________.
____ ______ _______ _________ ________ _____ ______ ____ ____ ________.
______ ___ ______ _______ ______ __________ __________ _________ _______ ___.
_______ ____ _______ ________ ____.
____ ____ ___ ___ ______ ________ _________ _________ __________ ______.
___ _____ ___ __________ ____ ________.
_____ __________ _______ ____ ____ ___ _________ ___ _________ ______ __________ _______.
______ __________ _____ ______ ____ ________ ________ __________ ________ ________ _______ ________.
_________ __________ ____ __________ __________ ___ ______ ___ __________ ____ ___.
_______ _____ ___ _______ _____ ___ _______ _________.
__________ __________ ______ _______ _________ _______.
__________ ________ ________ _______ ______ ___ __________ _______ ________ __________.
_________ ______ ___ ______ ____ ____ ____ _______ ________.
________ __________.
Get Full Answer on WhatsApp

IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance Design normalised tables in 3NF for the ER diagram drawn in part (c),
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→