Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DataBase: The table record information about students and activity fees. Students can participate in many activities and each activity has different cost. Given the STUDENT_ACTIVITY

DataBase:

The table record information about students and activity fees. Students can participate in many activities and each activity has different cost.

Given the STUDENT_ACTIVITY Table:

Student_ID

LastName

FirstName

Activity

ActivityFee

100

Jameson

Ada

Golf

165.00

200

Deluna

Lisa

Skiing

200.00

300

Storms

Peter

Skiing

200.00

300

Storms

Peter

Swimming

50.00

400

Whitman

Sara

Skiing

200.0

400

Whitman

Sara

Swimming

50.00

500

Lee

James

Tennis

30.00

600

Kalanick

Brian

Swimming

50.00

1. Select your database area, then click on the SQL table and write DDL to create STUDENT, ACTIVITY, STUDENT_ACTIVITY tables. (Paste the create table statement here)

2. Insert raw data to your empty tables (Populate your tables) ( Paste the insert sql here)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions

Question

Knowledge of process documentation (process flow charting)

Answered: 1 week ago