Solution to Exercise 1

Here is the table again, so you can check your working against it.

Employee_ID	Employee_Name	Project_ID	Project_Name	Project_Manager
101	Anita	P1	Alpha	Rohit
101	Anita	P2	Beta	Sarita
102	Bala	P1	Alpha	Rohit
103	Chandra	P3	Gamma	Anita

Step 1. The primary key

Employee_ID alone does not work. Employee 101 appears on two rows.

Project_ID alone does not work either. Project P1 appears on two rows.

Together they do. The pairs are (101, P1), (101, P2), (102, P1) and (103, P3), and no pair repeats.

.....

Like the course? Get enrolled and start learning!

Reading Progress