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

0% completed

Vote For New Content
Solution to Exercise 1
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible