Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Department of Information Technology ITCS 323 - Database Systems: Design and Application In-Class Exercise - 1 Assume you have provided with Employee Activity and Trainer

image text in transcribedimage text in transcribed

Department of Information Technology ITCS 323 - Database Systems: Design and Application In-Class Exercise - 1 Assume you have provided with Employee Activity and Trainer tables as follows: Employee_Activity Emp No FirstName Phone No. Activity Cost 004 004 200 Ali Hussain Ali Hussain Basem Dorazi Basem Dorazi Ali Hussain Zainab Mohamed Zainab Mohamed Zainab Mohamed 200 37006699 37006699 32323211 32323211 37006699 36666677 36666677 36666677 Basketball Football Tennis Swimming Tennis Golf Swimming Squash Trainer ID 2084 1282 2200 2200 3434 5645 2200 1809 $200 $220 $140 $150 $140 $180 $150 $200 004 229 229 229 Trainer Instructorld 2084 1282 2200 3434 5645 First Name Hussain Mohamed Abbas Yusuf Adnan Abdulla Last Name Ali Abdulla Hasan Mohamed Yusuf Hussain Phone 33922266 34567890 32345678 36000098 36565659 33224455 1809 Write the keys in each table: Student Activity: Key Super key Candidate Key Primary key Alternate Key Foreign key Instructor: Super key Candidate Key Primary key Alternate Key Foreign key

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

More Books

Students also viewed these Databases questions