Relational Database Design and Modeling for Software Engineers
Ask Author
Back to course home

0% completed

Vote For New Content
Solution to Exercise 1
On this page

Analysis

Step 1: Identify the Primary Key

  • The table's primary key is a composite key consisting of {Employee_ID, Project_ID} because:

    • An Employee can work on multiple Projects.
    • A Project can have multiple Employees working on it.

Step 2: Check for Partial Dependencies

  • Partial Dependency occurs when a non-key attribute depends only on a part of the composite primary key.

  • Identify Dependencies:

    1. Employee_Name depends only on Employee_ID.
    2. Project_Name and Project_Manager depend only on Project_ID

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page