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: This entity has the following attributes:
  - DepartmentID (Primary Key)
  - DepartmentName
  - DepartmentLocation

- Project: This entity has the following attributes:
  - ProjectID (Primary Key)
_______ _________ _________ ______ ______ _______ ____ _____ ___ ___ ___ ______.
___ __________ ________ _________ ___ ________ ____ ___.
__________ _________ _________ _____ ______ ____ ____ _____ ____ __________.
_________ _________ _____ ________ ______ ________ ____ ________ ____ ______.
_________ _____ ___ _______ ___ ______ __________ _____ _______ _________ _________.
______ _____ ____ _____ ___ ____ __________ __________ ___ ________.
____ __________ __________ ___ __________ ____.
_______ _______ ___ __________ ___ _______.
_____ ______ _______ _________ _______ ______.
____ _________ _________ ______ ___ ________ ______ __________.
_______ _________ ____ ____ ________.
_________ ___ ___ ________ ______ _________.
__________ __________ _____ _________ _______.
_________ ______ ____ __________ _________ _________ _____.
_______ _________ ______ ________ ____ ____ ______ _____.
________ ______ ______ ____ ______ __________ _________ _________ __________ ______ ________.
_____ _________ ___ _____ ________ _____ ______.
_____ ___ ______ ________ __________ __________ _______ _________ _____ ________ ___.
________ _________ ______ __________ ________ _________ __________.
______ ___ __________ _________ _______ __________ _____ __________ _____ __________.
_________ _________ ________ ____ ________ ______ ____ _______ ______ ___ ________ ________.
_______ ________ _________ ______ _______ ______ ____ ________ _______.
___ _____ ________ _________ _____ _______ _______ _______ ___.
___ _________ ______ ___ _______ _____.
______ ______ __________ ________ ____ _______ ______ ____.
_________ __________ ______ _______ ___.
____ _______ _________ _____ _______ ______ _______ ___ _____ __________ ________ __________.
__________ _____ __________ ______ ____ ____ ______ ______ _________ _______ ________.
______ ___ ____ ___ _________.
____ __________ _________ ______ __________ _________ __________.
____ _______ ________ ___ __________ ______ _______ ________ __________ ________ ____ ___.
_____ ________ _____ _________ ____ _____ _________ _________ ___.
______ ____ ____ ________ _____ ________ __________ ________ ____ ______ __________.
__________ ___ _____ ___ ___ ________ _______.
______ _________ _______ _______ ______ ______ _______ ___ _________ _____ ________.
_________ ___ ______ ______ ______ _____.
_________ ____ _________ __________ __________ ____ ________ _____ ___.
__________ __________ ____ __________ ___ _______ ____ __________ ___ ____ ___.
___ _________ _____ _____ ______ ________ ______ _________ _____ _____ ______ ________.
_______ __________ ________ _____ ___ __________.
_____ ______ _____ _________ ___ ____ _______ _____.
___ _____ _____ ____ ______ ________ _____ __________ ________ _________ _______ ____.
_________ ___ _______ __________ _____ _____.
____ ___ ______ _______ _____ ____ _________ _________ ____ ____ ____ _________.
_____ _______ _____ __________ ________ ____ _________ __________ _____ ________.
________ ________ __________ _____ _________ __________ _______ ____ ______ __________ __________ ______.
_________ __________ _________ __________ _______ __________ _______ ____ _________ ______.
_____ ______ ___ ________ _______ ________ ____ ______ _____ ______.
________ _____ ____ _______ __________.
_____ ________ ______ _________ ____ ____ ________ _________ ______.
_____ __________ ____ _____ ______ ___ __________ ___ _________ _____ _____.
_______ ___ __________ _____ ______ _____.
___ _____ _____ __________ ____ __________.
_______ ___ _______ _____ _________ _______ ________ ____ _______ ____.
________ _____ __________ __________ ______ ___ ___ ___.
_______ ___ _______ _________ ________ _______ __________.
________ ___ ___ _________ _______ ________ ___ __________.
__________ _____ ___ __________ ____ __________ _______ _____ _____.
_____ ___ ______ ______ ________ _________.
___ ________ ______ _________ ______ _______ ________ _________ _________.
_____ ________ __________ _____ _______ ______ __________ ___ ______ __________ _______.
________ __________ _________ ______ _________ __________ ________ ______.
____ _______ __________ ___ _____ ________ ______ ___ _________ __________ ___.
________ __________ _____ ________ ___ ____ ________ ______ _________ ______ ______.
_____ ____ _________ ________ ______ ____ ________.
________ _____ ______ _________ ____.
__________ __________ __________ _________ __________ __________ _______ ____ ______ _____.
_________ ____ _________ _____ ___ _______ _________ _______.
____ ___ _____ ___ _______ _____ __________ _____.
__________ _______ _____ _______ ____ ___ _________ ____ _____ _______ _________ ____.
_____ ___ ________ __________ ________ __________ ___ ____ _____ ___ ________ ______.
______ ___ ________ _______ _____ ______.
________ _________ _________ ____ ____ _______ ________ _______ _______ _________ ____.
_________ _____ __________ _______ _______ _______ _________ ___ _________.
_________ __________ _________ _________ ________ ___ ___ ___ ______ _____ _______ ________.
_____ _________ _______ __________ _______ __________ ______ ________ _______ _________ _______ ___.
_______ _________ ___ ____ ____ _______ ____ ________ __________.
_________ _________ ____ _________ _______ ________.
____ ______ ________ __________ ________ ___ __________ ____ ____ _____ _________.
______ ______ __________ ______ ______ _______ ____ _________ ______ __________ _______.
________ _______ _________ _____ ________ _________ ________ _________ ______ _______.
_______ _______ _________ _________ ________ ____ ______ ______ ____.
___ _______ _____ ______ _______ ___ _______ ______.
__________ _______ _________ _______ _________ ______ ____ ______ _______.
_______ ________ _________ __________ _________ ________ ___.
_______ _________ _________ __________ _________ ________ ____ __________ _____ ______ ______.
________ _______ ___ _________ __________.
________ _____ ______ ______ ________ __________ _____ ________ __________ __________ ________ _________.
_____ ____ _____ _______ _____ __________ ____ ___ _____ _________ _______ _______.
___ ___ __________ ____ __________ ___ _______ _____ ______ ___ ____ ______.
___ ___ ______ ______ ___.
__________ ____ ___ ____ ___ _________ ___ _______ _______ ________.
_________ ____ ___ __________ ____ ________ _____ ______ ________.
___ ____ _________ _______ ____ ____ _____ ____ _______ ________ __________ ______.
______ ____ _______ ____ ______ ______ ________ ____ ___ __________.
Get Full Answer on WhatsApp

Related Questions

A University maintains the list of the books available in its library using a database system. In
addition, this system is used for issue and return of books to its students. This database is used to find
the following details by the students of the university and the staff of the library:
 List of the classification number, ISBN number, Title, Author Names, Subject Area of the
books.
 Searching of books using subject area, Title and Author name.
 List of books that are issued to a specific student.
Draw an ER diagram for the library. Specify key attributes and constraints on each entity type and
on each relationship type. Note any unspecified requirements and make appropriate assumptions to
make the specification complete.

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions.

 

    Transaction  A

       Transaction  B       Transaction  C
        Read  X        Read  X          Read X
        Read  Y        ADD    500           SUBTRACT 200
        Raed  Z        W r i t    X             WRITE  X
         Read   Y  
       SUBTRACT  500  
        W r i t e Y  

                              Figure 1: Three Concurrent Transactions

Explain the concept of Multi-valued dependency and Join dependency with the help of an example of each. Also, explain the 4th Normal Form and 5th Normal form.

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

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions

Explain the three level DBMS architecture with the help of an example. Also, explain the concept of data independence in the context of database systems with the help of an example. 

 Write short notes on the following database technologies: (i) Distributed databases (ii) Block chain databases

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
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
→