Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DATABASE MANAGEMENT (MYSQL) Functional dependencies in tables I would be very happy if you could show it. GYM_ID 1 2 3 GYM_Name Max Fitness Max

DATABASE MANAGEMENT (MYSQL) Functional dependencies in tables I would be very happy if you could show it.

image text in transcribed

GYM_ID 1 2 3 GYM_Name Max Fitness Max Fitness 2 Max Fitness 3 GYM_Address 3001 sok no 3 zmir 5069 sok no 1 Izmir 8257 sok no 8 Izmir GYM_PhoneNumber GYM_Email 2322264639 maxfitness@gmail.com 2322386745 maxfitness2@gmail.com 2325247890 maxfitness3@gmail.com GYM_OpeningYear 2005 2012 2020 Table1 NU > Manager_ID 1 2 Manager_Name Volkan Emel Murat NULL Manager_Surname Manager_Salary($) Manager_Salary($) Manager_StartingDate Manager_PhoneNumber Ekinci 15000 2005-02-02 5347234598 Ekinci 10000 2012-01-01 5325792837 Ekinci 8000 2020-03-03 5379478235 NULL NULL NULL NULL Table2 3 NULL Gym_ID Manager_ID 1 1 Employee_ID 1 2 3 1 Employee_Name Employee_Surname Employee_Gender Employee_Job Ekin Togay Male Personel Trainer Yonca Gken Female Personel Trainer Atakan Arabaci Male Personel Trainer Alaattin Egemen Male Cleaning staff Hasan Doramac Male Personel Trainer Ayegl Adgzel Female Personel Trainer Employee_Salary($) Employee_StartingDate Employee_PhoneNumber 5000 2006-09-01 5324256789 5000 2008-10-02 5428628492 5000 2007-02-06 5055518012 2000 2005-03-08 5428628496 5000 2013-09-11 5067624769 5000 2016-05-03 5067648724 1 1 1 Table 3 1 1 1 4 5 6 2 2 2 2 Membership_ID 1 2 3 4 Table 4 5 6 7 8 9 10 11 Customer_ID Membership_Type Membership_Fee(s) 1 Fitness 10000 1 BodyBuilding 20000 2 BodyBuilding 20000 3 Fitness 10000 4 BodyBuilding 20000 5 BodyBuilding 20000 6 Fitness 10000 6 BodyBuilding 20000 7 BodyBuilding 20000 8 Fitness 10000 8 BodyBuilding 20000 Customer_ID Customer_Name Musa 1 Customer Surname Tung ay akrak ztekin Gkek Akgl Erol Customer_Gender Male Male Female Male Female Female Male Atakan Bra Murat Sultan Jale Erding Customer_CardNo 492987672728 1852 4532439059168673 4556367020263607 5454878142695328 5328871652265891 5296085538280838 6011388440531914 Customer_PhoneNumber 5055518066 5555570 158 5355579367 5486254186 5070498042 5067648769 5567194278 Customer_Address 3027 sok no 2 d 2 Izmir 3058 sok no 6 d 8 zmir 3092 sok no 8 d 3 zmir 3047 sok no 3 d 5 zmir 5029 sok no 2 d 9 Izmir 5235 sok no 6 d 2 zmir 5862 sok no 9 d 1 Izmir Table 5 4 4 5 6 7

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

Database Horse Betting The Road To Absolute Horse Racing 2

Authors: NAKAGAWA,YUKIO

1st Edition

B0CFZN219G, 979-8856410593

More Books

Students also viewed these Databases questions