Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored 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