Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions