Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started