Question: Writean SQL statement that will insert the data into Occurrence_Exercise tableonly. Definition of rep stands forrepetition. Each exercise attempt has the rep number as indicated

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

18151515

Light

9002

002A

18707570

Medium

9003

003A

212909590

Heavy

9004

004A

312200200200

Medium

9005

006A

38110110115

Heavy

9006

005A

4102025 

Medium

9007

001A

48101210

Medium

9008

002A

588590115

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

Step by Step Solution

★★★★★

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To insert data into the OccurrenceExercise table you can use an SQL INSERT INTO statement Youll need ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

Insert the data into the tables you created in Problem1. Database name: Ch08 SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME | CUST FNAME CUST BALANCE 050.11 840.92 CUST NUM...

Q:

The following data are from Gennings, Chinchilli, and Carter, (1989). An in vitro toxicity study of isolated hepatocyte suspensions was conducted to study the impact of combining carbon tetrachloride...

Q:

1. Using the table information above, write a SQL statement that will return only the following fields: Animal name, Animal type, Animal breed, Owner name, Owner address (street, city, state, zip)...

Q:

Write a SQL statement that will insert the data above into the Student table with the information listed above Student Length 9 50 Other Primary Key Decimals Nulls? No Type Column STUDENT NUM Char...

Q:

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Q:

1 . Create a a database DB _ consultation 2 . Create the following tables Patient ( PatientID , Name, Age, Gender ) Doctor ( DoctorID , Name, Speciality ) Treatment ( TreatmentID, DoctorID,...

Q:

Database Mangagement (SQL) Please help with this. I am out of town due to a family emergency. I need to turn in by Thursday. Thank. Please message me with any questions you have so we can coordinate...

Q:

Web programming 1.) MySQL: a.) Write SQL commands to create a database called my_db (Imk) b.) Write SQL commands to create the following tables; ustomer (CustomerlD, Persons (PersonI , CustomerName,...

Q:

Some Business Theme Examples: Banking data management Insurance data management Manufacture Inventory Management Airline data management Bookstore data management College data management Library data...

Q:

The increases (in cents) in cigarette taxes for 17 states in a 6-month period are 60, 20, 40, 40, 45, 12, 34, 51, 30, 70, 42, 31, 69, 32, 8, 18, 50 Use the range rule of thumb to estimate the...

Q:

3 Reddy Company has the following cost formulas for overhead: Cost Formula Cost Indirect materials Maintenance Machine setup Utilities Depreciation $2,000 plus $0.40 per machine hour $1,500 plus...

Q:

Find the derivative of the following function. g ( x ) = x 6 5 x 5 6 x 6 g ' ( x ) =

Q:

5 points : Using a suitable size ROM, design a Hex to Gray code converter circuit. What is the size of ROM required? Insert solution ( handwriting) Using a PLA, Design a circuit that implements the...

Q:

what is inside the router?

Q:

The ability to communicate in a personally effective and socially appropriate manner Elements of competent communication 1. Respect 2. Empathy 3. Tolerance 4. Flexibility 5. Interaction management...

Q:

Which of the following control measures calls for the use of work processes and scheduled breaks to reduce an employees exposure to hazards?Multiple ChoicePPEEliminationSubstitutionEngineering...

Q:

You are employed as a DBA for a medical practice. You have implemented multiple safeguards to protect patient privacy and conform to HIPAA regulations. What other practical, common-sense measures...

Q:

For the following exercises, you will address problems and answer questions from the Solmaris Condominium Group staff. You do not use the Solmaris database for any of these exercises. 1. The log...

Q:

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...

Q:

The following table shows a breakdown of the 113th U.S. Congress by party affiliation. a. A member of Congress is selected at random. What is the probability of selecting a Republican? b. Given that...

Q:

What do you see as being the primary challenges to introducing a project management philosophy in most organizations? That is, why is it difficult to shift to a project-based approach in many...

Q:

1) Suppose you were a project manager for Disney. Based on the information in this case, what critical success metrics do you think the company uses when designing a new ride; that is, how would you...