Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started