Question: Identify the primary key, foreign key, candidate key and composite key from the given tables. (Note: If a table does not contain any particular key

 Identify the primary key, foreign key, candidate key and composite key

Identify the primary key, foreign key, candidate key and composite key from the given tables. (Note: If a table does not contain any particular key mention it as none e.g.: foreign key = none) 1) Id | Name | Gender | City | Email Dep_Id 1 2 3 4 5 Ajay | Vijay | Radhika | Shikha | Hritik IM M F F M | Delhi ajay@gmail.com Mumbai | vijay@gmail.com Bhopal | radhika@gmail.com | Jaipur | shikha@gmail.com Jaipur hritik@gmail.com 1 2 1 2 2 TEXT University of Management and Technology 2) Course enrollment table: Course_ld Stu_ld C01 101 CO2 102 CO3 101 CO5 102 C06 103 CO7 102 Student table: Stu_ld Stu_Name Stu_Age 101 Chaitanya 22 102 Arya 26 103 Bran 25 104 Jon 21 3) Emp_Id Emp_Number Emp_Name E01 E22 E23 E45 2264 2278 2288 2290 Steve Ajeet Chaitanya Robert

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!