Writean SQL statement that will insert the data into Occurrence_Exercise tableonly. Definition of rep stands forrepetition. Each
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write an SQL statement that will insert the data into Occurrence_Exercise table only.
- Definition of rep stands for repetition.
- Each exercise attempt has the rep number as indicated in the occurrence table.
Occurrence Table
OccurrenceID | Occ_Date | Occ_Place | Occ_Start_Time | Occ_Finish_Time |
1 | 14/03/18 | University_Gym | 16:00:00 | 16:30:00 |
2 | 15/03/18 | University_Gym | 16:30:00 | 17:00:00 |
3 | 16/03/18 | University_Gym | 16:10:00 | 17:20:00 |
4 | 17/03/18 | Home | 07:00:00 | 08:00:00 |
5 | 17/03/18 | University_Gym | 17:00:00 | 18:00:00 |
Occurrence_Exercise Table
OccExID | ExerciseNo | OccurrenceID | Rep | Attempt1 | Attempt2 | Attempt3 | Condition |
9001 | 001A | 1 | 8 | 15 | 15 | 15 | Light |
9002 | 002A | 1 | 8 | 70 | 75 | 70 | Medium |
9003 | 003A | 2 | 12 | 90 | 95 | 90 | Heavy |
9004 | 004A | 3 | 12 | 200 | 200 | 200 | Medium |
9005 | 006A | 3 | 8 | 110 | 110 | 115 | Heavy |
9006 | 005A | 4 | 10 | 20 | 25 | Medium | |
9007 | 001A | 4 | 8 | 10 | 12 | 10 | Medium |
9008 | 002A | 5 | 8 | 85 | 90 | 115 | Heavy |
Exercise Table
ExerciseNo | ExerciseDescription | ExerciseType |
001A | Situps | Abs |
002A | Bench Press | Chest |
003A | Dead Lifts | Back |
004A | Leg Press | Legs |
005A | Seated Shoulder Press | Shoulders |
006A | Squats | Legs |
007A | Lat pull downs | Lats |
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: