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 : 1058

To design normalized tables in 3NF for the given Entity-Relationship (ER) diagram, we first need to understand the entities, their attributes, and the relationships between them as depicted in the diagram. Normalization involves decomposing the database into smaller tables to eliminate redundancy and ensure data integrity. The normalization process follows several stages, including 1NF (First Normal Form), 2NF (Second Normal Form), and 3NF (Third Normal Form). Let’s proceed step by step through the process of converting an ER diagram into normalized tables and applying necessary integrity constraints.

### Step 1: Convert the ER Diagram to an Initial Set of Relations

An ER diagram typically consists of entities, their attributes, and the relationships between them. Each entity is converted into a table, and each attribute becomes a column in the table. Relationships are represented using foreign keys.

Let's assume the ER diagram has the following entities and relationships:

- Employee: This entity has the following attributes:
  - EmployeeID (Primary Key)
  - Name
  - Address
  - Phone Number

- Department: ________ _______ _____ _____ ______ __________ __________.
_____ _______ _______ ________ ___ _________ ____.
______ ________ _________ _____ _______ ______ ___ __________ ____ _______ _____ ______.
_________ __________ ________ ______ ________ ___.
_________ _______ _____ _______ ______ ___.
___ _________ ____ ___ _____ __________ _______ ______ ______.
_________ ______ _____ ______ __________.
____ ___ _________ ______ _______ __________ __________.
____ ___ _______ _________ __________ _____ ______ ________ _________.
_____ __________ _____ ___ ____ __________ _____ ________.
________ _________ ___ ___ ____ ______ _____ ________ ___ _____.
__________ ___ ______ ___ __________ _______ ____ ____.
__________ ________ _____ ___ ______ _______ _______ ______ ___ __________.
____ ____ __________ ___ __________ __________ ________ _________ ____.
____ ______ ______ __________ ____ __________ ______.
______ __________ __________ __________ _______.
_______ ____ ____ ______ ___ ______ ________ ___.
_______ _____ _______ ________ ________ ___ ______ ___ ____.
__________ _____ ____ _____ _________ ______ __________ _________ _______ ____.
________ ________ ______ ________ _________ _____ ___.
______ __________ __________ ______ _______ ________ _______ ___.
______ _________ ____ __________ ________ _________ ______ ______.
____ _________ ____ _______ ___ ______ ______.
___ ___ ________ ____ __________ __________ ___ ________ __________ ______.
___ ____ ____ _________ ____ ______ _______ _________ _________ _______ _____.
____ _________ ______ __________ ______ _____ __________ __________ _______ ______.
__________ _________ _________ ____ _________ ___ _____.
____ ______ ________ _____ __________ ___ _______ ____ ________ _________.
______ _____ ______ __________ ___ _____ ___ _________ __________ ________.
__________ __________ _____ _________ ________ ________ ____ __________ ___.
____ _____ __________ _________ _______ __________ ___ ___ ____ _____ ______.
___ _____ _________ _________ ______ _______ __________ ___.
__________ ___ _________ __________ _______ _____ ________.
_______ _________ _____ ____ ______ __________.
____ ______ _________ ___ ________ _______ ____ __________ _______ ____.
__________ _____ _______ ___ _____ _________ ______ ___ ____.
____ ______ __________ ____ ________ ___ ___.
______ ____ __________ ____ _______ _______ ____ __________ _____ _______ _______ ______.
______ _________ ___ __________ ___ _________ _________ __________.
____ ___ ____ ______ __________ __________ _______ ________ _____ ____ _______.
_______ ____ ____ _________ ______ ________ ____ ________ _________.
______ ___ _________ __________ _______.
____ ___ _______ ____ _________ ______ ___ ______ ____ ______.
__________ _____ ________ ________ _____ _____ ___ _________ ___.
_______ _______ _________ _____ ________ ___ ________ _________ ___ ______ _______ _______.
_________ _________ ______ ____ _____ ___ _______ ___ ______ _____.
___ _________ ________ ______ _________ ___.
_________ _________ ___ _______ ______ ___ ______ ___ _________.
_______ _______ ________ __________ __________ __________ ____ _______ ___ _________ ________.
_______ ___ __________ __________ __________ ________ ________ ______ ______ ___.
______ _______ _________ __________ ________ ________.
___ _____ _________ _______ _______ ________ ______ ________ ______ _______.
_____ _______ _______ _____ _________ _______ ___ ____ _________ ________.
____ ___ _________ ______ _____ _______ _________.
____ ______ __________ ___ ____ ________ ______ _________ ___.
________ ___ ________ ____ _____ ______ ____ ____ ____ ______ _________ _________.
___ ____ _________ ____ ______ ___ ______ _________ __________.
________ _________ ___ _______ __________ _______ ____ ____ ___ ____.
______ ____ ____ _______ ____ ___ _______.
___ ____ ________ ____ _________ _____ _____.
_________ __________ _____ ____ _____ ________ _______ ____ _____ _____ ____ ________.
______ ___ _____ ____ _____.
________ _________ ____ _______ ___ _____ _______ __________ ______.
____ __________ __________ ________ ________ ________ __________ ________ ____ _______.
____ ___ ____ ___ _______ _________ ___ ___ _____ ________ ___ __________.
_______ __________ ___ ___ ______.
__________ ____ _________ ____ _________ ___ ______ __________.
_______ ________ _________ _________ __________.
__________ _________ ___ ________ ______ ____ _____ __________ _____.
_______ _______ _______ _______ ______ _____ ___.
________ ___ ______ ________ __________ ______ ____ ___ _________ ___ ____ __________.
____ _________ _________ ___ _____ _____ _________ _________ ______.
_____ ________ __________ ________ __________.
______ _________ _______ ______ _______ _________ __________.
______ _____ _________ ______ _________ ___.
___ _______ __________ _____ _______ ___ _______ __________ ____ __________ ______ ________.
___ _____ __________ ______ __________ _______ ________ ___ ______.
______ _____ ____ _________ ______ _________ __________ _____ ________.
_________ _________ ______ __________ __________ ______ _________ __________ _______ __________.
__________ _____ _________ _________ ________.
___ _______ ________ ______ _____.
____ _____ ________ _______ _____ ______ _________ __________ ____ __________ ____ _______.
_______ ____ _________ ________ ________ ________ _________ ______ _____ __________ _________.
___ _____ ______ _____ ________ ________ ___ ___ _________.
______ _____ __________ ______ _________ _______ ___ ____.
_________ ____ _________ _____ ________ _________ ________ ______ _______ __________ ___.
_____ ________ __________ _______ ____ __________ _______ ___ __________ __________.
____ _______ ____ _________ _____ _______ ____ __________ _____ _____ __________.
___ ________ ___ ______ ________ _______ __________.
_______ ______ __________ ____ ____ ___ __________ ________.
_____ __________ ______ _____ _____.
____ ______ _______ ________ _____ ______ ___ __________ ____ ___ _________.
_______ ____ _____ __________ __________ ___.
________ ____ _____ ____ ___ __________ __________ ______ ______ _____.
________ ___ ________ ______ __________ ____ ________ _________.
__________ _______ ________ _________ _____ ________.
_________ ________ _______ _________ _______ _____ ______ ___ ___ _____ ______.
_________ ______ __________ _________ ____ ______ ________ ______ __________ _______.
___ ____ _________ ________ _________ _______ _____ _________ _____ ___ ____ _________.
____ ________ ____ _______ ________ _________ _______ ___ ____ _____ _______.
__________ ______ ____ _________ _____.
___ ______ ________ ______ _______.
____ ____ _______ ____ ___ _____ _________ ______.
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
→