Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Explain this relational database system 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
Explain this relational database system
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)
Step by Step Solution
★★★★★
3.49 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
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...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