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)

The Answer is in the image, click to view ...

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

1 Expert Approved Answer

Step: 1 Unlock 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!

Background You received the following table. The table record information about students and activity fees. Students can participate in many activities and each activity has different cost Given the...

This is all the information that was given to me for this question. nothing else was provided. Thank you Introduction Your job is identify the data files for a database Sales and Job Costing System...

Read the Accounting for Software Development Activities Case Study (link below). After reading the case study, answer the questions provided. While Ms. Larson is confident with regard to the U.S....

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

Complete the Bits Corporation exercises 1-6 containing red Advisorricum A of y. nasional and that 1. Comment and **. The following spendencies b pendencies that is a ble to an equivalent ie to an...

Middle Road Media: A Codification Research Case on the Accounting for Software Development Activities ABSTRACT: The accounting for software development costs is a complex issue within the financial...

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

Hi, Please put together Case 22-5 and 18-4 Using the following format: Cover Sheet Table of Contents Facts Analysis Conclusion Please make sure to rephrase all the content into one. I am attaching...

The instructions and background information for this case are in the file called Medical ABC_Case #2. The 8 questions that need to be answered are at the end of the document. The data used to answer...

Which of the following types of accounts has a normal debit balance? OA. Withdrawals OB. Assets OC. Expenses OD. All of these answers are correct.

The conference room was filled with the friendly buzz of chatter between colleagues when Marisa Hernandez entered. As she sat, she noticed that she was the last of the marketing staff to arrive for...

Mode Multiple Choice Question On January 3, ATA Company purchases a copy machine for $11,500. The machine is expected to last five years and have a salvage value of $1,500. Compute depreciation...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Have you taken course work in project management? What do you know about process documentation?

Knowledge of process documentation (process flow charting)

3. What management, organization, and technology issues did Arup have to address when selecting Project Online as its global project portfolio management tool?