It is possible for customers to have their classes at the sport club facilities

It is possible for customers to have their classes at

This preview shows page 2 - 5 out of 6 pages.

of the class ( Beginner, Intermediate or Advanced) followed by the name of the discipline taught. It is possible for customers to have their classes at the sport club facilities, registered as In-house, or at a remote location, registered as Outside. Coach CoachID Specialty HiredYear Contract 100 Gymnastics 2016 Full time 101 Swimming 2019 Part time 102 Swimming 2015 Full time 103 Tennis 2014 Full time 104 Boxing 2020 Part time Customer CustomerID CustName Age Membership 3001 Pixie Wiggins 22 3-Months 3002 Jorgie Sellers 31 6-Months 3003 Johnnie Forrest 34 Annual 3004 Taylah Ayers 27 3-Months 3005 Sharna George 26 Annual 3006 Vienna Harrell 30 3-Months 3007 Gurleen Barr 25 Daily 3008 Aria Villalobos 30 6-Months
Image of page 2
Classes ClassID CoachID CustomerID ClassName Location Duration SW0451 101 3003 Intermediate Swimming In-house 60 T145 103 3001 Beginner Tennis Outside 45 T101 103 3003 Intermediate Tennis Outside 60 B145 104 3007 Beginner Boxing In-house 30 GYM145 100 3002 Beginner Gymnastics In-house 30 SW0123 102 3002 Advanced Swimming In-house 60 GYM147 100 3008 Advanced Gymnastics Outside 90 Relational Model
Image of page 3
The following questions relate to Chapter 6 Question 1 (10 pts) : For each of the table displayed above, write the SQL statements that will create the table. Use the following information to define your data types : ( Use the relational model to derive primary and foreign keys ) CoachID (integer) Specialty (20 characters) HiredYear (integer) Contract (10 characters, only values Full time and Part time allowed) CustomerID (integer) CustName (30 characters) Membership (20 characters) Age (integer) ClassID (10 characters) ClassName (30 characters) Location (10 characters, only values In-house and Outside allowed) Duration (integer) The data values in the tables above are for example purpose only. You are not required to enter any
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • B MAK
  • Deltron 3030, 31st century

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask 0 bonus questions You can ask 10 questions (10 expire soon) You can ask 10 questions (will expire )
Answers in as fast as 15 minutes