Question Details

[answered] BUSA 326 - Fall 2016 - Extra Credit Due December 7th by 11:


Please provide the SQL statements necessary to find the data listed on the attachments. There is two assignments listed on here that should be done separately using the same SQL file.?


BUSA 326 ? Fall 2016 - Extra Credit

 

Due December 7th by 11:59PM

 

Worth 5 Points Scenario: You work for a DVD rental company. Your manager has asked you to pull some data on the company, its inventory, and

 

customers. You will complete this by developing and running SQL queries. Initialize Your Database (NOTE: If you already did this in Project 1, you do not need to do this step again):

 

1. Download RentalCompany.sql from Doc Sharing.

 

a. Run the script to create tables and data. You should not receive errors. There may be a few

 

warnings, but that is okay.

 

b. To verify you created all tables, run the following SQL:

 

SELECT TABLE_NAME, TABLE_ROWS, TABLE_TYPE, CREATE_TIME FROM

 

`information_schema`.`tables` WHERE `table_schema` = 'rentalcompany' AND TABLE_TYPE =

 

'BASE TABLE';

 

Your results should look like the table below. This will help verify that you properly created the

 

schema/database and tables. actor

 

address

 

category

 

city

 

country

 

customer

 

film

 

film_actor

 

film_category

 

film_text

 

inventory

 

language

 

payment

 

rental

 

staff

 

store 200

 

603

 

16

 

600

 

109

 

599

 

1000

 

5462

 

1000

 

1000

 

4581

 

6

 

16086

 

16005

 

2

 

2 BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE

 

BASE TABLE Directions:

 

Note: For any UPDATE, INSERT, or DELETE statements that you construct as your answers to the questions below,

 

you MUST provide and label the following components:

 

? Initial validation section with your SELECT statement

 

? Run section with transaction, commit, and rollback statements

 

? Final validation section with you SELECT statement

 

? You must have a semicolon after every statement so I can highlight several statements at once and

 

run them at once.

 

Failure to constructs your answers in this format will result in significant point deductions.

 

All of the objectives below were demonstrated in tutorials. 1. Create a table by copying the existing actor table. Name the new table YourName_Actor. Copy the table

 

structure and all 200 records.

 

2. Add a record to the newly created table with your name as the new actor.

 

3. Update the first name in the record that you just created in #2 with a first name of Anna.

 

4. Delete only the record that you created in #2. This means that the resulting table should look just like the

 

existing actor table in the end. Grading:

 

? In addition to meeting all the specified criteria under the Directions section, you must use the Beautify

 

feature in MySQL so your SQL is easily readable. ? Points will be deducted if each question is not clearly labeled within your SQL file. You will do this by

 

commenting out the descriptive line with the pound sign as shown in the MySQL Expressions tutorial video.

 

See example below. Your final file will have a comment, then sql statement, then comment, then sql

 

statement, etc. ? To grade your file, I will open your .sql file in my version of MySQL and click run. If your SQL does not run,

 

points will be deducted. Next, I will determine if your SQL was written correctly and returned the correct

 

data results. Complete all of Extra Credit using MySQL and turn it in to the Extra Credit Dropbox as a .sql file named

 

?YourLastNameExtraCredit.sql? by the due date.

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001005850.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now