Explain this relational database system v luton_sport_club member @ Member_ID: int(7) First Name: varchar(50) Surname varchar(80) Address:

Explain this relational database system

 

Transcribed Image Text:

v luton_sport_club member @ Member_ID: int(7) First Name: varchar(50) Surname varchar(80) Address: text Email: varchar(80) # Contact: int(15) Date of Birth date Medical Condition: text VO luton sport club extra activities Non Sports Activity: varchar(15) Activity Start From 06.00 am : timestamp Activity Ending Time at 10.00 pm: timestamp # Duration for activity int(10) # Member ID int(7) VO luton sport club class Class Code int(7) # ID : int(7) # Member_ID: int(7) Sports Name: varchar(15) @ Non Sports Activity varchar(15) Class Start from 9am: timestamp Class finish at 05.00 pm datetime(6) # Class Duration Max 2 hrs : int(7) v luton sport club staff ID : int(7) First Name: text Surname: text @Role: text contact: int(10) v luton_sport_club member @ Member_ID: int(7) First Name: varchar(50) Surname varchar(80) Address: text Email: varchar(80) # Contact: int(15) Date of Birth date Medical Condition: text VO luton sport club extra activities Non Sports Activity: varchar(15) Activity Start From 06.00 am : timestamp Activity Ending Time at 10.00 pm: timestamp # Duration for activity int(10) # Member ID int(7) VO luton sport club class Class Code int(7) # ID : int(7) # Member_ID: int(7) Sports Name: varchar(15) @ Non Sports Activity varchar(15) Class Start from 9am: timestamp Class finish at 05.00 pm datetime(6) # Class Duration Max 2 hrs : int(7) v luton sport club staff ID : int(7) First Name: text Surname: text @Role: text contact: int(10)

Answer rating: 100% (QA)

The relational database system shown in the image is for a sports club called Luton Sport Club It consists of three tables lutonsportclubmember This t... View the full answer