Answered step by step
Verified Expert Solution
Link Copied!

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 

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... 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_2

Step: 3

blur-text-image_3

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

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these Databases questions