Explain this relational database system v luton_sport_club member @ Member_ID: int(7) First Name: varchar(50) Surname varchar(80) Address:
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
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
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these databases questions
-
a). Calculate the percentage price change of a bond for a 20 basis point increase in the yield if the bond's duration is 8.54 and the convexity is 58.66. (5% Marks) b). If the price of the Bond was...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
State whether the following statement are True or False: Assets = Owners Equity is also a possible scenario.
-
Calculate the present value of the decreasing annuity. 1. At the end of each month, for two years, $3000 will be withdrawn from a savings account paying 1.5% interest compounded monthly. 2. At the...
-
A part made from annealed AISI 1018 steel undergoes a 20 percent cold-work operation. (a) Obtain the yield strength and ultimate strength before and after the cold-work operation. Determine the...
-
What are the four Vs of big data?
-
Trieste Toy Company manufactures only one product, Robot Ranger. The company uses a standard cost system and has established the following standards per unit of Robot Ranger: During November, the...
-
Wile E. Coyote has a plan to drop an anvil on the roadrunner. He is standing on a cliff 26.2 m above the ground where the roadrunner will run past. If the roadrunner runs at a constant 9.2 m/s. If...
-
8.1 Create a one-way data table for profit at different levels of supplier contact in range B22:C33. Ensure that the price in cell C3 is $290 and the advertising budget in cell C5 is $35,000,000 (you...
-
* Referring to the serviceNow Now Learning Portal courses forthis module answer the below questions * What isaccess control and why is it important? * Whatwould be the potential risks associated with...
-
We cannot be obligated by people who do work for us without our knowledge. Why?
-
What is the test in most Canadian provinces for establishing the liability of occupiers for injury to lawful visitors? Are trespassers treated differently?
-
Explain the different rules that apply to offer and acceptance when, rather than using the postal system, the parties communicate by telephone.
-
What is the special meaning of public law as distinct from private law?
-
Explain why a legal rule in one province may differ from that in another province.
-
Examine the following summary of the U.S. balance of payments for 2000 (in $ billion) and fill in the blank entries. (1.1) Merchandise (1.2) Services (1.3) Factor income (2) Imports (2.1) Merchandise...
-
For each of the following, discuss which data-gathering method(s) are most appropriate and why: a. Examining the adequacy of internal controls in the purchase requisition procedure. b. Identifying...
-
What internal control procedure(s) would provide protection against the following threats? a. Theft of goods by the shipping dock workers, who claim that the inventory shortages reflect errors in the...
-
From the database created in the comprehensive problem, perform queries based on the tables and query grid shown in Table 4-19. a. Which borrowers use Advent Appraisers? b. What is the average amount...
-
At the beginning of April one year, the silver forward prices (in cents per troy ounce) were as follows: The carrying cost of silver is about 20 cents per ounce per year, paid at the beginning of...
-
Suppose that a forward contract on an asset is written at time zero and there are \(M\) periods until delivery. Suppose that the proportional carrying charge in period \(k\) is \(q S(k)\), where...
-
The current price of gold is \(\$ 412\) per ounce. The storage cost is \(\$ 2\) per ounce per year, payable quarterly in advance. Assuming a constant interest rate of \(9 \%\) compounded quarterly,...
Study smarter with the SolutionInn App